== Application Design – Use Cases and Database Access Scenarios – SQL Views

== Actors

**Guest User (Unauthenticated User)**
   
  * Has a read-only view of all the stores, products, reviews and rating
  * Browse products by category and store
  * Cannot manage data in the system before registration or login

**Registered Boss**

   A privelaged user who registers as a store owner, registers their store and their employees

  * Manage personal profile
  * Manage employee profiles ONLY for the employees in their store and track their work hours and wages
  * Manage their store products
  * Interact with costumers
  * Oversee employees and store operations
  * Review financial data, sales trends, and damages
  * Edits and approves reports for their store


**Employee**

A store staff member with system access

  * Respond to customer requests

  * Manage product changes (price, availability, description,...)

  * Track work hours 

  * May have ability to view store-specific reports

**Registered Shopper**

A user who creates an account to place orders and interact with stores

  * Manage personal profile and delivery addresses
  * Browse products by category and store
  * Place orders and view order history
  * Submit different requests to different stores
  * Leave reviews and ratings for completed orders
  * Request refunds

== Scenarios

[wiki:StoreRegistration Store and Owner Registration]

[wiki:EmployeesRegistration Employees Registration]

[wiki:ProductCreation Product Creation]

[wiki:ProductChange Product Update (Price / Availability / Description)]

[wiki:GenerateReports Generating Store Reports]

[wiki:ClientRegistration Client Registration]

[wiki:ClientLogin Client Login]

[wiki:BrowseProducts Browse Products and Categories]

[wiki:PlaceOrder Placing an Order]

[wiki:OrderTracking Order Status Tracking]

[wiki:LeaveReview Leaving a Review]

[wiki:SubmitRequest Submitting a Customer Request]

[wiki:AnswerRequest Answering a Customer Request]

[wiki:RefundProcessing Refund Processing]

== Most Important Use Cases

[wiki:StoreRegistration Store and Owner Registration]

[wiki:ClientRegistration Client Registration]

[wiki:PlaceOrder Placing an Order]

[wiki:SubmitRequest Submitting a Customer Request]

[wiki:ProductChange Product Update]

[wiki:GenerateReports Generating Reports (Monthly / Yearly / Sales / Profit)]

[wiki:RefundProcessing Refund Processing]