gistfile1.sql

/* Add courses */
INSERT INTO COURSES(name, credits)
VALUES ('Datastrukturer', 8);

INSERT INTO COURSES(name, credits)
VALUES ('Databases', 8);

INSERT INTO COURSES(name, credits)
VALUES ('Ingenjörskompetens', 3);

INSERT INTO COURSES(name, credits)
VALUES ('Objektorienterad programmering', 8);

/* Add limited course */
INSERT INTO LIMITEDCOURSES(name, limit)
VALUES ('Databases', 145);

/* Add programs, branches and departments */
INSERT INTO DEPARTMENTS(name, abbreviation)
VALUES ('Institutionen för E, D, IT', 'EDIT');

INSERT INTO DEPARTMENTS(name, abbreviation)
VALUES ('Institutionen för F', 'F');

INSERT INTO PROGRAMS
VALUES ('IT');

INSERT INTO PROGRAMS
VALUES ('D');

INSERT INTO BRANCHES(name, pname)
VALUES ('Software Engineering', 'IT');

INSERT INTO BRANCHES(name, pname)
VALUES ('Interaction Design', 'IT');

INSERT INTO BRANCHES(name, pname)
VALUES ('CSALL', 'D');

INSERT INTO BRANCHES(name, pname)
VALUES ('Software Engineering', 'D');

/* Add students */
INSERT INTO STUDENTS(id, name, bname, pname)
VALUES (9307062654, 'Edvard Hübinette', 'Software Engineering', 'IT');

INSERT INTO STUDENTS(id, name, bname, pname)
VALUES (9110016020, 'Lovisa Jäberg', 'Interaction Design', 'IT');

INSERT INTO STUDENTS(id, name, bname, pname)
VALUES (9112074415, 'Jack Vev', 'CSALL', 'D');

INSERT INTO STUDENTS(id, name, bname, pname)
VALUES (9206061234, 'Oscar Muhr', 'Software Engineering', 'IT');

/* Insert HasDepartments and GivenBy */
INSERT INTO HASDEPARTMENTS(pname, dname)
VALUES ('IT', 'Institutionen för E, D, IT');

INSERT INTO HASDEPARTMENTS(pname, dname)
VALUES ('D', 'Institutionen för E, D, IT');

INSERT INTO GIVENBY(cname, dname)
VALUES ('Databases', 'Institutionen för E, D, IT');

INSERT INTO GIVENBY (cname, dname)
VALUES ('Datastrukturer', 'Institutionen för E, D, IT');

/* Add classifications, and courses for them */
INSERT INTO CLASSIFICATIONS
VALUES ('Math');

INSERT INTO CLASSIFICATIONS
VALUES ('Research');

INSERT INTO CLASSIFICATIONS
VALUES ('Seminar');

INSERT INTO HASCLASSIFICATIONS(name, type)
VALUES ('Datastrukturer', 'Research');

INSERT INTO HASCLASSIFICATIONS(name, type)
VALUES ('Datastrukturer', 'Seminar');

INSERT INTO HASCLASSIFICATIONS(name, type)
VALUES ('Objektorienterad programmering', 'Research');

/* Add students to InQueue */
INSERT INTO INQUEUE(id, name)
VALUES (9307062654, 'Databases');

INSERT INTO INQUEUE(id, name)
VALUES (9110016020, 'Databases');

INSERT INTO INQUEUE(id, name)
VALUES (9110016020, 'Datastrukturer');

/* Add RegisteredTo and HasTaken */
INSERT INTO REGISTEREDTO(id, name)
VALUES (9307062654, 'Ingenjörskompetens');

INSERT INTO REGISTEREDTO(id, name)
VALUES (9112074415, 'Datastrukturer');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9112074415, 'Ingenjörskompetens', 'U');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9307062654, 'Datastrukturer', '4');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9110016020, 'Objektorienterad programmering', '5');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9206061234, 'Objektorienterad programmering', '4');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9206061234, 'Datastrukturer', '4');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9206061234, 'Databases', '4');

INSERT INTO HASTAKEN(id, name, grade)
VALUES (9206061234, 'Ingenjörskompetens', '5');

/* Add IsPreReq */
INSERT INTO ISPREREQ(name1, name2)
VALUES ('Datastrukturer', 'Objektorienterad programmering');

INSERT INTO ISPREREQ(name1, name2)
VALUES ('Objektorienterad programmering', 'Ingenjörskompetens');

/* Add mandatory courses */
INSERT INTO MANDATORYINBRANCH(bname, pname, cname)
VALUES ('Software Engineering', 'IT', 'Objektorienterad programmering');

INSERT INTO MANDATORYINBRANCH(bname, pname, cname)
VALUES ('Software Engineering', 'IT', 'Databases');

INSERT INTO MANDATORYINPROGRAM(pname, cname)
VALUES ('IT', 'Ingenjörskompetens');

INSERT INTO MANDATORYINPROGRAM(pname, cname)
VALUES ('D', 'Datastrukturer');