Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as
1. course with attributes name, department, and c-number
2. section with attributes s-number and enrolment, and dependent as a weak entity set on course
3. room with attributes r-number, capacity, and building
This is an ER Diagram that illustrates the use of all three additional entity sets listed.
Posted by: Ricardo Poole