Fundamentals of Database Design

Database design is divided into requirements analysis, conceptual design, logical design and database physical design four parts.

1. Demand Analysis:

Stage Result: Requirement specification.

2. Conceptual structure Design:

Conceptual structure design is to synthesize, generalize and abstract the user's needs, and form a conceptual model independent of the specific DBMS.

Conceptual structure design typically has four methods: bottom-up, top-down, out-of-the-box (gradual expansion), and hybrid strategy.

Stage results:er diagram .

3. Logical Structure Design:

Converts a conceptual data model that is not related to a DBMS into a logical model on a particular DBMS. Also known as the conceptual model.

Phase results: relational model .

4. Physical Design:

The logical model which satisfies the user's requirement in the logic design stage is realized physically. The main content is to determine the data storage structure, the access path of the design data, determine the location of the data and determine the system configuration according to the various means provided by the DBMS.

　　

Fundamentals of Database Design