|< < 16 > >|

Entity/Relationship Model → Relational Schema

Problem: How to generate a relational schema from an Entity/Relationship Model?

Overview

• Entity → Table.

• Attribute → Column.

• Entity set key → Primary key.

• Relationship → One or more Foreign Keys, possibly a new Table.

|< < 16 > >|