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

  Explain why log records could be written between the begin

Explain why log records could be written between the begin checkpoint and end checkpoint records.

  Choose a suitable indicator to plot the measure

Determine how you will collect the data elements needed for this measure (i.e. how will you collect the data elements needed to calculate the measure). Describe what those data elements are, and how they will be collected.

  List the name of the project with the lowest budget

List the names, ages, and salaries of managers of a user-specified sex (male or female) working in a given department. You can assume that, while there are many departments, each department contains very few project managers.2

  Describe features of the potential database

List the major topics of the database to track concerts and venues - Write a draft statement of work, including a brief history, a statement of scope, objectives, and preliminary timeline.

  Define the minimum and maximum cardinality

Don't worry about going through the normalization process at this point. Identify the appropriate relationships among the entities, and define the minimum and maximum cardinality of each relationship. Make some additional assumptions about the bus..

  Drawing a diagram of the data structures

Drawing a diagram of the data structures will help you figure out what you are deallocating as you write your dictionary_free function. This should help you avoid memory leaks.

  Design a high-level conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following: Integration layers and The data warehouse

  Define the term use case

Explain the difference between the > and > relationships in use case diagrams?

  Question 1 consider the relational schemapartpart-id name

question 1. consider the relational schemapartpart-id name costsubpartpart-id subpart-id counta tuple p1 p2 3 in the

  Create data warehouse sections including computers-dvds

Create a data warehouse for electronics store chain. The chain has 20 stores in 5 cities. Each store has different sections including computers, DVDs, TVs, audio, home appliances etc.

  Identify potential sales and department store transactions

Identify the potential sales and department store transactions that can be stored within the database. Design a database solution and the potential business rules that could be used to house the sales transactions of the department store

  Describe a dbms and its functions

Describe a DBMS and its functions. Name some of the popular DBMS software and you should search the Internet for the updated DBMS technology.

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