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

  Implement an access database

They have asked you to implement an Access database so they can add, modify and delete data as well as generate queries and reports based on the information contained in the database

  Find names of all students who are enrolled in two classes

Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught.

  Pl and sql functions

PL and SQL functions

  Use sql to create database

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

  Discuss the reasons for converting sql queries into

1. what a query execution plan?2. discuss the reasons for converting sql queries into relational algebra queries before

  Draw context diagram data flow diagram for system described

Draw a context diagram data flow diagram for the system described above. The format should be similar to the context diagram in figure 5-13 of your textbook.

  Discuss common input - output technologies

Create a Microsoft Word table that identifies the advantages, disadvantages, computer requirements, initial costs, and future savings for an organization considering an engagement in virtualization.

  Code for event handler for the onclick event

Write the code for the event handler for the OnClick event of btnReset. Write the code for event handler for the OnClick event of btnCheck so that the number of occurrences of the selected vowel are counted and displayed.

  Analyze these database products for their appropriate uses

Analyze these database products for their appropriate uses, strengths, and weaknesses in comparison with the needs of your organization. Recommend and defend the best DBMS product(s) for fully addressing the broad, high-level technological and ope..

  Discuss the formula for computing entropy

The paper must discuss the relationship of Entropy to the likelihood that an attack can be successful, the formula for computing Entropy.

  Converting from sql server database to the oracle database

Assignment: The Stevens Company is converting from the SQL Server database to the Oracle database

  Binary 1-n relationship-optional-to-optional relationship

Give examples of binary 1:N relationships, for (a) an optional-to-optional relationship, (b) an optional-to-mandatory relationship,

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