Examination Scheduling

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.

Import into your Project

Posted by: Ricardo Poole

Turn every software project into a successful one.

Try Visual Paradigm for Free! Or learn more about our features.

Leave a Reply

Be the First to Comment!