Changes between Version 19 and Version 20 of ERModel


Ignore:
Timestamp:
09/09/26 12:29:00 (29 hours ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ERModel

    v19 v20  
    33== Diagram
    44
    5 [[Image(ERModel_v1.3.3.drawio.png)]]
     5[[Image(ERModel_v1.3.4.png)]]
    66
    77== Data Requirements
     
    101101'''final_grade''' – integer, optional (mapped to Final_Grade).
    102102
    103 '''absences_count''' – integer, optional, defaults to 0 (mapped to Abesense_Count on the diagram).
     103'''absences_count''' – integer, optional, defaults to 0.
    104104
    105105== Relationships
     
    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.
     148
    148149v1.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.