1. Engineering
  2. Computer Science
  3. the design a has 3 identifying relationships for the enrollment...

Question: the design a has 3 identifying relationships for the enrollment...

Question details

Term TermID Year Term Student Course Enrollment Studenti CourselD PK FE Studentid LastName Name PK FK CourselD FirstName TermID Description PK FK DateOfBirth Design B: Enrollment Student Course PK EnrollmentlD PK Studentid CourselD LastName 41 。 Studentib0H Name FirstName CourselD Description TermID DateOfBirth Term PK TermID Year Term

The design A has 3 identifying relationships for the Enrollment entity. It means an enrollment record cannot exist unless there is a matching record in Term, Student and Course. Enrollment has a composite primary key, consisting of StudentID, CourseID and TermID. In the design B, we use a surrogate key for the Enrollment entity and turn the identifying relationships into non-identifying relationships. What constraints do we need to implement in design B to ensure the data integrity maintained in design A is still enforced in design B? Please explain in details.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution