Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw out ER Digram and have the connection labled and use correct shapes will connecction each part of the ER digram and relationships for each
Draw out ER Digram and have the connection labled and use correct shapes will connecction each part of the ER digram and relationships for each part. They also need cardinlity raions for Binary relaction with possible cardinality ratios
Possible cardinality ratios 1:1 (one to one) 1:N (one to many) N:1 (many to one) M:N (many to many)
Use these
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 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