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 '[email protected]',
    DEP_ID NUMBER REFERENCES DEPARTMENTS(ID)
);

INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(1,'HENK','[email protected]',1);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(2,'HARRY','[email protected]',2);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(3,'MIKE','[email protected]',3);

INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(4,'ROB','[email protected]',3);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(5,'HERMAN','[email protected]',2);
INSERT INTO EMPLOYEES(ID,NAME,EMAIL,DEP_ID) VALUES(6,'MIKEY','[email protected]',2);​