DATA TABEL TUGAS TAMBAHAN SBD K

CREATE TABLE Employees (

employee_id int NOT NULL PRIMARY KEY,

first_name varchar(100),

last_name varchar(100),

salary float,

manager_id int,

department_id int

);

CREATE TABLE Departments (

department_id int NOT NULL PRIMARY KEY,

department_name VARCHAR(100),

manager_id int,

location_id int

);

INSERT INTO Employees VALUES(2,'Donald','OConnel',2600,124,50);

INSERT INTO Employees VALUES(3,'Douglas','Grant',1400,124,50);

INSERT INTO Employees VALUES(5,'Steven','King',3200,NULL,90);

INSERT INTO Employees VALUES(1,'Herman','Bear',10000,101,70);

INSERT INTO Employees VALUES(6,'Lorentz','Diana',4200,103,60);

INSERT INTO Employees VALUES(4,'Jeniffer','Whalen',4400,NULL,10);

INSERT INTO Employees VALUES(8,'David','Austin',4800,NULL,10);

INSERT INTO Employees VALUES(7,'Susan','Marris',6500,101,40);

INSERT INTO Employees VALUES(10,'Pat','Fay',6000,201,20);

INSERT INTO Employees VALUES(9,'Lex','DeHan',17000,100,90);

INSERT INTO Departments VALUES(10,'Administration',200,1700);

INSERT INTO Departments VALUES(20,'Marketing',201,1800);

INSERT INTO Departments VALUES(30,'Purchasing',114,1700);

INSERT INTO Departments VALUES(40,'Human Resource',203,2400);

INSERT INTO Departments VALUES(50,'Shipping',121,1500);

INSERT INTO Departments VALUES(60,'IT',103,1400);

INSERT INTO Departments VALUES(70,'Public Relations',204,2700);

INSERT INTO Departments VALUES(80,'Sales',145,2500);

INSERT INTO Departments VALUES(90,'Executive',100,1700);

INSERT INTO Departments VALUES(100,'Finance',108,1800);