Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement