Relational Design

Tables

University (Id, Name, Location, IsPrivate)

Faculty (Id, University_Id* (University), Name, Location, Study_field)

Professor (Id, Faculty_Id* (Faculty), Name, Surname, Age)

Student (Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index)

Subject (Id, Faculty_Id* (Faculty), Name, Semester, Credits)

Subject_Professor (Subject_Id* (Subject), Professor_Id* (Professor))

Student_Subject (Student_Id* (Student), Subject_Id* (Subject), Final_Grade, Status, Enrollment_Date, Absences_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

AI Usage for Relational Design

ChatGPT – OpenAI URL: ​https://chat.openai.com/

Type of subscription: Free online access (no paid subscription required)

Note: This AI tool was selected to assist with database design and relational modeling based on a short survey of available AI tools. Its responses helped in structuring tables, foreign key constraints, and M:N relationships for this project.

Final Result

Tables

University (Id, Name, Location, IsPrivate)

Faculty (Id, University_Id* (University), Name, Location, Study_field)

Professor (Id, Faculty_Id* (Faculty), Name, Surname, Age)

Student (Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index)

Subject (Id, Faculty_Id* (Faculty), Name, Semester, Credits)

Subject_Professor (Subject_Id* (Subject), Professor_Id* (Professor))

Student_Subject (Student_Id* (Student), Subject_Id* (Subject), Final_Grade, Status, Enrollment_Date, Absences_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