Skip to content

CS614 Assignment 2 Solution Fall 2021

CS614 Assignment 2 Solution Fall 2021, CS614 Assignment Solution 2021, CS614 Assignment 2 Solution 22022, CS614 Assignment 2 Solution Fall 2022.

The assignment will not be accepted after due date. Zero marks will be awarded to the assignment that does not open or the file is corrupt.  The assignment file must be an MS Word (.doc) file format; the Assignment will not be accepted in any other format. Zero marks will be awarded to the assignment if copied (from other students, internet or any source). Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

Question No 1 CS614 Assignment 2 Fall 2021

A multinational company ABC deals with manufacturing products. The company wants to develop data warehouse, so that they can perform various analyses like decision making and prediction on available data. To build a product, company requires manufacturing components from different suppliers. Company needs to manage suppliers’ information such as contract detail, payment etc. After manufacturing, company delivers their products to their registered distributors for sale. After receiving the products, the distributor pays amount to the company. Given below is the ERD of the above-given scenario.

You have studied four steps which are involved in dimensional modeling. The first step is to identify the business process. Consider the process “Product” described above in table. Apply the remaining steps of dimensional modeling to find out the grain, facts and dimensions and then create a simplified star schema from the details mentioned in above table.

Question No 1 Solution fall 2021 CS614 Assignment 2

Step1: Choose the Business Process

        The Business Process is “Product”

Step2: Choose the Grain

        Total Number of Product Sale to the Distributors

Step3: Choose the Facts

        The Facts in our case are “Total Payment”, “GST”, “Product Price”, “and Quantity”.

Step4: Choose the Dimensions        The dimension will be “Supplier”, “Payment”, “Distributer”,  “Component”, ” and “Product”.

CS614 Assignment 2 Solution Fall 2021, CS614 Assignment Solution 2021, CS614 Assignment 2 Solution 22022, CS614 Assignment 2 Solution Fall 2022.

error: Content is protected !!
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Kindly Disable Your Adblocker Extensions