Country : Canada
Assignment Task:

Task:

 

Assignment 2 - Mini Case for Practice Problems in Module 3/Lecture 3 This mini case study provides practice and preparation for the concepts that you learned in module

3. You will get to apply most of the concepts from module 3 and some of the concepts from module

2. This mini case study contains two data sources with sample data along with a statement of business needs. Using the data sources and business needs, you will specify a dimensional model with dimensions, measures, and grain, create a schema design for the data warehouse that integrates the data sources, identify summarizability problems in the design, and populate data warehouse tables from sample rows in the data sources. Data Sources The case study involves two data sources for a retail firm. The Purchase database supports purchase transactions to replenish retail inventory. A purchase consists of a heading with the purchase number, date, payment method, delivery date, and supplier. A purchase contains a collection of products with the quantity and unit cost recorded on a purchase line along with links to the product and purchase heading. Each product has one preferred supplier. However, a purchase can use a non-preferred supplier if necessary. Individual stores of the retail firm also maintain an inventory of custom products ordered from local suppliers. These products are ordered through the purchase spreadsheets for custom products. Inventory practices for custom products are informal. New products are typically purchased when the manager senses new demand for local items. The ERD in Figure 1 supports the purchase database. Tables 1 to 4 show sample data for the tables in the purchases database. The supply purchase spreadsheet (Table 5) contains a Mini Case for Practice Problems in Module 3/Lecture 3 2 sample of purchases of custom products from local suppliers. The Stock column in the spreadsheet indicates the quantity in stock at the time of purchase. Figure 1: ERD for Retail Purchase Operations

Table 1: Sample Data for the Supplier Table SuppNo SuppName SuppEmail SuppPhone SuppDisc S2029929 ColorMeg, Inc. custrel@colormeg.com (720) 444-1231 0.10 S3399214 Connex help@connex.com (206) 432-1142 0.12 S4290202 Ethlite ordering@ethlite.com (303) 213-2234 0.05 S4298800 Intersafe orderdesk@intersafe.com (512) 443-2215 0.10 S4420948 UV Components custserv@uvcomponents.com (303) 321-0432 0.08 S5095332 Cybercx orderhelp@cybercx.com (212) 324-5683 0.00

Table 2: Sample Data for the Product Table ProdNo ProdName SuppNo ProdQOH ProdPrice ProdNextShipDate P0036566 17 inch Color Monitor S2029929 12 $169.00 02/20/2013 P0036577 19 inch Color Monitor S2029929 10 $319.00 02/20/2013 P1114590 R3000 Color Laser Printer S3399214 5 $699.00 01/22/2013 P1412138 10 Foot Printer Cable S4290202 100 $12.00 P1445671 8-Outlet Surge Protector S4298800 33 $14.99 P1556678 CVP Ink Jet Color Printer S3399214 8 $99.00 01/22/2013 P3455443 Color Ink Jet Cartridge S3399214 24 $38.00 01/22/2013 P4200344 36-Bit Color Scanner S4420948 16 $199.99 01/29/2013

 

The above IT Assignment has been solved by our  IT Assignment  Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Pearl
  • Posted on : October 06th, 2019

Whatsapp Tap to ChatGet instant assistance