Application Scenarios for DB Access (SQL)

• Guest – user that is not signed in or registered in the system, can list all components, builds and reviews but can not add components, create and rate builds or write suggestions and reviews.
  
• User – user that is registered and signed in the system, can list all components, builds and reviews, can create and rate builds, write reviews, and add suggestions for components.
  
• Admin – registered and signed in user with special privileges such as managing components, reviews and user suggestions.
  

Use Cases

User registration

User login

View user dashboard

View admin dashboard

View all components

Suggest missing component

Review component suggestion

Add component from suggestion

View all builds

View build post details

Rate build

Write review for build

View another user's profile

Favorite build

Create build

Clone build

Add component to build

Remove component from build

Save build

Most important use cases

User Registration
User Login
View Components
Add Component
Create Build
Favorite Build