Changes between Initial Version and Version 1 of P3


Ignore:
Timestamp:
12/30/25 13:42:54 (18 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P3

    v1 v1  
     1== Application Design – Use Cases and Database Access Scenarios – SQL Views
     2
     3== Actors
     4
     5**Guest User (Unauthenticated User)**
     6   
     7  * Has a read-only view of all the stores, products, reviews and rating
     8  * Browse products by category and store
     9  * Cannot manage data in the system before registration or login
     10
     11**Registered Boss**
     12
     13   A privelaged user who registers as a store owner, registers their store and their employees
     14
     15  * Manage personal profile
     16  * Manage employee profiles ONLY for the employees in their store and track their work hours and wages
     17  * Manage their store products
     18  * Interact with costumers
     19  * Oversee employees and store operations
     20  * Review financial data, sales trends, and damages
     21  * Edits and approves reports for their store
     22
     23
     24**Employee**
     25
     26A store staff member with system access
     27
     28  * Respond to customer requests
     29
     30  * Manage product changes (price, availability, description,...)
     31
     32  * Track work hours
     33
     34  * May have ability to view store-specific reports
     35
     36**Registered Shopper**
     37
     38A user who creates an account to place orders and interact with stores
     39
     40  * Manage personal profile and delivery addresses
     41  * Browse products by category and store
     42  * Place orders and view order history
     43  * Submit different requests to different stores
     44  * Leave reviews and ratings for completed orders
     45  * Request refunds
     46
     47== Scenarios
     48
     49[wiki:StoreRegistration Store and Owner Registration]
     50
     51[wiki:EmployeesRegistration Employees Registration]
     52
     53[wiki:ProductCreation Product Creation]
     54
     55[wiki:ProductChange Product Update (Price / Availability / Description)]
     56
     57[wiki:GenerateReports Generating Store Reports]
     58
     59[wiki:ClientRegistration Client Registration]
     60
     61[wiki:ClientLogin Client Login]
     62
     63[wiki:BrowseProducts Browse Products and Categories]
     64
     65[wiki:PlaceOrder Placing an Order]
     66
     67[wiki:OrderTracking Order Status Tracking]
     68
     69[wiki:LeaveReview Leaving a Review]
     70
     71[wiki:SubmitRequest Submitting a Customer Request]
     72
     73[wiki:AnswerRequest Answering a Customer Request]
     74
     75[wiki:RefundProcessing Refund Processing]
     76
     77== Most Important Use Cases
     78
     79[wiki:StoreRegistration Store and Owner Registration]
     80
     81[wiki:ClientRegistration Client Registration]
     82
     83[wiki:PlaceOrder Placing an Order]
     84
     85[wiki:SubmitRequest Submitting a Customer Request]
     86
     87[wiki:ProductChange Product Update]
     88
     89[wiki:GenerateReports Generating Reports (Monthly / Yearly / Sales / Profit)]
     90
     91[wiki:RefundProcessing Refund Processing]