| | 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 | |
| | 26 | A 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 | |
| | 38 | A 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] |