DROP TABLE emp CASCADE constraints;
DROP TABLE works CASCADE constraints;
DROP TABLE dept CASCADE constraints;


CREATE TABLE Emp(
	eid			NUMBER(9,0),
	ename		VARCHAR2(30),
	age			NUMBER(3,0),
	salary		NUMBER(10,2),
	PRIMARY KEY (eid)
);

CREATE TABLE Dept(
	did			NUMBER(2,0),
	dname		VARCHAR2(20),
	budget		NUMBER(10,2),
	managerid	NUMBER(9,0),
	PRIMARY KEY (did),
	FOREIGN KEY (managerid) REFERENCES Emp(eid)
);

CREATE TABLE Works(
	eid			NUMBER(9,0),
	did			NUMBER(2,0),
	pct_time	NUMBER(3,0),
	PRIMARY KEY (eid,did),
	FOREIGN KEY (eid) REFERENCES Emp,
	FOREIGN KEY (did) REFERENCES Dept
);

INSERT INTO Emp VALUES (142519864,'Susan Martin',39,56990);
INSERT INTO Emp VALUES (242518965,'James Smith',68,27099);
INSERT INTO Emp VALUES (141582651,'Mary Johnson',44,94011);
INSERT INTO Emp VALUES (011564812,'John Williams',35,74098);
INSERT INTO Emp VALUES (254099823,'Patricia Jones',28,42783);
INSERT INTO Emp VALUES (356187925,'Robert Brown',28,35431);
INSERT INTO Emp VALUES (489456522,'Linda Davis',26,25971);
INSERT INTO Emp VALUES (287321212,'Michael Miller',62,131072);
INSERT INTO Emp VALUES (248965255,'Barbara Wilson',48,95021);
INSERT INTO Emp VALUES (159542516,'Matt Nelson',33,48990);
INSERT INTO Emp VALUES (090873519,'Elizabeth Taylor',27,33055);
INSERT INTO Emp VALUES (486512566,'David Anderson',20,25199);
INSERT INTO Emp VALUES (619023588,'Jennifer Thomas',24,34654);
INSERT INTO Emp VALUES (112348546,'Joseph Thompson',26,24998);
INSERT INTO Emp VALUES (115987938,'Christopher Garcia',60,24998);
INSERT INTO Emp VALUES (132977562,'Angela Martinez',31,24998);
INSERT INTO Emp VALUES (269734834,'Rick Carter',38,24998);
INSERT INTO Emp VALUES (280158572,'Margaret Clark',40,24998);
INSERT INTO Emp VALUES (301221823,'Juan Rodriguez',30,32175);
INSERT INTO Emp VALUES (318548912,'Ann Mitchell',23,32175);
INSERT INTO Emp VALUES (320874981,'Daniel Lee',23,32175);
INSERT INTO Emp VALUES (322654189,'Lisa Walker',38,32175);
INSERT INTO Emp VALUES (348121549,'Trey Phillips',69,32175);
INSERT INTO Emp VALUES (351565322,'Nancy Allen',30,39910);
INSERT INTO Emp VALUES (451519864,'Mark Young',34,39910);
INSERT INTO Emp VALUES (455798411,'Luis Hernandez',44,39910);
INSERT INTO Emp VALUES (550156548,'George Wright',42,41008);
INSERT INTO Emp VALUES (552455318,'Ana Lopez',35,41008);
INSERT INTO Emp VALUES (556784565,'Kenneth Hill',81,41008);
INSERT INTO Emp VALUES (567354612,'Karen Scott',70,39910);
INSERT INTO Emp VALUES (573284895,'Steven Green',29,39910);
INSERT INTO Emp VALUES (574489456,'Betty Adams',39,39910);
INSERT INTO Emp VALUES (015645489,'Daniel Evans',25,40312);
INSERT INTO Emp VALUES (015487874,'Gene Edwards',51,41008);
INSERT INTO Emp VALUES (054879887,'Dorthy Lewis',33,41008);
INSERT INTO Emp VALUES (098784544,'Eric Collins',23,41008);
INSERT INTO Emp VALUES (074454898,'Scott Bell',23,70100);
INSERT INTO Emp VALUES (156489494,'Gil Richardson',32,70100);
INSERT INTO Emp VALUES (179887498,'Dorthy Howard',28,40312);
INSERT INTO Emp VALUES (156465461,'Eric Cooper',26,24998);
INSERT INTO Emp VALUES (128778823,'William Ward',33,24998);
INSERT INTO Emp VALUES (178949844,'Chad Stewart',29,24998);
INSERT INTO Emp VALUES (298489484,'Lisa Gray',31,24998);
INSERT INTO Emp VALUES (274878974,'Harry Watson',30,24998);
INSERT INTO Emp VALUES (267894232,'Paul Hall',25,24998);
INSERT INTO Emp VALUES (254898318,'Gim Rogers',25,32175);
INSERT INTO Emp VALUES (489221823,'Richard Jackson',33,32996);
INSERT INTO Emp VALUES (548977562,'Donald King',43,92048);
INSERT INTO Emp VALUES (289562686,'Thomas Robinson',34,32175);
INSERT INTO Emp VALUES (291795563,'Haywood Kelly',36,32175);
INSERT INTO Emp VALUES (578875478,'Edward Baker',50,101071);
INSERT INTO Emp VALUES (051135593,'Maria White',22,24998);
INSERT INTO Emp VALUES (060839453,'Charles Harris',24,24998);
INSERT INTO Emp VALUES (334568786,'William Moore',32,32175);
INSERT INTO Emp VALUES (355548984,'Tom Murphy',41,32175);
INSERT INTO Emp VALUES (310454876,'Milo Brooks',22,39910);
INSERT INTO Emp VALUES (390487451,'Mark Coleman',42,39910);
INSERT INTO Emp VALUES (454565232,'Louis Jenkins',20,39910);
INSERT INTO Emp VALUES (141582657,'Stanley Browne',23,14093);

INSERT INTO Dept VALUES (1,'Hardware',1048572.12,141582651);
INSERT INTO Dept VALUES (2,'Operations',12099101.00,287321212);
INSERT INTO Dept VALUES (3,'Legal',222988.13,248965255);
INSERT INTO Dept VALUES (4,'Marketing',538099.54,548977562);
INSERT INTO Dept VALUES (5,'Software',400011.12,141582651);
INSERT INTO Dept VALUES (6,'Production',12099101.00,578875478);
INSERT INTO Dept VALUES (7,'Shipping',5.00,489456522);

INSERT INTO Works VALUES (142519864,2,100);
INSERT INTO Works VALUES (242518965,1,100);
INSERT INTO Works VALUES (141582651,1,50);
INSERT INTO Works VALUES (141582651,5,50);
INSERT INTO Works VALUES (141582657,1,25);
INSERT INTO Works VALUES (141582657,5,75);
INSERT INTO Works VALUES (011564812,3,100);
INSERT INTO Works VALUES (254099823,3,100);
INSERT INTO Works VALUES (356187925,2,100);
INSERT INTO Works VALUES (489456522,7,100);
INSERT INTO Works VALUES (287321212,2,100);
INSERT INTO Works VALUES (248965255,3,100);
INSERT INTO Works VALUES (159542516,4,100);
INSERT INTO Works VALUES (090873519,2,100);
INSERT INTO Works VALUES (486512566,4,100);
INSERT INTO Works VALUES (619023588,1,100);
INSERT INTO Works VALUES (489221823,2,100);
INSERT INTO Works VALUES (548977562,4,100);
INSERT INTO Works VALUES (578875478,6,100);
INSERT INTO Works VALUES (051135593,2,100);
INSERT INTO Works VALUES (060839453,2,100);
INSERT INTO Works VALUES (112348546,2,100);
INSERT INTO Works VALUES (115987938,2,100);
INSERT INTO Works VALUES (132977562,2,100);
INSERT INTO Works VALUES (269734834,2,100);
INSERT INTO Works VALUES (280158572,2,100);
INSERT INTO Works VALUES (301221823,2,100);
INSERT INTO Works VALUES (318548912,2,100);
INSERT INTO Works VALUES (320874981,2,100);
INSERT INTO Works VALUES (322654189,2,100);
INSERT INTO Works VALUES (348121549,2,100);
INSERT INTO Works VALUES (351565322,2,100);
INSERT INTO Works VALUES (451519864,2,100);
INSERT INTO Works VALUES (455798411,2,100);
INSERT INTO Works VALUES (550156548,2,50);
INSERT INTO Works VALUES (552455318,2,25);
INSERT INTO Works VALUES (556784565,2,25);
INSERT INTO Works VALUES (567354612,2,75);
INSERT INTO Works VALUES (573284895,2,50);
INSERT INTO Works VALUES (574489456,2,50);
INSERT INTO Works VALUES (015645489,6,100);
INSERT INTO Works VALUES (015487874,6,100);
INSERT INTO Works VALUES (054879887,6,100);
INSERT INTO Works VALUES (098784544,6,100);
INSERT INTO Works VALUES (074454898,6,100);
INSERT INTO Works VALUES (156489494,6,100);
INSERT INTO Works VALUES (179887498,6,100);
INSERT INTO Works VALUES (156465461,6,100);
INSERT INTO Works VALUES (128778823,6,100);
INSERT INTO Works VALUES (178949844,6,100);
INSERT INTO Works VALUES (298489484,6,100);
INSERT INTO Works VALUES (274878974,6,100);
INSERT INTO Works VALUES (267894232,6,100);
INSERT INTO Works VALUES (254898318,6,100);
INSERT INTO Works VALUES (289562686,6,100);
INSERT INTO Works VALUES (291795563,6,100);
INSERT INTO Works VALUES (334568786,6,100);
INSERT INTO Works VALUES (355548984,6,100);
INSERT INTO Works VALUES (310454876,6,100);
INSERT INTO Works VALUES (390487451,6,100);
INSERT INTO Works VALUES (454565232,6,50);