Changes between Version 16 and Version 17 of LogicalModel


Ignore:
Timestamp:
02/03/26 19:04:50 (3 weeks ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LogicalModel

    v16 v17  
    22= Relational Design
    33
     4== Notation
     5- Primary keys are underlined.
     6
     7- Foreign keys are marked with * at the end of their name and the referenced entity is written in parentheses.
     8
    49== Tables
    510
    6 **University** (Id, Name, Location, IsPrivate)
     11**University** (Id, Name, Location, isprivate)
    712
    8 **Faculty** (Id, University_Id* (University), Name, Location, Study_field)
     13**Faculty** (Id, __University_Id*__ (University), Name, Location, Study_field)
    914
    10 **Professor** (Id, Faculty_Id* (Faculty), Name, Surname, Age)
     15**Professor** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)
    1116
    12 **Student** (Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index)
     17**Student** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)
    1318
    14 **Subject** (Id, Faculty_Id* (Faculty), Name, Semester, Credits)
     19**Subject** (Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)
    1520
    16 **Subject_Professor** (Subject_Id* (Subject), Professor_Id* (Professor))
     21**Subject_Professor** (__Subject_Id*__ (Subject), __Professor_Id*__ (Professor))
    1722
    18 **Student_Subject** (Student_Id* (Student), Subject_Id* (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
     23**Student_Subject** (__Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
    1924
    2025
    … …  
    4449== Tables
    4550
    46 **University** (Id, Name, Location, IsPrivate)
     51**University** (Id, Name, Location, isprivate)
    4752
    48 **Faculty** (Id, University_Id* (University), Name, Location, Study_field)
     53**Faculty** (Id, __University_Id*__ (University), Name, Location, Study_field)
    4954
    50 **Professor** (Id, Faculty_Id* (Faculty), Name, Surname, Age)
     55**Professor** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Age)
    5156
    52 **Student** (Id, Faculty_Id* (Faculty), Name, Surname, Location, Student_Index)
     57**Student** (Id, __Faculty_Id*__ (Faculty), Name, Surname, Location, Student_Index)
    5358
    54 **Subject** (Id, Faculty_Id* (Faculty), Name, Semester, Credits)
     59**Subject** (Id, __Faculty_Id*__ (Faculty), Name, Semester, Credits)
    5560
    56 **Subject_Professor** (Subject_Id* (Subject), Professor_Id* (Professor))
     61**Subject_Professor** (__Subject_Id*__ (Subject), __Professor_Id*__ (Professor))
    5762
    58 **Student_Subject** (Student_Id* (Student), Subject_Id* (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
     63**Student_Subject** (__Student_Id*__ (Student), __Subject_Id*__ (Subject), Final_Grade, Status, Enrollment_Date, Absences_Count)
    5964
     65**Advice** (__Student_Id*__ (Student), __Professor_Id*__ (Professor), Start_Date, End_Date)
     66
     67**Affiliated** (__University_Id*__(University), __Professor_Id*__ (Professor))
    6068
    6169