if something looks blury please right-click and click on \"open image in new tab

Question

if something looks blury please right-click and click on "open image in new tab" so u can see it bigger.

Thanks

Question 13 10 pts Please Normalize the following l format in your final answe Functional Dependencies given. Please ensure you use the Database Schema rO Code PCO10 mplaye mplove artme ame Primos 24500 tsions8 50 10 PC PC PCO45 Salanas 18 artin 132 10 P. RSystem 10001 Project Code) (Project Title, Project Manager. Project Budget) (Employee No)-> (Employee Name, Departme (Department No)- (Department Name) Also, this will need a table in the schema to show who is assigned to which project Ra

Explanation / Answer

Project Code -> (Project Title, Project Manager, Project Budget) Employee No. -> (Employee Name, Department No. Hourly Rate) Department No. -> (Department Name) Given above functional dependencies we can divide the given the above given table in 3 different tables. Project, Employee and Department Project table Project Code Project Title Project Manager Project Budget PC010 Pension Systems M Philips 24500 PC045 Salary Systems H Martin 17400 PC064 HR Systems K Lewis 12250 Employee Table Employee No. Employee Name Department No. Hourly Rate S10001 A Smith L004 22 S10030 L Jones L023 18.5 S21010 P Lewis L004 21 S10010 B jones L004 21.75 S31002 T Gilbert L028 25.5 S13210 W Richards L008 17 S10034 B James L009 16 Department Table Department No. Department Name L004 IT L023 Pensions L028 Database L008 Salary L009 HR Employee Project Table Employee No. Project Code S10001 PC010 S10030 PC010 S21010 PC010 S10010 PC045 S31002 PC045 S13210 PC045 S10034 PC064

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.