CREATE TABLE grades_non_normalized
(
MatNr integer,
Name varchar(50),
LVNr integer,
LVTitel varchar(100),
Semester char(6),
LVLeiter varchar(50),
Note integer
);

-- CSV importieren:
-- zuerst mit curl oder wget downloaden, z.B.
--   wget https://ai.wu.ac.at/~polleres/teaching/DOSA_2014/20140505/GradesDemo.csv

\COPY grades_non_normalized FROM 'GradesDemo.csv' WITH DELIMITER ',' CSV HEADER

SELECT * FROM grades_non_normalized;

SELECT MatNr, Name FROM grades_non_normalized;

SELECT DISTINCT MatNr, Name FROM grades_non_normalized;

INSERT INTO Student SELECT DISTINCT MatNr, Name FROM grades_non_normalized;

INSERT INTO Course SELECT DISTINCT LVNr, LVTitel FROM grades_non_normalized;

INSERT INTO Teacher SELECT DISTINCT LVLeiter FROM grades_non_normalized;

INSERT INTO CourseInstance SELECT DISTINCT LVNr, Semester, LVLeiter FROM grades_non_normalized;

INSERT INTO Grades SELECT DISTINCT LVNr, Semester, MatNr, Note FROM grades_non_normalized;

SELECT * FROM Student;
SELECT * FROM Course;
SELECT * FROM Teacher;
SELECT * FROM CourseInstance;
SELECT * FROM Grades;