Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an ER diagram accordingly to the following user requirements. Hand-drawn diagram will NOT be accepted. (Note: For all assignments in this course, no hand-written
Draw an ER diagram accordingly to the following user requirements. Hand-drawn diagram will NOT be accepted. (Note: For all assignments in this course, no hand-written submission will be accepted.) Please submit a PDF file to Canvas. List assumptions for your diagram, if there is any. 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. he owner of a weak entity can be another weak entity
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started