A website for a small-medium business owner to sell bicycles.
A growing business now wants to sell via the internet. Bicycles are the main product, but if the business continues to grow, the business willl surely start selling other sports-related items such as skis, surfboards, roller skates, etc. It would be a nice bonus if the same website allows to sell those things as well.
- Customers can completely customize their bicycles. They can select many different options for the various parts of the bicycle. Example list of parts and their possible choices
| Part | Part Options |
|---|---|
| Frame type | Full-suspension, diamond, step-through |
| Frame finish | Matte, shiny |
| Wheels | road wheels, mountain wheels, fat bike wheels |
| Rim Color | Red, Blue, Black |
| Chain | Single-speed, 8-speed |
- Some combinations that are prohibited because they are not possible in reality
| If you select "mountain wheels", then the only frame available is the full suspension |
|---|
| If you select "fat bike wheels", then the red rim color is unavailable because the manufacturer doesn't provide it |
-
Sometimes all the possible variations of each part are not in stock, and can be marked as "temporarily out of stock" to avoid incoming orders that would not be fulfilled
-
After customization, price is calculated by adding up the individual prices of each part that you selected.
| Part | Price (EUR) |
|---|---|
| Full suspension | 130 |
| Shiny frame | 30 |
| Road wheels | 80 |
| Rim color blue | 20 |
| Single-speed chain | 43 |
| Total | 303 |
- Price of a specific part option (like the matte finish) can vary depending on other parts or options selected by the user. E.g
| The price of the matte finish is not fixed but depends on the type of frame chosen. |
|---|
| The matte finish costs 50 EUR when applied to a full-suspension frame. |
| The matte finish costs 35 EUR when applied to a diamond frame. |
This indicates that the price of one option (the matte finish) can be influenced by multiple other choices in the customization. These kinds of variations can always happen and they might depend on any of the other choices (not only two). So they must be considered otherwise, the business would be losing money.
Please Refer to User Activity Diagrams
Please Refer to User Workflow & UI Descriptions
Please Refer to Entity Models & Relationships
Please Refer to Database Specifications
Please Refer to Trade-offs
Please Refer to Additional Considerations
External Docs: Google Docs
Diagrams: Draw.io
ERD: ERDLab.io