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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started