Relational Design

Tables

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)

---

DDL script for creating the database schema and objects:

DDL script​

DML script for inserting data in the tables

DML script​

Relational diagram made in DBeaver