Here it is:
- Design a billing database for a coffee shop where 3 mean are at work selling coffee. And coffee shop is famous for delivering coffees in different flavors:
- Cold coffee.
- Coffee with cream.
- Roasted Coffee.
- Just coffee.
- Coffee blended with vanilla.
Requirement of manager:
- Get aggregated result of the sales men for each date.
- Get aggregated result of the sales made as per flavors.
- Get aggregated sale of till date, Find the person who made the highest sale get him 15% bonus (Note: Salary for all of them is equal).
- Get the statistics to show which flavor is most successful till date.
Please teach me the procedure to create tables,attributes Or Plz get me the solution. Plz all MYSQL lovers assist me.