Changes between Version 23 and Version 24 of P2


Ignore:
Timestamp:
06/25/26 11:00:20 (17 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P2

    v23 v24  
    4848
    4949== Tables
     50'''University''' ( Id, Name, Location, isprivate )
    5051
    51 **University** ( __Id__, Name, Location, isprivate )
     52'''Faculty''' ( Id, University_Id* (University), Name, Location, Study_field )
    5253
    53 **Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field )
     54'''Professor''' ( Id, Faculty_Id* (Faculty), Name, Surname, Age )
    5455
    55 **Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age )
     56'''Student''' ( Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index )
    5657
    57 **Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index )
     58'''Subject''' ( Id, Faculty_Id* (Faculty), Name, Semester, Credits )
    5859
    59 **Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits )
     60'''Student_Subject''' ( [Ss_Id, Student_Id* (Student), Subject_Id* (Subject)], Professor_Id* (Professor), Final_Grade, Status, Enrollment_Date, Absences_Count )
    6061
    61 **Student_Subject** ( __Ss_Id__, __Student_Id*__ (Student), __Subject_Id*__ (Subject), __Professor_Id*__ (Professor), Final_Grade, Status, Enrollment_Date, Absences_Count )
    6262
    63 **Advice** (__Student_Id*__ (Student), __Professor_Id*__ (Professor), Start_Date, End_Date)
    6463
    65 **Affiliated** (__University_Id*__(University), __Professor_Id*__ (Professor))
     64'''Advice''' ( [Student_Id* (Student), Professor_Id* (Professor)], Start_Date, End_Date )
     65
     66'''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)] )
     67
     68
    6669
    6770