How sales of individual items would be entered

Assignment Help Database Management System
Reference no: EM131360428

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.

Submit your table in a Word document or on an Excel® spreadsheet to the Assignment Files tab above.

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:

• An 8- to 10-narrated slide presentation, with appropriate graphics - this choice must include speaker notes and audio to the presentation
• A written business proposal (approximately two pages)
• You can create a video to present your case

Make sure you have a detailed introduction and conclusion.

Reference no: EM131360428

Questions Cloud

Describe the fundamental of temperature and heat : Describe the fundamental differences and similarities between temperature and heat. Then, analyze how heat transfer occurs during the processes of conduction and convection. Provide one (1) example of where each occurs in natural physical systems.
Find the current in the resistor r using the laplace method : Find the output voltage y(t), for t > 0, using the Laplace transformmethod. Assume that 10 volts are applied at t 0 seconds.
How many calls will kelli made by the end of august : kelli calls her grandmother every month kelli also calls her cousin if kelli calls her cousin in January how many calls will kelli made by the end of august
Calculate the maximum induced bending stress : Assume that the timber member (a) of given Problem is used as a simply supported beam with a 12-ft span length carrying a uniformly distributed load of 500 lb/ft. The given load includes the weight of the beam. Calculate the maximum induced bendin..
How sales of individual items would be entered : 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?
Demonstrate an understanding of the forces impacting health : HS499-5: There are many forces that impact health delivery systems. Choose one aspect that influences how health delivery systems are challenged, and describe the issue. Examples include, but are not limited to, access to care, quality health care..
Calculate the maximum induced bending stress : It is to carry a uniformly distributed load of 3.0 kips/ft, which includes its own weight. Calculate the maximum induced bending stress.
Calculate the maximum bending stress : 2. A square steel bar, 38 mm on each side, is used as a beam and subjected to a bending moment of 460 N·m. Calculate the maximum bending stress.
Develop a decision tree : Deborah Kellogg buys Breathalyzer test sets for the Winter Park Police Department. The quality of the test sets from her two suppliers is indicated in the following table: Develop a decision tree

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd