What is the main task of database logic design

This article will explain in detail what is the main task of database logic design. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

The main task of database logic design is to create database schema. The main work of database logic design is to design the real-world conceptual data model into a logical pattern of the database, that is, to adapt to the logical data model supported by a particular database management 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.

The design content of database design includes: requirement analysis, conceptual structure design, logical structure design, physical structure design, database implementation and database operation and maintenance.

Among them, the logical structure design of the database

It is to transform the basic entity-relationship diagram designed in the conceptual structure design stage into a logical structure consistent with the data model supported by the selected database management system product.

The main work is to design the real-world conceptual data model as a logical pattern of the database, that is, to adapt to the logical data schema supported by a particular database management system. At the same time, it may be necessary to generate corresponding logical subpatterns for various data processing applications. The result of this step is the so-called "logical database".

Design steps

(1) transform the conceptual structure into a general relational, mesh and hierarchical model.

(2) transform the transformed relational, mesh and hierarchical model to the data model supported by the specified database management system.

(3) optimize the data model.

On what is the main task of database logic design is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.