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 |
0 Comments
Please add nice comments or answer ....