Question: Assume a database for tracking project work completed by a contracting company has been created. Employees work on project. The daily hours each employee

Assume a database for tracking project work completed by a contracting company

Assume a database for tracking project work completed by a contracting company has been created. Employees work on project. The daily hours each employee worked is tracked in the Project hours table. Each project is for a customer. The expenses relating to each project is tracked in the Project Expenses table. Similarly, the payments received for each project is tracked in the Project Payments table. Analyze the database schema shown below. Based on the analysis create Dimensional model. Employees EmployeelD Company Last Name First Name E-mail Address Job Title Business Phone Home Phone Mobile Phone Address City State/Province ZIP/Postal Code Country/Region Hourly Rate Project Payments PaymentID ProjectID Payment Amount Payment Date Payment Method Project Hours ProjectID EmployeeID Date Worked Work Description Billable Hours Work Code Projects ProjectID Project Name Owner CustomerID Category Priority Status BeginDate EndDate BudgetAmount PO Number Notes 81 Project Expenses ExpenseID ProjectID Employee Expense Date Description Expense Code ExpenseAmount Customers CustomerID Company Last Name First Name E-mail Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address City State/Province ZIP/Postal Code Country/Region Notes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!