The Customers relation scheme attributes are:

The primary key attribute of the Customers relation is the Customer I.D.; the attributes first name, last name, and phone are a candidate key.

The Orders relation scheme attributes are:

The primary key attributes of the Orders relation are the foreign key Customer I.D. plus the order date.

Return to main page