Changes between Version 9 and Version 10 of UseCase0002PrototypeImplementation


Ignore:
Timestamp:
06/26/26 22:27:45 (2 weeks ago)
Author:
223091
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0002PrototypeImplementation

    v9 v10  
    122122This use-case reads data from the following tables:
    123123
    124 ''project.users'' – to allow the requester to be selected from a list.
    125 ''project.rooms'' – to display available rooms.
    126 ''project.buildings'' – to display the building name and address.
    127 ''project.reservations'' – to check room availability and to insert the new reservation.
    128 ''project.equipment'' – if additional equipment is requested.
    129 ''project.reservation_equipment'' – used if requested equipment is included in the reservation; this table was created in Phase P2 from the ''requests_equipment'' M:N relationship in the corrected ER model.
     124 * ''project.users'' – used to allow the requester to be selected from a list.
     125 * ''project.rooms'' – used to display available rooms.
     126 * ''project.buildings'' – used to display the building name and address.
     127 * ''project.reservations'' – used to check room availability and insert the new reservation.
     128 * ''project.equipment'' – used if additional equipment is requested.
     129 * ''project.reservation_equipment'' – used if requested equipment is included in the reservation; this table was created in Phase P2 from the ''requests_equipment'' M:N relationship in the corrected ER model.
    130130
    131 This use-case modifies the database by inserting a new record into ''project.reservations''. The created reservation initially has the status ''pending''.
     131This use-case modifies the database by:
     132
     133 * inserting a new record into ''project.reservations'' with initial status ''pending'';
     134 * inserting records into ''project.reservation_equipment'' if additional requested equipment is selected.
    132135
    133136== Result of the implementation ==