Changes between Initial Version and Version 1 of UseCase0010

Timestamp:

01/07/26 23:13:08 (46 hours ago)

Author:

213257

Comment:

--

UseCase0010

@@ +1 @@
+== Use-case 0010 - Browse Properties ==
+
+'''Initiating actor:''' Client
+
+'''Other actors:''' None
+
+'''Description: '''
+
+A client browses apartment units by first selecting a building, then viewing its floors, and finally exploring individual units. They can view details, images, and pricing information for each unit.
+
+'''Scenario:'''
+
+1. Client accesses the property listing page.
+
+2. System displays all buildings:
+{{{
+SELECT 
+    building_id,
+    name,
+    address,
+    description
+FROM building
+ORDER BY name;
+}}}
+
+3. Client sees a list of buildings with their names, addresses, and brief descriptions.
+
+4. Client clicks on "Golden Tower" building.
+
+5. System displays the building details and all its floors:
+{{{
+SELECT 
+    b.building_id,
+    b.name AS building_name,
+    b.address,
+    b.description,
+    a. full_name AS architect_name,
+    f.floor_id,
+    f.floor_number,
+    f.layout_image
+FROM building b
+LEFT JOIN designs d ON b.building_id = d.building_id
+LEFT JOIN architect a ON d.architect_id = a.architect_id
+JOIN floor f ON b.building_id = f.building_id
+WHERE b.name = 'Golden Tower'
+ORDER BY f.floor_number;
+}}}
+
+6. Client sees building information and a list of floors with their images.
+
+7. Client clicks on "Floor 2". 
+
+8. All units on Floor 2 are displayed with minimal information:
+{{{
+SELECT 
+    u.unit_id,
+    u.unit_number,
+    u.room_number,
+    u.floor_area,
+    u.price,
+    u.status,
+    u.image
+FROM unit u
+WHERE u.floor_id = (
+    SELECT floor_id 
+    FROM floor 
+    WHERE building_id = (SELECT building_id FROM building WHERE name = 'Golden Tower')
+    AND floor_number = 2
+)
+ORDER BY u.unit_number;
+}}}
+
+9. Client sees a list of units showing their respective minimal information:  unit number, room count, area, price, status, and thumbnail image.
+
+10. Client clicks on "Unit 201" to view full details.
+
+11. System displays complete unit information: 
+{{{
+SELECT 
+    u. unit_id,
+    u. unit_number,
+    u. room_number,
+    u. floor_area,
+    u. price,
+    u.status,
+    u.image,
+    u.floorplan,
+    u.vector_image
+FROM unit u
+JOIN floor f ON u.floor_id = f. floor_id
+JOIN building b ON f.building_id = b. building_id
+WHERE u.unit_number = '201'
+AND f.floor_number = 2
+AND b.name = 'Golden Tower';
+}}}
+
+12. Client views all images, floorplan, building description, architect information, and pricing details.
+
+13. Client can navigate back to floor view, building view, or click a button to inquire about the unit that is being displayed.