[Solved] CS614 Assignment 2 Spring 2021
Assignment No. 2 (Graded)
Semester Spring 2021
Total Marks: 20
Due Date: 07-06-2021
This assignment has been designed to develop your ability to Dimension Modeling and star schema
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.
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!
CS614 Assignment 2 Spring 2021
CS614 Assignment 2 Spring 2021 solution idea: