postgreeSQL

-- CREATE TABLE Employee(
-- SSN CHAR(9) NOT NULL,
-- FName VARCHAR(15) NOT NULL,
-- MName CHAR,
-- LName VARCHAR(15) NOT NULL,
-- BDate DATE,
-- Address VARCHAR(30),
-- Sex CHAR,
-- Salary DECIMAL(10,2),
-- SuperSSN CHAR(9),
-- DNum INT NOT NULL,
-- CONSTRAINT Employee_SSN_PK PRIMARY KEY (SSN),
-- CONSTRAINT Employee_SuperSSN_FK FOREIGN KEY(SuperSSN) REFERENCES Employee(SSN));

-- CREATE TABLE Department (
-- DNumber INT NOT NULL,
-- DName VARCHAR (15) NOT NULL,
-- MgrSSN CHAR(9) NOT NULL,
-- MgrStartDate DATE,
-- CONSTRAINT Dept_DNumber_PK PRIMARY KEY(DNumber),
-- CONSTRAINT Dept_DName_Unique UNIQUE(DName),
-- CONSTRAINT Dept_MgrSSN_FK FOREIGN KEY(MgrSSN) REFERENCES Employee(SSN));

-- ALTER TABLE Employee ADD CONSTRAINT Employee_DNum_FK FOREIGN
-- KEY(DNum) REFERENCES Department(DNumber);

-- CREATE TABLE Dept_Locations(
-- DNum INT NOT NULL,
-- DLocation VARCHAR(15) NOT NULL,
-- CONSTRAINT DNumber_DLocation_PF PRIMARY KEY(DNum,DLocation),
-- CONSTRAINT DLoc_DNum_FK FOREIGN KEY(DNum) REFERENCES Department(DNumber));

-- CREATE TABLE Project( PNumber INT NOT NULL,
-- PName VARCHAR(15) NOT NULL,
-- PLocation VARCHAR(15),
-- DNum INT NOT NULL,
-- CONSTRAINT Project_PNumber_PK PRIMARY KEY(PNumber),
-- CONSTRAINT Project_PName_Unique UNIQUE(PName),
-- CONSTRAINT Project_DNum_FK FOREIGN KEY(DNum)REFERENCES Department(DNumber));

-- CREATE TABLE Works_On( ESSN CHAR(9) NOT NULL,
-- PNum INT NOT NULL,
-- Hours DECIMAL(3,1) NOT NULL,
-- CONSTRAINT Works_ESSN_PNum_PK PRIMARY KEY(ESSN,PNum),
-- CONSTRAINT Works_ESSN_FK FOREIGN KEY(ESSN) REFERENCES
-- Employee(SSN),
-- CONSTRAINT Works_PNum_FK FOREIGN KEY(PNum) REFERENCES Project(PNumber));

-- CREATE TABLE Dependent(
-- ESSN CHAR(9) NOT NULL,
-- Dependent_Name VARCHAR(15) NOT NULL,
-- Sex CHAR,
-- BDate DATE,
-- Relationship VARCHAR(8),
-- CONSTRAINT Dependent_ESSN_DepName_PK PRIMARY
-- KEY(ESSN,Dependent_Name),
-- CONSTRAINT Dependent_ESSN_FK FOREIGN KEY(ESSN) REFERENCES Employee(SSN));

-- ALTER TABLE Employee DROP CONSTRAINT Employee_DNum_FK;

-- INSERT INTO Employee VALUES('E001', 'Hakim', null, 'Arifin', '12-Jan-1987','BATENG', 'M', 4000000, null, 1);
-- INSERT INTO Employee VALUES('E002','Yuni',null,'Arti','15-Feb-1987', 'BARA','F',4000000,null,2);
-- INSERT INTO Employee VALUES('E003','Mutia',null,'Aziza','23-Mar-1987', 'BATENG','F',4000000,null,3);
-- INSERT INTO Employee VALUES('E004','Hanif',null,'Affandi','21-Jan-1987', 'BARA','M',4000000,null,4);
-- INSERT INTO Employee VALUES('E005','Vera',null,'Yunita','16-May-1987', 'BALEBAK','F',3500000,'E001',1);
-- INSERT INTO Employee VALUES('E006','Pritasri',null,'Palupiningsih','09-Dec-1987','BADONENG','F',3500000,'E001',1);
-- INSERT INTO Employee VALUES('E007','Rifki','Y','Haidar','02-Aug-1987', 'BATENG','M',3000000,'E001',1);
-- INSERT INTO Employee VALUES('E008','Muhammad','A','Rosyidi','22-Jun-1987', 'PERUMDOS','M',2750000,'E001',1);
-- INSERT INTO Employee VALUES('E009','Ferry',null,'Pratama','11-Jul-1987', 'BARA','M',3000000,'E002',2);
-- INSERT INTO Employee VALUES('E010','Andi',null,'Sasmita','15-Feb-1987', 'BATENG','M',3000000,'E002',2);
-- INSERT INTO Employee VALUES('E011','Yuhan','A','Kusuma','16-Mar-1987', 'BARA','M',2500000,'E002',2);
-- INSERT INTO Employee VALUES('E012','Ferdian',null,'Feisal','23-Mar-1987', 'BATENG','M',2000000,'E002',2);
-- INSERT INTO Employee VALUES('E013','Albertus','A','M','22-May-1986', 'BARA','M',3000000,'E003',3);
-- INSERT INTO Employee VALUES('E014','Benedika','F','Hutabarat','21-Jun-1987', 'BADONENG','M',3250000,'E003',3);
-- INSERT INTO Employee VALUES('E015','Herbet',null,'Sianipar','16-Jul-1987', 'BARA','M',3750000,'E003',3);

-- INSERT INTO Department VALUES(1,'HRD','E001','09-Jan-2002');
-- INSERT INTO Department VALUES(2,'FINANCE','E002','27-Feb-2003');
-- INSERT INTO Department VALUES(3,'HUMAS','E003','30-May-2006');
-- INSERT INTO Department VALUES(4,'PRODUKSI','E004','08-Mar-2005');

-- ALTER TABLE Employee ADD CONSTRAINT Employee_DNum_FK FOREIGN KEY(DNum) REFERENCES Department(DNumber);

-- INSERT INTO Dept_Locations VALUES(1,'Darmaga');
-- INSERT INTO Dept_Locations VALUES(3,'Darmaga');
-- INSERT INTO Dept_Locations VALUES(2,'Darmaga');
-- INSERT INTO Dept_Locations VALUES(4,'Baranang Siang');

-- INSERT INTO Project VALUES(1,'AAA','Bogor',1);
-- INSERT INTO Project VALUES(2,'BBB','Jakarta',2);
-- INSERT INTO Project VALUES(3,'CCC','Tangerang',2);
-- INSERT INTO Project VALUES(4,'DDD','Bekasi',2);
-- INSERT INTO Project VALUES(5,'EEE','Depok',3);
-- INSERT INTO Project VALUES(6,'FFF','Bogor',3);
-- INSERT INTO Project VALUES(7,'GGG','Tangerang',4);
-- INSERT INTO Project VALUES(8,'HHH','Jakarta',4);

-- INSERT INTO Works_On VALUES('E001',1,90);
-- INSERT INTO Works_On VALUES('E001',2,98);
-- INSERT INTO Works_On VALUES('E002',2,55);
-- INSERT INTO Works_On VALUES('E002',3,78);
-- INSERT INTO Works_On VALUES('E003',3,53);
-- INSERT INTO Works_On VALUES('E003',4,77);
-- INSERT INTO Works_On VALUES('E004',4,77);
-- INSERT INTO Works_On VALUES('E004',5,98);
-- INSERT INTO Works_On VALUES('E004',7,85);
-- INSERT INTO Works_On VALUES('E004',8,68);
-- INSERT INTO Works_On VALUES('E005',5,57);

-- INSERT INTO Dependent VALUES('E001','Rita','F','18-Sep-2005','DAUGHTER');
-- INSERT INTO Dependent VALUES('E001','Doni','M','09-Jan-2007','SON');
-- INSERT INTO Dependent VALUES('E002','Wawan','M','23-Oct-1984','HUSBAND');
-- INSERT INTO Dependent VALUES('E002','Roy','M','15-Dec-2006','SON');
-- INSERT INTO Dependent VALUES('E003','Roni','M','23-Aug-1985','HUSBAND');
-- INSERT INTO Dependent VALUES('E003','Dewi','F','01-Jan-2006','DAUGHTER');
-- INSERT INTO Dependent VALUES('E004','Susi','F','05-Sep-1987','WIFE');
-- INSERT INTO Dependent VALUES('E004','Rani','M','10-Feb-2007','DAUGHTER');
-- INSERT INTO Dependent VALUES('E011','Dina','F','13-Jan-1987','WIFE');
-- INSERT INTO Dependent VALUES('E011','Riko','M','21-Mar-2006','SON');
-- INSERT INTO Dependent VALUES('E013','Rini','F','15-Aug-1987','WIFE');
-- INSERT INTO Dependent VALUES('E013','Tina','F','17-Dec-2005','DAUGHTER');
-- INSERT INTO Dependent VALUES('E014','Ayu','F','08-Dec-1988','WIFE');
-- INSERT INTO Dependent VALUES('E014','Didiet','M','05-Dec-2006','SON');
-- INSERT INTO Dependent VALUES('E015','Nita','F','25-Jan-1987','WIFE');