Home >Database >Mysql Tutorial >What are the basic principles of database design?

What are the basic principles of database design?

王林
王林Original
2020-06-28 14:12:104030browse

The basic principles of database design are: 1. Store data with the same theme in a data table; 2. Try to eliminate redundancy and improve the speed of accessing the database; 3. In a relational database, each data The relationship between tables can only be one-to-one and one-to-many.

What are the basic principles of database design?

Basic principles of database design:

(Recommended tutorial: mysql tutorial)

( 1) Store data with the same topic in a data table, "one table for one use";

(2) Try to eliminate redundancy and improve the speed of accessing the database;

( 3) It is generally required that the database design reaches the third paradigm, many-to-many, which eliminates data redundancy, modification exceptions, insertion exceptions, and deletion exceptions to the greatest extent, and basically meets the requirements of relational standardization;

(4) Relational database , the relationship between each data table can only be one-to-one and one-to-many. Many-to-many relationships must be converted into one-to-many relationships for processing;

(5) When designing the data table structure, the dynamic adaptability of the table structure should be considered.

The above is the detailed content of What are the basic principles of database design?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:What does left join mean?Next article:What does left join mean?