Needs analysis example-数据库设计那些事-php.cn

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Next Section： ER图 (3040 plays)

Watch Again

Chapter

Note

Ask

Feedback

数据库设计那些事

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

Previous section Next Section

Course Recommendations
Courseware download

Students who have watched this course are also learning

About us Disclaimer Sitemap: php.cn：Public welfare online PHP training，Help PHP learners grow quickly！