Changes between Version 11 and Version 12 of LogicalModel

Timestamp:

01/15/26 20:19:53 (12 days ago)

Author:

216009

Comment:

--

LogicalModel

@@ -6 +6 @@
 **University** (Id, Name, Location, IsPrivate)
 
-**Faculty** (Id, University_Id*, Name, Location, Study_field)
+**Faculty** (Id, University_Id* (University), Name, Location, Study_field)
 
-**Professor** (Id, Faculty_Id*, Name, Surname, Age, Address)
+**Professor** (Id, Faculty_Id* (Faculty), Name, Surname, Age)
 
-**Student** (Id, Faculty_Id*, Adviser_Id, Name, Surname, Location, Index)
+**Student** (Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index)
 
-**Subject** (Id, Faculty_Id*, Professor_Id*, Name, Semester, Credits)
+**Subject** (Id, Faculty_Id* (Faculty), Name, Semester, Credits)
 
-**Student-Subject** (Student_Id*, Subject_Id*, Final_Grade, Status, Enrollment_Date, Absence_Count)
+**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)]]
+
+= 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)
+
 
 
@@ -31 +74 @@
 
 
+
+