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

Store and Owner Registration

Employees Registration

Product Creation

Product Update (Price / Availability / Description)

Generating Store Reports

Client Registration

Client Login

Browse Products and Categories

Placing an Order

Order Status Tracking

Leaving a Review

Submitting a Customer Request

Answering a Customer Request

Refund Processing

Most Important Use Cases

Store and Owner Registration

Client Registration

Placing an Order

Submitting a Customer Request

Product Update

Generating Reports (Monthly / Yearly / Sales / Profit)

Refund Processing