1. Chapter 9, part 1 How to Translate ER diagram into Relational Schema We will follow the following multi-step process
Strong Entity Types
Weak Entity Types
2. Chapter 9, part 1 Strong Entity Types 1. For each regular (strong) entity type in the ER schema, create a relation that includes all the simple attributes.
2. Include only the simple component attributes of a composite attribute.
3.Choose one of the key attributes of entity type as primary key for table.
3. Chapter 9, part 1