Changes between Version 4 and Version 5 of UseCase0003PrototypeImplementation


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

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0003PrototypeImplementation

    v4 v5  
    139139This use-case reads data from the following tables:
    140140
    141 ''project.reservations'' – to list pending reservations and display the final reservation status.
    142 ''project.users'' – to display the requester and the approver.
    143 ''project.rooms'' – to display room information.
    144 ''project.reservation_equipment'' – used to display requested equipment if it exists; this table was created in Phase P2 from the ''requests_equipment'' M:N relationship in the corrected ER model.
    145 ''project.equipment'' – to display equipment names.
    146 ''project.approvals'' – to display and store the approval decision.
     141 * ''project.reservations'' – used to list pending reservations and display the final reservation status.
     142 * ''project.users'' – used to display the requester and the approver.
     143 * ''project.rooms'' – used to display room information.
     144 * ''project.reservation_equipment'' – used to display requested equipment if it exists; this table was created in Phase P2 from the ''requests_equipment'' M:N relationship in the corrected ER model.
     145 * ''project.equipment'' – used to display equipment names.
     146 * ''project.approvals'' – used to display and store the approval decision.
    147147
    148148This use-case modifies the database by:
    149149
    150 updating the status of the selected reservation in ''project.reservations'';
    151 inserting a new approval decision in ''project.approvals''.
     150 * updating the status of the selected reservation in ''project.reservations'';
     151 * inserting a new approval decision in ''project.approvals''.
    152152
    153153== Result of the implementation ==