Changes between Version 6 and Version 7 of ERModel

Timestamp:

08/28/26 21:02:37 (9 days ago)

Author:

236024

Comment:

--

ERModel

@@ -1 @@
-= Entity-Relationship Model v.08 =
+= Entity-Relationship Model v.09 =
 == Diagram ==
 
-[[Image(wiki:ERModel:ERModel_v08.png)]]
+[[Image(wiki:ERModel:ERModel_v09.png)]]
 == Data requirements ==
 
@@ -259 +259 @@
 
  * '''Candidate keys:''' the natural key is the activity session key because each activity session is related to at most one event edition in the current model.
- * '''Attributes:''' no relationship attributes.
-
-==== required_attendance ====
-
-required_attendance connects !MembershipStages to !ActivityTypes. It represents which membership stages are expected or required to attend a certain type of activity, such as full members being required to attend full member meetings.
-
- * '''Candidate keys:''' ms_name + at_name is the natural primary key because the same membership stage should be listed at most once for the same activity type.
  * '''Attributes:''' no relationship attributes.
 
@@ -344 +337 @@
 ||v07||Changed names to attributes and relationships so that all relationships are named and no attributes or relationships share the same name.||
 ||v08||Changed the weak entity keys of !EventSessions, !EventEditions and !ActivitySessions to account for edge cases where two sessions or editions could otherwise have the same identifying values and need location/title/start time to distinguish them.||
+||v09||Removed "required_attendance" relationship after realising it is redundant.||
 
 == AI Use ==