Consider a university database that is designed for the scheduling of classrooms for final

Yüklə 435,02 Kb.
Pdf görüntüsü
ölçüsü435,02 Kb.
ER Exp

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 namedepartmentcourse-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-nocapacity, 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. 

Yüklə 435,02 Kb.

Dostları ilə paylaş:

Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur © 2022
rəhbərliyinə müraciət

    Ana səhifə