CREATE TABLE STORE_CHAIN
(STORE_ID CHAR (3) PRIMARY KEY,
STORE_NUM CHAR (3) NOT NULL,
EMPLOYEE_ID CHAR (3),
ADDRESS CHAR (20),
CITY CHAR (20) NOT NULL,
St Char (2) Not Null,
ZIP_CODE CHAR (10) NOT NULL,
DATE_OPENED DATE,
MONTHLY_REV DECIMAL (12,2));
Insert into STORE_CHAIN
values
('T1','S01','E05','345 Wick Blvd','Youngstown','OH','44567','12Jan2008',30000.00);
Insert into STORE_CHAIN
values
('T2','S02','E07','100 Highland Ave','New Castle','PA','16101','12Apr2011',20000.00);
Insert into STORE_CHAIN
values
('T3','S04','E16','11 East St','New Castle','PA','16101','03Jan2013',2000.00);
Insert into STORE_CHAIN
values
('T4','S03','E01','','Libery','OH','44333','02Jan2015',0.00);
Insert into STORE_CHAIN
values
('T5','S03','E01','','Libery','OH','44333','02Jan2016',0.00);
Insert into STORE_CHAIN
values
('T6','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T7','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T8','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T9','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T10','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T11','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T12','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T13','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T14','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T15','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T16','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T17','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T18','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T19','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T20','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T21','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T22','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T23','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T24','S03','','','Libery','OH','44333','',0.00);
Insert into STORE_CHAIN
values
('T25','S03','','','Libery','OH','44333','',0.00);