Miscellany

/*Create database t1821

Create table dept
(deptno numeric(2)not null,
 dname char(14),
 loc char(13)
);

Create table emp 
(empno numeric(4) not null,
 ename char(10),
 job char(9),
 mgr numeric(4),
 hiderate datetime,
 sal numeric(7,2),
 com numeric(7,2),
 deptno numeric(2) not null
);

Create table bonus
(ename char(10),
 job char(9),
 sal numeric,
 comm numeric
);

create table salgrade
(grade numeric,
 losal numeric,
 hisal numeric
);

create table customer
(zip char(9),
 state char(2),
 repid numeric(4) not null,
 phone char(9),
 name char(45),
 custid numeric(6) not null,
 creditlimit numeric(9,2),
 city char(90),
 area numeric(3),
 address char(40),
 comments text
);

create table ord
(total numeric(8,2),
 shipdate datetime,
 ordid numeric(4) not null,
 orderdate datetime,
 custid numeric(6) not null,
 commplan char(1)
);

create table item
(qty numeric(8),
 prodid numeric(6),
 ordid numeric(4) not null,
 itemtot numeric(8,2),
 itemid numeric(4) not null,
 actualprice numeric(8,2)
);

create table product
(prodid numeric(6),
 descrp char(30),
);

create table price
(stdprice numeric(8,2),
 startdate datetime,
 prodid numeric(6) not null,
 minprice numeric(8,2),
 enddate datetime
);
*/