Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below is a sample Project Management Report that ABC Company uses. Your task is to begin the process of creating a set of normalized relations
Below is a sample Project Management Report that ABC Company uses. Your task is to begin the process of creating a set of normalized relations based on this form. Project Management Report Project No. Project Title: 035 Pensions System Project Manager: Project Budget: Mike Phillips $75,000 Department No. Department Name Number of Hours 110 40 Employee No. 101 135 316 556 564 621 Total Statt: 200 Employee Name Antoine Smith Liz lones Yvonne Lewis Anita Stent Denise Smith Laura Davis 6 Hourly Rate $75 $137 $55 $109 $75 $111 $94 Accounting Administration 40 190 60 Accounting Average Rate: Note. Hourly rate is the rote charged for each employee to any project that the employee is assigned Show the NNF relational schema for the above form. (4 points) b. Why is the above schema not yet INF-be very specific. (2 points)
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