CREATE UNLOGGED TABLE Students(StudentId
int UNIQUE, StudentName varchar(50), Address
varchar(200),BirthyearStudent int CHECK (BirthyearStudent < 3000), Gender
char);

COPY Students(StudentId, StudentName,
    Address,BirthyearStudent, Gender) FROM
    '/home/student/Desktop/Data Bases/tables-500/Students.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE Degrees(DegreeId int UNIQUE,
Dept varchar(50), DegreeDiscription varchar(200),
TotalECTS int CHECK (TotalECTS >= 0 AND TotalECTS <= 200)
);

COPY Degrees(DegreeId, Dept, DegreeDiscription, TotalECTS) FROM
    '/home/student/Desktop/Data Bases/tables-500/Degrees.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE StudentRegristrationsToDegrees(
    StudentRegistrationId int UNIQUE CHECK (StudentRegistrationId >= 0),
    StudentId int REFERENCES Students(StudentId), DegreeId int REFERENCES Degrees(DegreeId),
    RegistrationYear int CHECK (RegistrationYear >= 0 AND RegistrationYear < 3000)
);

COPY StudentRegistrationsToDegrees( StudentRegistrationId, StudentId, DegreeId, RegistrationYear)
    FROM '/home/student/Desktop/Data Bases/tables-500/StudentRegistrationsToDegrees.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE Teachers(TeacherId int UNIQUE CHECK (TeacherId >= 0),
    TeacherName varchar(200), Address varchar(200), BirthyearTeacher int
    CHECK(BirthyearTeacher >= 0 AND BirtyearTeacher < 3000), Gender char)
    CONSTRAINT TeacherName CHECK (TeacherName NOT LIKE '%[^A-Z]%')
);

COPY Teachers(TeacherId, TeacherName, Address, BirthyearTeacher, Gender) FROM
     '/home/student/Desktop/Data Bases/tables-500/Teachers.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE Courses(CourseId int UNIQUE, CourseName
    varchar(50), CourseDescription varchar(200), DegreeId int REFERENCES Degrees(DegreeId),
    ECTS int CHECK (ECTS >= 1 AND ECTS <= 7)
);

COPY Courses(CourseId, CourseName, CourseDescription, DegreeId, ECTS) FROM
     '/home/student/Desktop/Data Bases/tables-500/Courses.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE CourseOffers(CourseOfferId int UNIQUE CHECK (CourseOfferId >= 0)
    CourseId int REFERENCES Courses(CourseId), Year int CHECK (Year >= 0 AND Year < 3000),
    Quartile int CHECK (Quartile >= 1 AND Quartile <= 4)
);

COPY CourseOffers(CourseOfferId, CourseId, Year, Quartile) FROM
     '/home/student/Desktop/Data Bases/tables-500/CourseOffers.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE TeacherAssignmentsToCourses(CourseOfferId int REFERENCES
    CourseOffers(CourseOfferId), TeacherId int REFERENCES Teachers(TeacherId)
);

COPY TeacherAssignmentsToCourses(CourseOfferId, TeacherId) FROM
    '/home/student/Desktop/Data Bases/tables-500/TeacherAssignmentsToCourses.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE StudentAssistants(CourseOfferId int REFERENCES
    CourseOffers(CourseOfferId), StudentRegistrationId int REFERENCES
    StudentRegistrationsToDegrees(StudentRegistrationId)
);

COPY StudentAssistants(CourseOfferId, StudentRegistrationId) FROM
     '/home/student/Desktop/Data Bases/tables-500/StudentAssistants.table' DELIMITER
    ',' CSV HEADER
;

CREATE UNLOGGED TABLE CourseRegistrations(CourseOfferId int REFERENCES
    CourseOffers(CourseOfferId), StudentRegistrationId int REFERENCES
    StudentRegistrationsToDegrees(StudentRegistrationId), Grade
    int CHECK (Grade >= 1 AND Grade <= 10)
);

COPY CourseRegistrations(CourseOffersId, StudentRegistrationId,
    Grade) FROM  '/home/student/Desktop/Data Bases/tables-500/CourseRegistration.table' DELIMITER
    ',' CSV HEADER
;