Develop some reports and queries for running the business

Assignment Help Database Management System
Reference no: EM13946420

See the attached Database file (store and Regional sales)>!!

The database contains raw data on weekly store sales of computer equipment in various sales regions. You'll be using access to manage the data and turn it into useful information.

The database includes fields for record number, store identification number, sales region, item number, item description, unit price, units sold, and the weekly sales period when the sales were made.

Develop some reports and queries to make this information more useful for running the business. Sales and production managers want answers to the following questions:

1. which products should be restocked?

2. which stores and sales regions would benefit from a promotional campaign and additional marketing?

3. When (what time of year) should products be offered at full price and when should discounts be used?

You can easily modify the database table to find and report your answers print your reports and results of queris and if you modify it explain why did you do that.

Attachment:- MIS10ch01_questionfile.zip

Reference no: EM13946420

Questions Cloud

What type of security policy should be used and why : What technologies should be used to secure those areas?
What are the conditions for lasing : What does LASER stand for - what are the conditions for lasing and calculate the maximum allowed thickness of the active layer of single transversal mode operation
Relatively high vapor velocities : Consider the situation of Problem 10.67 at relatively high vapor velocities, with a fluid mass flow rate of m = 2.5 kg/s. Determine the heat transfer coefficient and condensation rate per unit length of tube for a mass fraction of vapor of X = 0.2.
Will the au behave as a donor or acceptor : . ED and EAlevels both exist for the Au and both are close to the middle of the Si bandgap. if a small concentration of Au is placed in an N-type material Si crystal, will the Au behave as a donor or acceptor? expain.
Develop some reports and queries for running the business : The database includes fields for record number, store identification number, sales region, item number, item description, unit price, units sold, and the weekly sales period when the sales were made.
Compute descriptive statistics weekly hours spent studying : Perform a categorical data analysis on the majors of students enrolled in the MBA program. Report on your findings, along with a table showing the frequency distribution and at least one chart (pie chart or bar chart) that illustrates the points r..
Motor stationary, voltage drop in the armature winding : Calculate the efficiency of a 500V shunt motor when taking 700A from the following data taken when the motor was hot: motor stationary, voltage drop in the armature winding 15V.
Total condensation rate and heat transfer rate : Determine the total condensation rate and heat transfer rate for the process of Problem 10.46 when the pipe is oriented at angles of () = 0, 30, 45, and 60° from the horizontal.
What''s the significance of the programming language : What are you going to recommend and why - again with reference to his remarks

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