Relational Design

UNIVERSITY (Id, Name, Location, IsPrivate)

FACULTY (Id, University_Id*, Name, Location, Study_field)

PROFESSOR (Id, Faculty_Id*, Name, Surname, Age, Address)

STUDENT (Id, Faculty_Id*, Adviser_Id, Name, Surname, Location, Index)

SUBJECT (Id, Faculty_Id*, Professor_Id*, Name, Semester, Credits)

STUDENT_SUBJECT (Student_Id*, Subject_Id*, Final_Grade, Status, Enrollment_Date, Absence_Count)