Ad Code

E-R diagram containing just two entities

How to draw an E-R diagram containing just two entities, A and C, in Many-to-Many relationship,and then introduce an associative entity (B)?



ERD, consists of entities and their relationships.  You learnt through lectures that  we do not want to draw many:many relationships in our ERD.  We want to split up by putting an associative in between. we then obtain two 1:many relationships with the associative entity in the hub. 


Examples:

1. Learner - lecturer.  A learner will have one or more lecturer.  The same lecturer will have masses of students.
This many:many is not allowed, we will change this to add a associative-entity in the central point.

The three entities could translate into the following three tables:

Learner Table
Learner lecturer Table
lecturer Table
Learner Number
first name
Address
residenceTelNumber

Learner Number
lecturer Number



lecturer Number
first name
OfficeNumber
jobTelNumber



Reactions

Post a Comment

0 Comments