Chapter 1, Problem 7RQ

Explanation of Solution

Difference between a foreign key and a primary key:

Foreign key	Primary key
A primary key attribute in one table is the foreign key for another table. In a logical way, a foreign key is used to establish a link between two tables.	In relational databases, a primary key is a key that is used for identifying and defining the characteristics uniquely of each row.
A foreign key is used for identifying a row of another table uniquely.	A primary key may have a single attribute or multiple attributes.
A foreign key may be a field or group of fields in a table. As a foreign key may be a column or group of columns.	The primary key will contain a unique value for each row of data.
Foreign key must not be null when the minimum cardinality of a data in a column of a table is implied as one...