slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
How to Translate ER diagram into Relational Schema PowerPoint Presentation
Download Presentation
How to Translate ER diagram into Relational Schema

play fullscreen
1 / 42

How to Translate ER diagram into Relational Schema

1136 Views Download Presentation
Download Presentation

How to Translate ER diagram into Relational Schema

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

    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 Multivalued attributes Binary Relationships M:N 1:N 1:1 n-ary relationships

    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