Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ER Diagram A university has a set of classrooms scheduled for final exams. A class room has a room number, building, and capacity.

Draw an ER Diagram

image text in transcribed

A university has a set of classrooms scheduled for final exams. A class room has a room number, building, and capacity. Each course has a course serial number (unique), course name and it belongs to a department. Each course can have one or more sections. Each section has a section number that is unique regarding the same course. Students are enrolled in a section. Exams are conducted in sections of a particular course. Each exam has an exam number that is unique regarding the same section in a course. The exam's result is also recorded i.e., grades of students. Student's information includes SSN (unique), name and address. A course must have at least one section. A student should enroll in at least one course. Constraints: - A section should be associated with a course. One particular section is associated with only one course. - A section can have many exams and an exam belongs to just one section only. - An exam can be conducted in many class rooms (e.g. at different time). A class room can have many exams conducted in it (e.g. at different time). We do not keep track of the time to conduct the exam. - A section should have at least one student. owner of a weak entity can be another weak entity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions

Question

=+ (b) Do the same for p = 2.

Answered: 1 week ago