Changes between Version 27 and Version 28 of P2
- Timestamp:
- 06/29/26 13:36:05 (8 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P2
v27 v28 7 7 - Foreign keys are marked with * at the end of their name and the referenced entity is written in parentheses. 8 8 9 == Tables 9 == Tables == 10 10 '''University''' ( Id, Name, Location, isprivate ) 11 11 … … 22 22 '''Advice''' ( [Student_Id* (Student), Professor_Id* (Professor)], Start_Date, End_Date ) 23 23 24 '''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)]) 25 ---- 24 '''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)] ) 26 25 26 '''Teach''' ( [Professor_Id* (Professor), Subject_Id* (Subject)] ) 27 27 28 28 == DDL script for creating the database schema and objects: … … 65 65 '''Affiliated''' ( [University_Id* (University), Professor_Id* (Professor)] ) 66 66 67 '''Teach''' ( [Professor_Id* (Professor), Subject_Id* (Subject)] ) 68 67 69 ---- 68 70
