Changes between Version 2 and Version 3 of LogicalModel


Ignore:
Timestamp:
01/15/26 18:31:26 (12 days ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LogicalModel

    v2 v3  
    11
    2 == Relational Design
     2= Relational Design
    33
    4 UNIVERSITY (Id, Name, Location, IsPrivate)
     4== Tables
    55
    6 FACULTY (Id, University_Id*, Name, Location, Study_field)
     6**University** (Id, Name, Location, IsPrivate)
    77
    8 PROFESSOR (Id, Faculty_Id*, Name, Surname, Age, Address)
     8**Faculty** (Id, University_Id*, Name, Location, Study_field)
    99
    10 STUDENT (Id, Faculty_Id*, Adviser_Id, Name, Surname, Location, Index)
     10**Professor** (Id, Faculty_Id*, Name, Surname, Age, Address)
    1111
    12 SUBJECT (Id, Faculty_Id*, Professor_Id*, Name, Semester, Credits)
     12**Student** (Id, Faculty_Id*, Adviser_Id, Name, Surname, Location, Index)
    1313
    14 STUDENT_SUBJECT (Student_Id*, Subject_Id*, Final_Grade, Status, Enrollment_Date, Absence_Count)
     14**Subject** (Id, Faculty_Id*, Professor_Id*, Name, Semester, Credits)
     15
     16**Student-Subject** (Student_Id*, Subject_Id*, Final_Grade, Status, Enrollment_Date, Absence_Count)
     17
     18
     19----
     20
     21
     22== DDL script for creating the database schema and objects:
     23[wiki.schema_creation.sql]
     24