sales Table

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

sales is defined as:

create table sales
(stor_id char(4) not null
    references stores(stor_id),
ord_num numeric(6,0) identity,
date datetime not null,
unique nonclustered (ord_num))