create table NEWSSTANDS
(
  STAND_NBR  INTEGER not null,
  STAND_NAME CHAR(20) not null
)
;
alter table NEWSSTANDS
  add primary key (STAND_NBR);


create table SALES
(
  PRODUCT_ID   INTEGER not null,
  STAND_NBR    INTEGER not null,
  NET_SOLD_QTY INTEGER not null
)
;
alter table SALES
  add primary key (PRODUCT_ID, STAND_NBR);


create table TITLES
(
  PRODUCT_ID   INTEGER not null,
  MAGAZINE_SKU INTEGER not null,
  ISSN         INTEGER not null,
  ISSN_YEAR    INTEGER not null
)
;
alter table TITLES
  add primary key (PRODUCT_ID);

insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (1, 1, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (2, 1, 4);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (3, 1, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (4, 1, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (5, 1, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (6, 1, 2);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (7, 1, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (4, 2, 5);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (8, 2, 6);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (3, 2, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (1, 3, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (2, 3, 3);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (4, 3, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (5, 3, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (6, 3, 3);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (7, 3, 3);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (1, 4, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (2, 4, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (3, 4, 4);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (4, 4, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (5, 4, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (6, 4, 1);
insert into SALES (PRODUCT_ID, STAND_NBR, NET_SOLD_QTY)
values (7, 4, 2);
commit;

insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (1, 12345, 1, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (2, 2667, 1, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (3, 48632, 1, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (4, 1107, 1, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (5, 12345, 2, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (6, 2667, 2, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (7, 48632, 2, 2006);
insert into TITLES (PRODUCT_ID, MAGAZINE_SKU, ISSN, ISSN_YEAR)
values (8, 1107, 2, 2006);
commit;