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:
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 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 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!