Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 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

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

Students also viewed these Databases questions

Question

=+21.16. For the density Cexp( -1x| "), - o Answered: 1 week ago

Answered: 1 week ago

Question

denigration of emotional outbursts; being reserved;

Answered: 1 week ago