Analyze how sales of individual items would be entered

Assignment Help Database Management System
Reference no: EM131454664

Assignment: 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 9 -narrated slide presentation, with appropriate graphic
• A written business proposal (approximately two pages)

Score guidelines

• whether you do a PowerPoint slide or a two-page business proposal, here is how you can earn points:
• How a system could improve efficiency (a PowerPoint slide or MS Word section called "Improving Efficiency")
• How a system could improve accuracy ("Improving Accuracy")
• How sales of individual items would be entered ("How Sales Entered into Database")
• How the database would store the data compared to the current spreadsheet method ("Database Storage") -- consider retrieval, too
• How monitoring of inventory levels based on sales using the database would work ("Inventory Monitoring")

Plus, for good editing/mechanics and clear presentation with clear slide headings or MS report section headings as noted above. Ideally you will integrate external research with APA citations and a Reference section.

Reference no: EM131454664

Questions Cloud

How can you define a dual relationship to a layperson : How can you define a dual relationship to a layperson? What prohibitions does the APA Ethics Code place on psychologists regarding dual relationships?
Explain if a firewall is enabled on your machine : Identify if a firewall is enabled on your machine and if you need Windows firewall running in addition if that anti-virus software is installed on your machine.
Issues in the more lanes : Post a 250-word response in which you compare how choices related to urban issues in the "More Lanes" scenario affect the quality of life for citizens involved
What value did you calculate for pearsons r : Do these two variables seem to have a strong linear relationship? Draw a graph, and describe what you see.What value did you calculate for Pearson's r?
Analyze how sales of individual items would be entered : How sales of individual items would be entered? How the database would store the data compared to the current spreadsheet method?
Check all the statements accordingly : A sample of midterm grades for five students showed the following results: 72. 65. 82, 90. 76. Which of the following statements are correct.
Leadership tactics according to the criteria : Create a 15- to 20-slide Microsoft® PowerPoint® presentation on the interaction and influence among leadership tactics according to the following criteria:
What ways does tomboy challenge : In what ways does Tomboy challenge and subvert more traditional conceptions and representations of gender, and why does it seek to do so?
Explain a summary of three health-related technologies : Explain A summary of at least three health-related technologies. The advantages of each one, including how it helps in preventing a health issue.

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