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

Object oriented approach versus the relational one

Is the relational database model doomed to extinction or are there characteristics of the relational model which make it better suited in certain situations than its object

Construct an er diagram for a hospital

Construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.conve

Reverse-complement of a dna string

The reverse-complement of a DNA string is a new string in which each nucleotide is replaced by its complement and the string is reversed -  its complementary strand can be re

Message of arbitrary bit length

Suppose H(m) is a collision-resistant hash function that maps a message of arbitrary bit length into an n-big hash value. Is it true that, for all messages x, x1 with x=x1,

Discuss cloud computing and saas

Your team has decided to discuss 1) cloud computing, 2) SaaS (software as a service), 3) web, social media, and big data, and 4) real-time data. Create a PowerPoint with a m

Create a database with at least eight records

Create a database with at least eight records added to keep track of your favorite television shows. Each record should have at least five fields of your choice. Submit th

Create a query using list of values match

Create a list the holds the student grade (A, A-, B+,..), modify the appropriate table to accept only the grades in the list(you need to explain why you selected the above t

Complete information-level design for set of requirements

A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Determine any constraints yo

Reviews

Write a Review

 
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