Database management systems notes
From ER Diagram to Tables
A fixed seven-step procedure that turns any diagram into a working schema. Every section is a drawn page beside a clear written explanation, about 20 minutes in all.
- Chapter 5 of 34
- About 20 minutes
- 9 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- The seven rules, in order
- Rule 1: strong entities become tables
- Rule 4: one-to-many becomes a foreign key
- Rule 5: many-to-many becomes a table
- Rule 3: one-to-one, and where to put the key
- Rules 6 and 2: multi-valued attributes and weak entities
- Rule 7: three ways to convert a specialization
- The finished schema
- Checking your conversion
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.