Share:
Notifications
Clear all

[Solved] CS614 Assignment 2 Spring 2021


admin
(@admin)
Admin
Joined: 3 years ago
Posts: 6411
Topic starter  
 

Assignment No. 2 (Graded)

Semester Spring 2021
Data Warehousing– CS614

Total Marks: 20

Due Date: 07-06-2021

Objective:

This assignment has been designed to develop your ability to Dimension Modeling and star schema

Instructions:

Please read the following instructions carefully before solving & submitting the  assignment:

1.      The assignment will not be accepted after due date.

2.      Zero marks will be awarded to the assignment that does not open or the file is corrupt.

3.      The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.

4.      Zero marks will be awarded to the assignment if copied (from other students, internet or any source).

5.      Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at [email protected]

 

Please do not post queries related to assignment on MDB.

 

Note: The assignment covers lectures 10-14.

 

 

Question  (Marks 20)      

An XYZ construction company wants to develop data warehouse, so that they can easily and efficiently manage their employees, clients, projects and finance.

Company has different employees who work on different projects. Client can visit the website, view completed projects details and client’s review/feedback about projects, places an order by filling the order form, give review/feedback. Manager can assign projects to employees, view assigned projects. Manger can also view placed orders, can accept or cancel the order. He can also generate receipt; client will be able to view and download the receipt. Employees should be able to view assigned projects; he can also update status of the project as started, partially completed, or completed.

 

Table Name/Entities

Attributes

Employee

EMP_ID,Name, Address, Contact no, Email.

 

Manager

Manager_ID, Name, Designation, Email

Client

Client_ID, Name, Address, Contact no, Email

Project

Project_ID, Project name, Project Location, Project amount, Total project

Order

Order_id, Order date,

 

Receipt

 

Receipt_ID, Total billed amount, Tax Amount

                                                                                                        

You have studied four steps which are involved in dimensional modeling. First step is to identify the business process. Consider the process “Project” 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.

 

 

Note: Deadline for assignment submission is 07 JUNE 2021.

Wish you best of Luck!

 

Students kindly share assignment files in relevant subject timely for discussion/solution.
or directly share with us " Click here"
QueryVU Telegram Groups subject wise Join Now
QueryVU WhatsApp groups subject wise Join Now


Quote
admin
(@admin)
Admin
Joined: 3 years ago
Posts: 6411
Topic starter  

CS614 Assignment 2 Spring 2021


CS614 Assignment 2 Spring 2021 solution idea:

 

 

Students kindly share assignment files in relevant subject timely for discussion/solution.
or directly share with us " Click here"
QueryVU Telegram Groups subject wise Join Now
QueryVU WhatsApp groups subject wise Join Now


ReplyQuote
Share: