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
view component details
Suggest missing component
Review component suggestion
Add component from suggestion
View all builds
View build post details
Rate and review build
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