= 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:
[attachment:schema_creation.sql DML script]

== DML script for inserting data in the tables 

[attachment:]


== Relational diagram made in DBeaver 

[[Image(relational_schema.jpg)]]