•The process of organizing data in a
database (in MySQL “database” = “schema”)
•Includes creating tables and establishing relationships
between those tables displayed in an Entity Relationship Diagram (ERD)** according
to rules designed both to protect the data and
to make the database more flexible by eliminating redundancy and
inconsistent
dependency**
•Redundant data wastes disk space and creates maintenance problems.
3NF
1NF: 1)primary key 2) no repeating groups
2NF: eilimiate redundant data
3NF: eliminate fields not dependent on key. **🌟🌟🌟**
若有收获，就点个赞吧
0 人点赞
