Discuss the rule for assigning foreign keys in an M: M association.

Question

Want to see the full answer?

Answer 1

Question

Chapter 10, Problem 19RQ

To determine

Discuss the rule for assigning foreign keys in an M: M association.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

When assigning foreign keys in a 1:M associationa. the primary key of each table should be embedded as a foreign key in the related table. b. the primary key on the 0,M side of the relation should be embedded as the foreign key on the 1,1 side.c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,M side.d. a link table must be created to accept the foreign keys of both tables.e. none of the above is true.

When assigning foreign keys in a 1:1 associationa. the primary key of each table should be embedded as a foreign key in the related table.b. the primary key on the 0,1 side of the relation should be embedded as the foreign key on the 1,1 side.c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,1 side.d. a link table must be created to accept the foreign keys of both tables.e. none of the above is true.

What is an internal exchange transaction, and how is it reported?