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 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
Get step-by-step solutions from verified subject matter experts
