Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Economics questions

Question

5. How can I help others in the network achieve their goals?

Answered: 1 week ago