Close
Register
Close Window

Database

Chapter 2 The ER-Data Model and Mapping to Relational Schema

Show Source |    | About   «  2.2. ERD Basic Components   ::   Contents   ::   2.4. ERD Different Notations  »

2.3. ERD Mapping To Relational Data Model

The below figure shows a simple database example modeled with three different diagrams (ERD, RDD & Data Table)

_images/ErdvsRDDvsTable.png

How do you convert an entity-relationship diagram to a relational schema?

Simply by breaking down entities, attributes, and relationships into tables (relations), columns, fields, and keys.

The below table shows the basic ERD elements and their corresponding relational schema elements.

_images/ERDRDDMapping.png

   «  2.2. ERD Basic Components   ::   Contents   ::   2.4. ERD Different Notations  »

nsf
Close Window