Introduction to Database Design

Database design steps

Introduction to the importance of needs analysis

Needs analysis example

ER图

Summary of design paradigms

first normal form

second normal form

third normal form

BC paradigm

What to do in database physical design

Which database to choose

MYSQL commonly used storage engines

Naming rules for database tables and fields

Database field type selection principles

How to specifically select the field type in the database

Other considerations for database design

Denormalized table design

What to do in database maintenance and optimization

How the database maintains the data dictionary

How databases maintain indexes

Suitable operations in the database

Vertical and horizontal splitting of database tables