Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

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!

Views: 579

Replies to This Discussion

Share the Assignment Questions & Discuss Here.... 

Stay touched with this discussion, Solution idea will be uploaded as soon as possible in replies here before the due date.

RSS

Looking For Something? Search Below

VIP Member Badge & Others

How to Get This Badge at Your Profile DP

------------------------------------

Management: Admins ::: Moderators

Other Awards Badges List Moderators Group

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service