Question
In a relational database it is common to have a linking table when there is a many-to-many relationship. A good example is between students and
In a relational database it is common to have a linking table when there is a many-to-many relationship. A good example is between students and courses taken by a student, where any student can have multiple courses taken, and any courses can have multiple students in that course. In this case, what would be true of the linking table?
a)It would contain the foreign keys StudentID and CourseID and possibly other fields.
b)If the Students table has a primary StudentID value of 101, the linking table would have at least one record with a foreign key StudentID value of 101.
c)It would be composed entirely of the foreign keys StudentID and CourseID, with no other fields allowed.
d)It would be composed entirely of the primary keys StudentID and CourseID, with no other fields allowed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started