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

  The primary causes of the data breach

Case Study: Data Breaches and Regulatory Requirements, Describe the data breach incident and the primary causes of the data breach

  Produce a distributed data design for enterprise

Produce a distributed data design for this enterprise. Show data fragmentation/partitioning and replication for each regional database location. Indicate what attributes are in each fragment

  Review the subsequent list of data management difficulties

how data warehousing, online transactional databases, and data mining can solve or reduce these difficulties. Be specific.

  Database normalization solution

Database Normalization Solution

  Er diagram and database schema

To analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Advantages and disadvantages of downloading software

Write a 700- to 1,050-word paper describing the steps involved in downloading files and programs from the Internet.

  Contrast unstructured and structured data

Reflect on the textbook readings. Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment

  Create a decision table that describes movement of inventory

Name four attributes that you can use to define a data flow in the grocery inventory information system.

  Create a database design specification

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd Normal Form.

  Provide a logical and physical design

Design and develop a database using professional principles and standards. Provide a logical and physical design of the database.

  Find and display the total owed for all taxpayers

Exit the program (If the user choices 4, the program will exit. If the user chooses 1, 2 or 3, the program will do what the menu item says it will do, and then the menu will appear again.

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

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