CREATE TABLE Course (
semesterID int NOT NULL,
semester varchar(255) NOT NULL,

PRIMARY KEY (semesterID)
);

CREATE TABLE User (
userID int NOT NULL,
firstName varchar(255) NOT NULL,
lastName varchar(255) NOT NULL,
username varchar(255) NOT NULL,
password varchar(255) NOT NULL,
email varchar(255) NOT NULL,
semesterID int NOT NULL,

PRIMARY KEY (userID),
FOREIGN KEY (semesterID) REFERENCES Course (semesterID)
);

CREATE TABLE Admin (
adminID int NOT NULL,
userID int NOT NULL,

PRIMARY KEY (adminID),
FOREIGN KEY (userID) REFERENCES User(userID)
);

CREATE TABLE Teacher (
employeeID int NOT NULL,
userID int NOT NULL,

PRIMARY KEY (employeeID),
FOREIGN KEY (userID) REFERENCES User(userID)
);


CREATE TABLE Student (
studentID int NOT NULL,
userID int NOT NULL,

PRIMARY KEY (studentID),
FOREIGN KEY (userID) REFERENCES User(userID)
);

CREATE TABLE Module (
moduleNr int NOT NULL,
taskText varchar(255) NOT NULL,
deadline date NOT NULL,
moduleRequirements varchar (255) NOT NULL,

PRIMARY KEY (moduleNr)
);

CREATE TABLE Deliver (
taskID int NOT NULL,
moduleNr int NOT NULL,
studentID int NOT NULL,

PRIMARY KEY (taskID),
FOREIGN KEY (moduleNr) REFERENCES Module (moduleNr),
FOREIGN KEY (studentID) REFERENCES Student (studentID)
);

CREATE TABLE review (
reviewID int NOT NULL,
feedback varchar(255) NOT NULL,
grade text NOT NULL,
score int NOT NULL,
employeeID int NOT NULL,
studentID int NOT NULL,
taskID int NOT NULL,

PRIMARY KEY (reviewID),
FOREIGN KEY (employeeID) REFERENCES Teacher (employeeID),
FOREIGN KEY (studentID) REFERENCES Student (studentID),
FOREIGN KEY (taskID) REFERENCES Deliver (taskID)
);

CREATE TABLE notification (
notificationID int NOT NULL,
info varchar(255) NOT NULL,
moduleNr int NOT NULL,
taskID int NULL,
userID int NOT NULL,

PRIMARY KEY (notificationID),
FOREIGN KEY (moduleNr) REFERENCES Module (moduleNr),
FOREIGN KEY (taskID) REFERENCES Deliver (taskID),
FOREIGN KEY (userID) REFERENCES User (userID)
);
4. Add some test data to the database, so that you can later write SQL queries.

 INSERT INTO course VALUES (110,2)

INSERT INTO User VALUES
(1,"Ola", "Hansen", "Ola15", "123", "Ola15@gmail.com", 110),
(2,"Martin", "Hansen", "Mar15", "123", "Martin15@gmail.com", 110),
(3,"Kjell", "Hansen", "Kje15", "123", "Kjell15@gmail.com", 110),
(4,"Mathias", "Hansen", "Mat15", "123", "Mathias15@gmail.com", 110),
(5,"Silje", "Hansen", "Sil15", "123", "Silje15@gmail.com", 110),
(6,"Sofie", "Hansen", "Sof15", "123", "Sofie15@gmail.com", 110),
(7,"Maria", "Hansen", "Mar15", "123", "Maria5@gmail.com", 110),
(8,"Babe", "Hansen", "Bae15", "123", "Babe15@gmail.com", 110);

INSERT INTO admin VALUES
(1,1)

INSERT INTO student VALUES
(1,2),
(2,3),
(3,4),
(4,5),
(5,6),
(6,7)

INSERT INTO Teacher VALUES
(1,7),
(2,8)

INSERT INTO Module VALUES
(1,"I denne modulen skal du opprette en sykkelbutikk", '2017-10-24', "Du skal kunne om arv"),
(2, "I denne modulen skal du bygge videre på butikken", '2017-11-15', " Du skal kunne om kobling i kode")

INSERT INTO Deliver VALUES
(1,1,2),
(2,1,3),
(3,2,3),
(4,2,4)


INSERT INTO review VALUES
(1,"Godt jobbet med modulen", "A",100,1,1,1),
(2,"Rom for forbedring", "C", 60, 1,2,2),
(3,"Ikke godkjent", "F", 10, 2,3,3)

INSERT INTO Notification VALUES
(1,"varsel",1,1,2),
(2,"modul varsel",2,null,3)