Changes between Version 17 and Version 18 of P2
- Timestamp:
- 03/03/26 12:02:40 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P2
v17 v18 9 9 == Tables 10 10 11 **University** ( Id, Name, Location, isprivate)11 **University** ( __Id__, Name, Location, isprivate ) 12 12 13 **Faculty** ( Id, __University_Id*__ (University), Name, Location, Study_field)13 **Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field ) 14 14 15 **Professor** ( Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)15 **Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age ) 16 16 17 **Student** ( Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)17 **Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index ) 18 18 19 **Subject** ( Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)19 **Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits ) 20 20 21 **Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor))21 **Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor) ) 22 22 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 ) 25 24 26 25 ---- … … 49 48 == Tables 50 49 51 **University** ( Id, Name, Location, isprivate)50 **University** ( __Id__, Name, Location, isprivate ) 52 51 53 **Faculty** ( Id, __University_Id*__ (University), Name, Location, Study_field)52 **Faculty** ( __Id__, __University_Id*__ (University), Name, Location, Study_field ) 54 53 55 **Professor** ( Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)54 **Professor** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Age ) 56 55 57 **Student** ( Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)56 **Student** ( __Id__, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index ) 58 57 59 **Subject** ( Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)58 **Subject** ( __Id__, __Faculty_Id*__ (Faculty), Name, Semester, Credits ) 60 59 61 **Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor))60 **Subject_Professor** ( __Subject_Id*__ (Subject), __Professor_Id*__ (Professor) ) 62 61 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 ) 64 63 65 64 **Advice** (__Student_Id*__ (Student), __Professor_Id*__ (Professor), Start_Date, End_Date)
