MYSQL database design and database design example (1) _ MySQL

MYSQL database design and database design example (I) preparations before bitsCN.com database design and database design

Database design: database design refers to the Construction (design) of a database logical mode and physical structure for a given application environment, and the establishment of a database and its application system accordingly, it enables effective storage and management to meet the needs of various users, including information management requirements and data operation requirements.

Information management requirements: Information Management requirements refer to the data objects that should be stored and managed in the database.

Data operation requirements: data operation requirements refer to the operations required for data objects, such as adding, deleting, modifying, and querying statistics.

General steps for database design:

1. Requirement Analysis
2. Conceptual Structure Design
3. Logical structure design
4. Physical structure design
5. Database implementation, operation and maintenance

The following describes the general functions of these six processes:

Requirement Analysis: integrates the application requirements of various users.

Conceptual Structure Design: convert some literal concepts into E--R diagrams (commonly used ).

Logical structure design: it is generally to convert the E--R diagram into the data model supported by the database products, such as the relational model, form the logical model, and then add the view according to user requirements to form the external mode.

Physical Structure Design: arranges physical storage based on DBMS characteristics and processing requirements, establishes indexes, and forms the internal database mode.

Database implementation, operation, and maintenance: after the database application system is put into operation after trial run, it is constantly modified and maintained during the operation of the database application system.

The following describes the general process of designing a database based on the database design steps. a database design example is provided.

BitsCN.com