sales Table

The sales table contains store IDs, order numbers, and dates of sales.

sales is defined as:

create table sales
(stor_id char(4) not null,
ord_num varchar(20) not null,
date datetime not null)

Its primary keys are stor_id and ord_num:

sp_primarykey sales, stor_id, ord_num

Its stor_id column is a foreign key to stores:

sp_foreignkey sales, stores, stor_id