The Customer and Order schemes are the same as we described in earlier pages. You may skip to the new material here.

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.

The Order lines relation scheme attributes are:

The primary key attributes of the Order lines relation are the foreign keys from both the Orders and the Products schemes.

The Products relation scheme attributes are:

The primary key attribute of the Products relation is the universal product code; the attributes manufacturer and model are a candidate key.

Return to main page