Changes between Version 13 and Version 14 of ERModel

Timestamp:

06/25/26 10:17:35 (2 weeks ago)

Author:

223091

Comment:

--

ERModel

@@ -216 +216 @@
 == Entity-Relationship Model History ==
 
-* '''v01''' – Initial version of the ER model. This version included Buildings, Rooms, Equipment, RoomEquipment as an associative entity, Users, Reservations, and Approvals. It also defined the required relationships, cardinalities, participation constraints, candidate keys, primary keys, and main entity attributes.
-
-* '''v02''' – Updated version of the ER model based on supervisor feedback. This version generalized reservations so that a reservation may include a room, equipment, or both. A new associative entity, ReservationEquipment, was added to represent equipment requested as part of a reservation. The Equipment entity was extended with ''stock_quantity'' to represent equipment available in general stock and not necessarily assigned to a specific room. The Rooms–Reservations relationship was changed into ''includes_room'' so that equipment-only reservations are allowed.
+* '''v01''' – Initial version of the ER model. This version included Buildings, Rooms, Equipment, !RoomEquipment as an associative entity, Users, Reservations, and Approvals. It also defined the required relationships, cardinalities, participation constraints, candidate keys, primary keys, and main entity attributes.
+
+* '''v02''' – Updated version of the ER model based on supervisor feedback. This version generalized reservations so that a reservation may include a room, equipment, or both. A new associative entity, !ReservationEquipment, was added to represent equipment requested as part of a reservation. The Equipment entity was extended with ''stock_quantity'' to represent equipment available in general stock and not necessarily assigned to a specific room. The Rooms–Reservations relationship was changed into ''includes_room'' so that equipment-only reservations are allowed.
 
 * '''v03''' – Corrected version of the ER model based on additional supervisor feedback. The associative entities !RoomEquipment and !ReservationEquipment were removed from the conceptual ER model. Instead, the many-to-many relationship between Rooms and Equipment is represented as ''has_equipment'' with the relationship attribute ''quantity'', and the many-to-many relationship between Reservations and Equipment is represented as ''requests_equipment'' with the relationship attribute ''requested_quantity''. This version avoids foreign keys in the ER model and keeps only strong entity sets and conceptual relationships.