Bakery
History
Jenny has been running a bakery for 3 years. She has tried to keep to track of her sales and inventory on a spreadsheet, but has not managed to get clear idea of what her costs and profits if any are. She would like a database to track her real inventory costs as well as point of sale receipts.
Scope
The bakery database will track inventory purchases and usage. It will track waste. It will track sales and labor costs. The database will also track overhead costs. It will allow the owner to compare different types of sales and costs. It will also allow the tracking of customers and customer rewards.
Objective
The database will make the profit/ loss analysis of the bakery more transparent
TimeLine
- Basic scope and history
- Gather information—2 weeks
- Requirements /Business Rules--week
- Design –week
- Normalize—testing
- Build database –add sample data
- Test it with sql
- Security and disaster recovery analysis
No comments:
Post a Comment