Question: Consider the relation schemas where we have made bold the primary keys: Not yet answered Marked out of Y Flag question Question 5 Not yet
Consider the relation schemas where we have made bold the primary keys:
Not yet answered
Marked out of
Y Flag question
Question
Not yet
answered
Marked out of
T Flag question
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 StudentD 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
