Shulou(Shulou.com)06/02 Report--

Editor to share with you the steps of database design, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

Steps: 1, requirements collection and analysis, get data dictionary and data flow diagram; 2, synthesis, induction and abstraction of user requirements to form a conceptual model; 3, transform the conceptual structure into a data model; 4, design the physical structure of the database; 5, establish a database, compile and debug applications, and organize data storage; 6. Evaluate, adjust and modify the database system.

Database design (Database Design) refers to the construction of an optimal database schema and the establishment of a database and its application system for a given application environment, so that it can effectively store data and meet the application needs of various users (information requirements and processing requirements). In the field of database, all kinds of systems that use database are often referred to as database application system.

Database design is the technology of establishing database and its application system, and it is the core technology in the development and construction of information system. Because of the complexity of the database application system, in order to support the operation of related programs, the database design becomes extremely complex, so the best design can not be achieved overnight, but can only be a process of "repeated exploration and gradual refinement". That is, the process of planning and structured database data objects and the relationship between these data objects.

Steps for database design

(2) Conceptual structure design stage: synthesize, induce and abstract user requirements to form a conceptual model, which is represented by Emurr diagram.

(3) logical structure design phase: the conceptual structure is transformed into a data model supported by a DBMS.

(4) the physical design phase of the database: select a physical structure most suitable for the application environment for the logical data model.

(5) the implementation stage of the database: establishing the database, compiling and debugging the application program, organizing the data into the database, and running the program.

(6) the stage of database operation and maintenance: evaluate, adjust and modify the database system.

The above is all the contents of this article "steps of Database Design". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.