drop table CUST; create table CUST ( cid int primary key, name char(30), area int, emp int, indus char(20) ); drop table PROD; create table PROD ( pid int, name char(40), color char(10), weight numeric(6, 1), price numeric(6, 2)); drop table SALES; create table SALES ( pid int, cid int, emp int, sdate date, qty int); drop table EMP; create table EMP ( eid int, name char(30), salary numeric(8, 2));