数据库设计那些事

• Chapter1 demand analysis
• 1-1 Introduction to Database Design
• 1-2 Database design steps
• 1-3 Introduction to the importance of needs analysis
• 1-4 Needs analysis example
• Chapter2 logical design
• 2-1 ER图
• 2-2 Summary of design paradigms
• 2-3 first normal form
• 2-4 second normal form
• 2-5 third normal form
• 2-6 BC paradigm
• Chapter3 physical design
• 3-1 What to do in database physical design
• 3-2 Which database to choose
• 3-3 MYSQL commonly used storage engines
• 3-4 Naming rules for database tables and fields
• 3-5 Database field type selection principles
• 3-6 How to specifically select the field type in the database
• 3-7 Other considerations for database design
• 3-8 Denormalized table design
• Chapter4 Maintenance optimization
• 4-1 What to do in database maintenance and optimization
• 4-2 How the database maintains the data dictionary
• 4-3 How databases maintain indexes
• 4-4 Suitable operations in the database
• 4-5 Vertical and horizontal splitting of database tables