Assignment: Point of Sale Data Collection
During your weekly trip to the grocery store, you purchase bread, milk, cold cereal, bananas, and ice cream. The purchase was made using a debit card.
Create a table listing at least seven data items collected in this transaction and how they are entered into the system.
Word document or on an Excel format only
Automating Sales and Inventory
As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items carried in the store.
Present your case for upgrading to a database driven solution for tracking sales and inventory to the store owners. They are concerned about the cost and want to know what this upgrade would entail
Include the following:
• How a system could improve efficiency
• How a system could improve accuracy
• How sales of individual items would be entered
• How the database would store the data compared to the current spreadsheet method
• How monitoring of inventory levels based on sales using the database would work
Choose one of the following presentation deliverables: powerpoint format only No PDF
• An 8- to 10-narrated slide presentation, with appropriate graphics
• A written business proposal (approximately two pages)
• Another deliverable approved by your faculty member
1. Overview--Provide an overview slide that outlines the key elements in the presentation-
2. State the business Problem for new database development--
3. State your solution and how the system will improve efficiency and accuracy
4. State how data would be input--
5. State how the new system would compare to the old systems--
6. What monitoring and inventory controls would be provided
7. Conclusion--
8. Reference--
Use of Notes and bullets.