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