Changes between Version 12 and Version 13 of ERModel


Ignore:
Timestamp:
06/25/26 10:16:02 (2 weeks ago)
Author:
223091
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ERModel

    v12 v13  
    220220* '''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.
    221221
    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.
     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.
    223223
    224224== AI Usage ==