Question: 6 . 2 Consider a database that includes the entity sets student, course, and section from the university schema and that additionally records the marks
Consider a database that includes the entity sets student, course, and section
from the university schema and that additionally records the marks that students
receive in different exams of different sections.
a Construct an ER diagram that models exams as entities and uses a ternary
relationship as part of the design
b Construct an alternative ER diagram that uses only a binary relationship
between student and section. Make sure that only one relationship exists
between a particular student and section pair, yet you can represent the
marks that a student gets in different exams.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
