Nazim Ali added a discussion to the group CS614 Data Warehousing
from Latest Activity on Virtual University of Pakistan https://ift.tt/3vTttiN
cs614 assignment 2 solution 2021
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/EntitiesAttributesEmployeeEMP_ID, Name, Address, Contact no, Email. ManagerManager_ID, Name, Designation, EmailClientClient_ID, Name, Address, Contact no, EmailProjectProject_ID, Project name, Project Location, Project amount, Total projectOrderOrder_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!See More
from Latest Activity on Virtual University of Pakistan https://ift.tt/3vTttiN
