Database Design in Project

The design of a database system is more than just a design time. In this classmate's interview process has designed to, so once again turned out before the textbook to the whole book database design has left a number of new discoveries. Share to everyone:

First of all, the database design is divided into four parts:

Defining Data structures

Data loading

Compile and debug

Trial run

(a) Define the data structure: the main is to determine the database model design including conceptual model, logical model and physical model. The conceptual model is mainly embodied by the design of ER diagram, and the logical structure is used to design the relationship model by three paradigms, and the physical structure is mainly the design of the table.

(ii) Data loading: Transfer of data to a database. In small enterprises, mainly through the manual data, including format conversion, input data, calibration data, data loading in large and medium-sized enterprises are divided into the following five steps: Data filtering, data input, data validation, data conversion, data synthesis.

(iii) Compiling and debugging the application: This step is synchronized with blocking data inbound synchronization. Note When you debug an application, you can use the simulation data first because the data is not finished.

(iv) database test run: can also be a joint debugging, divided into functional and performance testing two parts.

Database Design in Project