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 & their details
Suggest missing component
Review component suggestion
Add component from suggestion
View all builds & their details
Rate and review build
Favorite build
Create build
Clone build
Get compatible components for 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