· 9 years ago · Dec 15, 2016, 03:34 PM
1drop table if exists cascade;
2create table lab11_Products(
3PID varchar(6) not null,
4Name varchar(25) not null,
5Category varchar(25) not null,
6constraint product_pkey primary key(PID)
7);
8
9drop table if exists cascade;
10create table lab11_Stores(
11SID varchar(6) not null,
12SNAME varchar(25) not null,
13ADDRESS varchar(50) not null,
14MANAGER varchar(25) not null,
15OpenSince date not null,
16constraint store_pkey primary key(SID)
17);