Reducing E-R Diagrams to Tables

next up previous
Next: Representation of Strong Up: The Entity-Relationship Model Previous: Other Styles of

Reducing E-R Diagrams to Tables

A database conforming to an E-R diagram can be represented by a collection of tables. We'll use the E-R diagram of Figure 2.14) as our example.

Figure 2.14: E-R diagram with strong and weak entity sets

For each entity set and relationship set, there is a unique table which is assigned the name of the corresponding set. Each table has a number of columns with unique names. (E.g. Figs. 2.14 - 2.18 in the text).

Page created and maintained by Osmar R. Zaï ane
Last Update: Sun Sep 10 17:02:35 PDT 1995