Question: This question is for someone familiar with relational databases. Can you please exlplain your answer. Thanks Consider the relation schemas Student(StudentlD, Name, DoB, Email) where
This question is for someone familiar with relational databases.
Can you please exlplain your answer.
Thanks

Consider the relation schemas Student(StudentlD, Name, DoB, Email) where StudenlD is its primary key, and Enrol(StudentlD, CourseNo, Semester, Status, EnrolDate) where (StudentID, CourseNo, Semester) is its primary key. The foreign key StudentID in Enrol references StudentID in Student. The true/false question: the StudentID values in Enrol must be distinct. Select one: O True O False In SQL, INDEX is used to enforce referential integrity between two tables. Select one: O True O False
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
