Question: Consider the relation schemas where we have made bold the primary keys: STUDENT ( StudentID , Name, DoB, Email ) ENROL ( StudentID , CourseNo,
Consider the relation schemas where we have made bold the primary keys:
STUDENTStudentID Name, DoB, Email
ENROLStudentID CourseNo, Semester, Status, EnrolDate
The foreign key StudentID in ENROL references StudentID in STUDENT.
Which of the following statements is incorrect?
a The StudentID values in ENROL must be distinct.
b StudentID must be a superkey in STUDENT.
c There may exist StudentID values in STUDENT that do not appear in ENROL.
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
