CREATE TABLE

1.create table emp
(eid int,ename varchar(20),emgr int, esalry int)

2.create table dept(eid int primary key)

3.CREATE TABLE INVENTRY( IID INT PRIMARY KEY,PRODID INT,SUPID INT,QTY INT )