Reducing E-R Diagrams to Tables

Posted By on September 30, 2014


Download PDF
Representation of Relationship Sets
Generalization

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 1: 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.

 

Representation of Relationship Sets
Generalization

Download PDF

Posted by Akash Kurup

Founder and C.E.O, World4Engineers Educationist and Entrepreneur by passion. Orator and blogger by hobby

Website: http://world4engineers.com