Changes between Version 17 and Version 18 of P2


Ignore:
Timestamp:
03/03/26 12:02:40 (3 weeks ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P2

    v17 v18  
    99== Tables
    1010
    11 **University** (Id, Name, Location, isprivate)
     11**University** ( __Id__, Name, Location, isprivate )
    1212
    13 **Faculty** (Id, __University_Id*__ (University), Name, Location, Study_field)
     13**Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field )
    1414
    15 **Professor** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)
     15**Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age )
    1616
    17 **Student** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)
     17**Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index )
    1818
    19 **Subject** (Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)
     19**Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits )
    2020
    21 **Subject_Professor** (__Subject_Id*__ (Subject), __Professor_Id*__ (Professor))
     21**Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor) )
    2222
    23 **Student_Subject** (__Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
    24 
     23**Student_Subject** ( __Ss_Id__, __Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count )
    2524
    2625----
    … …  
    4948== Tables
    5049
    51 **University** (Id, Name, Location, isprivate)
     50**University** ( __Id__, Name, Location, isprivate )
    5251
    53 **Faculty** (Id, __University_Id*__ (University), Name, Location, Study_field)
     52**Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field )
    5453
    55 **Professor** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)
     54**Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age )
    5655
    57 **Student** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)
     56**Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index )
    5857
    59 **Subject** (Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)
     58**Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits )
    6059
    61 **Subject_Professor** (__Subject_Id*__ (Subject), __Professor_Id*__ (Professor))
     60**Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor) )
    6261
    63 **Student_Subject** (__Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
     62**Student_Subject** ( __Ss_Id__, __Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count )
    6463
    6564**Advice** (__Student_Id*__ (Student), __Professor_Id*__ (Professor), Start_Date, End_Date)