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

  One of the needs that your client has is a databaseto

one of the needs that your client has is a database.to design a database a database planner should spend a considerable

  Design an entity relationship diagram

Design an Entity-Relationship diagram for the baseball database and enter the design using a data-modeling tool such as ERWin.

  You were hired as an analyst to develop a new information

you were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size

  Explaining unclustered b pus tree index

Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.

  What type of failure is this and how would it be resolved

A technician accidentally drops screw into the server case and shorts out the motherboard of the server that is running you Oracle database (the database is running at the time of the incident). What type of failure is this and how would it be res..

  Create new blank database in access and save using your name

Create the attributes (fields) for each table. Field names should be fully qualified (i.e. the table name should be included as part of the field name. Field names should not contain spaces (e.g. CustomerLastName)).

  How many entity types are involve in a tertiary relationship

How many entity types are involved in a tertiary relationship? The process of arranging attributes of entities in a given business environment into database structures is known as.

  Determine the best shipment of coal cars

The Southern Rail Company ships coal by rail from three coal mines to meet the demand requirements of four coal depots. The following table shows the distances from the mines to the various depots and the availabilities and requirements for coal

  Show all the lastnames from the customers table

Show all the LastNames from the Customers table and any associated OrdersIDs from the Orders Table.

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Assignment- database administrator for department store

Assignment: Database Administrator for Department Store, The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maint..

  Knowledge and data warehousing

Knowledge and Data Warehousing

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