-
Collect requirement from stakeholders
-
Identify entities
-
Identify primary keys
-
Identify relationship
-
N:M -- create intermediate relations (to convert N:M into two 1:N relationships)
-
1:N -- "1" side entity PK as foreign key in N side table
-
1:1 -- add PK as foreign key to the total participation side of the relation. If both total participation, merge tables
-
MySql Learning Notes 003 -- DB Design
最新推荐文章于 2024-08-20 13:24:05 发布