Changes between Version 18 and Version 19 of ERModel


Ignore:
Timestamp:
09/09/26 12:18:38 (28 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v18 v19  
    33== Diagram
    44
    5 [[Image(ERModel_v1.3.2.png)]]
     5[[Image(ERModel_v1.3.3.drawio.png)]]
    66
    77== Data Requirements
    … …  
    8989'''Discriminator (Partial Key):''' ss_id.
    9090
    91 '''Composite Primary Key:''' Composed of Student key + Subject key + ss_id.
     91'''Composite Primary Key:''' (student_id, subject_id, ss_id)
    9292
    9393'''Attributes:'''
    … …  
    146146
    147147v1.1: Corrected conceptual ER representations: removed all foreign keys from entity attributes, correctly specified weak entity discriminator and identifying relationships, converted bridge tables (Affiliated, Advises) into relationship types with attributes.
     148v1.2: Removed underline from start_date in Advises relationship (since relationships cannot have primary key attributes), renamed duplicate enrolled_in relationship to enrolls, and ensured identifying relationships for Student_Subject are formally represented.