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

== DML script for inserting data in the tables 
[attachment:data_load1.sql DML script]


== Relational diagram made in DBeaver 
[[Image(relational_schema1.jpg)]]

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

== DML script for inserting data in the tables 
[attachment:data_load.sql DML script]


== Relational diagram made in DBeaver 
[[Image(relational_schema.jpg)]]



ChatGPT - https://chatgpt.com/c/69693542-7640-8327-920b-0065ba155df0