Changes between Version 12 and Version 13 of ERModel
- Timestamp:
- 06/25/26 10:16:02 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v12 v13 220 220 * '''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. 221 221 222 * '''v03''' – Corrected version of the ER model based on additional supervisor feedback. The associative entities RoomEquipment andReservationEquipment 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.222 * '''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. 223 223 224 224 == AI Usage ==
