Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please make an ER diagram based on the description above. I have been trying for a very long but need some verification on what is

image text in transcribed

Please make an ER diagram based on the description above. I have been trying for a very long but need some verification on what is a weak entity, which entities should have double lines or single lines, etc... Please make sure to include all keys partial keys, and composite keys/attributes if any. Weak entities, and single and double lines representing partial or total participation, and all of that. The wording on this assignment is very vague so it is causing trouble for me.

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. e 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 with AI-Powered 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

Students also viewed these Databases questions