Answered step by step
Verified Expert Solution
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
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 entityStep 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