Changes between Version 24 and Version 25 of P2


Ignore:
Timestamp:
06/25/26 15:15:25 (13 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P2

    v24 v25  
    88
    99== Tables
     10'''University''' ( Id, Name, Location, isprivate )
    1011
    11 **University** ( __Id__, Name, Location, isprivate )
     12'''Faculty''' ( Id, University_Id* (University), Name, Location, Study_field )
    1213
    13 **Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field )
     14'''Professor''' ( Id, Faculty_Id* (Faculty), Name, Surname, Age )
    1415
    15 **Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age )
     16'''Student''' ( Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index )
    1617
    17 **Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index )
     18'''Subject''' ( Id, Faculty_Id* (Faculty), Name, Semester, Credits )
    1819
    19 **Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits )
     20'''Student_Subject''' ( [Ss_Id, Student_Id* (Student), Subject_Id* (Subject)], Professor_Id* (Professor), Final_Grade, Status, Enrollment_Date, Absences_Count )
    2021
    21 **Student_Subject** ( __Ss_Id__, __Student_Id*__ (Student), __Subject_Id*__ (Subject), __Professor_Id*__ (Professor), Final_Grade, Status, Enrollment_Date, Absences_Count )
     22'''Advice''' ( [Student_Id* (Student), Professor_Id* (Professor)], Start_Date, End_Date )
     23
     24'''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)])
    2225----
    2326
    … …  
    3134
    3235== Relational diagram made in DBeaver
    33 [[Image(Relational-schema1.png)]]
     36[[Image(relational_schema.png)]]
    3437
    3538= AI Usage for Relational Design =
    … …  
    4245
    4346Final result: I reviewed my initial core database schema with the AI assistant to identify potential gaps in tracking student-professor interactions and professor-university ties. Based on these discussions, I successfully refined my tables by designing and incorporating the Advice and Affiliated relation schemas.
    44 
    45 == Final Result
    4647
    4748== Final Result
    … …  
    6061'''Student_Subject''' ( [Ss_Id, Student_Id* (Student), Subject_Id* (Subject)], Professor_Id* (Professor), Final_Grade, Status, Enrollment_Date, Absences_Count )
    6162
    62 
    63 
    6463'''Advice''' ( [Student_Id* (Student), Professor_Id* (Professor)], Start_Date, End_Date )
    6564
    6665'''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)] )
    67 
    68 
    69 
    7066
    7167----