Question Details

Computer Science Homework Help

2 Assignment about IT/200 class.

1. assignment Individual: 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

 
 
2. Assignment Individual: 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
Overview--Provide an overview slide that outlines the key elements in the presentation-
State the business Problem for new database development--
State your solution and how the system will improve efficiency and accuracy
State how data would be input--
State how the new system would compare to the old systems--
What monitoring and inventory controls would be provided
Conclusion--
Reference--
Use of Notes and bullets --