Draw an ER-Model (Entity-Relationship Model) based on the following:
A local College asks you to design an ER/D. There are 3 entities; INSTRUCTOR (acts as an advisor & as a teacher), CLASS_SECTION and PUPIL. A PUPIL is given only 1 INSTRCUTOR as their advisor, but advisors have many PUPILS.
Draw a ER/D (in high-level) based on the three entities. For any many-to-many relationships, it must be broken down into 2 one-to-many relationships, while also clarifying the relationship.
Get Answers For Free
Most questions answered within 1 hours.