SQL OPDRACHT PERIODE 1.4

DROP TABLE DEPARTMENTS;
DROP TABLE EMPLOYEES;

CREATE TABLE DEPARTMENTS(
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100) NOT NULL
);

INSERT INTO DEPARTMENTS(ID,NAME) VALUES(1,'INKOOP');
INSERT INTO DEPARTMENTS(ID,NAME) VALUES(2,'ICT');
INSERT INTO DEPARTMENTS(ID,NAME) VALUES(3,'MANAGEMENT');


CREATE TABLE EMPLOYEES(
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100) NOT NULL,
    EMAIL VARCHAR2(100) DEFAULT 'INFO@MYCOMPANY.COM',
    DEP_ID NUMBER REFERENCES DEPARTMENTS(ID)
);

INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(1,'HENK','HENK@MYCOMPANY.COM',1);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(2,'HARRY','HARRY@MYCOMPANY.COM',2);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(3,'MIKE','MIKE@MYCOMPANY.COM',3);

INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(4,'ROB','ROB@MYCOMPANY.COM',3);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(5,'HERMAN','HERMAN@MYCOMPANY.COM',2);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(6,'MIKEY','MIKEY@MYCOMPANY.COM',2);​