Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please write out new tables for 1NF,2NF,3NF. Thanks! Convert into 1NF, 2NF and 3NF Project Title Project Code PC010 Project Manager M Phillips Project Budget

image text in transcribedPlease write out new tables for 1NF,2NF,3NF. Thanks!

Convert into 1NF, 2NF and 3NF Project Title Project Code PC010 Project Manager M Phillips Project Budget 24500 Employee No. S10001 Employee Name A Smith Department No. L004 Department Hourly Name Rate 22.00 PC010 M Phillips 24500 S10030 LJones L023 Pensions 18.50 PC010 M Phillips 24500 P Lewis L004 IT 21.00 PC045 H Martin S21010 S10010 S10001 B Jones L004 IT 17400 17400 21.75 PC045 H Martin A Smith L004 IT 18.00 Pensions System Pensions System Pensions System Salaries System Salaries System Salaries System Salaries System HR System HR System HR System Pensions System PC045 H Martin 17400 531002 T Gilbert L028 Database 25.50 PC045 H Martin 17400 S13210 W Richards L008 Salary 17.00 I PC064 PC064 PC064 PC010 K Lewis K Lewis K Lewis M Phillips 12250 12250 12250 24500 S31002 S21010 S 10034 T Gilbert P Lewis B James A Smith LO28 L004 L0091 L004 Database IT HR 23.25 17.50 16.50 22.00 Pensions S21010 S10010 LJones P Lewis B Jones LO23 L004 L004 18.50 21.00 21.75 PC045 H Martin 17400 Salaries System PC064 HR System K Lewis 12250 S10001 S31002 S13210 S31002 S21010 S10034 A Smith T Gilbert W Richards T Gilbert P Lewis B James L004 L028 LO08 L028 L004 L009 Database Salary Database IT HR 18.00 25.50 17.00 23.25 17.50 16.50 L

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Objects And Databases International Symposium Sophia Antipolis France June 13 2000 Revised Papers Lncs 1944

Authors: Klaus R. Dittrich ,Giovanna Guerrini ,Isabella Merlo ,Marta Oliva ,M. Elena Rodriguez

2001st Edition

3540416641, 978-3540416647

More Books

Students also viewed these Databases questions