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 5
Not yet
answered
Marked out of
T Flag question
STUDENT(StudentID, Name, DoB, Email)
ENROL(StudentID, 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 Student/D 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!