A foreign key points to the primary key of the table it references.

Question $9$ options:

Entity integrity

Referential integrity

Domain integrity

General integrity

Consider the following text representation. Consider the choices and pick the correct one.

Student $($ StuID, FirstName, LastName, DateOfBirth $)$

Enrollment $($ CRN$,$ Semester, StuID, EnrollmentDate, EnrollmentStatus$)$

Course $($ CRN$,$ Semester, Subject, CourseNumber, Section, Title, Credits $)$

Question $10$ options:

Enrollment.CRN and Enrollment.Semester form a foreign key to Course.

Course.CRN and Course.Semester form a foreign key to Enrollment.

Course.Semester is a DATE field.

DateOfBirth is a NUMBER field.

Consider the following text representation. Consider the choices and pick the correct one.

Student $($ StuID, FirstName, LastName, DateOfBirth $)$

Enrollment $($ CRN$,$ Semester, StuID, EnrollmentDate, EnrollmentStatus$)$

Course $($ CRN$,$ Semester, Subject, CourseNumber, Section, Title, Credits $)$

Question $11$ options:

Enrollment.EnrollmentStatus is a foreign key to Course.Subject.

Course.CRN is a foreign key to Enrollment.CRN$.$

Enrollment.EnrollmentDate is a foreign key to Course.Semester.

The primary key of Course has two fields: CRN and Semester.