Consider a university database that is designed for the scheduling of classrooms for final
exams. The database is initially modeled as the single entity set exam, with attributes course- name, section-number, room-number, and time. To make the database more complete,
additional entity sets could be defined, along with relationship sets to replace some of the
attributes of the exam entity set, as follows:
• course with attributes name, department, course-no and prerequisites. • section with attributes section-no and enrollment, and a section is related to some existing
course (E.g. L1 and L2 are the sections of the course COMP231).
• room with attributes room-no, capacity, and building. Draw an E-R diagram for the database based on the description above. Reasonable
relationships conforming to the usual practice in our university are required. You also need to
show all the important information that has been taught during the lectures such as primary
keys and weak entities. Please write down any additional assumptions leading to your design.