Consider the table above.

• Identify the tables in their current normal forms (1, 2, 3 or no forms).

• Follow the stepwise process an normalize the table and create a relations between the tables.

  You are only responsible up to 3NF. Show step by step process.

• Create dependency diagrams

• Use conventional methods (all caps) to write the table name, primary key/s, functional

• dependencies, partial dependency and transitive dependency.

Purpose: Comprehend the normalization concept and implement in designing database

ata Table name: RPT FORMAT JoB CLASS CHG HOUR HOURS PROJ-NUM PROJ-NAME I EMP-NUM! EMP-NAME S Evergreen 103 June E.Arbough 23.8 $105.00 19.4 12.6 23.8 45.3 $84.50 Elect. Engineer Database Designer John G. News Alice K. JohnsonDatabase Designer William SmithfieldProgrammer David H. Senior Annelise Jones James J. Frommer General Support Anne K. RamorasSystems Analyst Darlene M. Smithson DSS Analyst Alice K. JohnsonDatabase Designer Anne K. RamorasSystems Analyst Delbert K. Joenbrood Applications Designer Geoff B.Wabash Clerical Support William Smithfield Progr ammer Maria D. Alonzo $105.00 $35.751 $96.75 Systems Analyst Applications Designer $48.1024.6 8 Amber Wave 114 $18.36 $96.75 $45.95 Rolling Tide 105 104 $105.00 $96.75 $48.10236 $26.87 35.75 35.75 $96.75 $105.00 S96 106 Starflight 107 115 Programmer 24.6 45.8 56.3 Travis B. Bawang Systems Analyst John G.News Annelise Jones Ralph B Washington Systems Analyst James J Frommer-..General Support Darlene M. SmithsonDSS Analyst Database Designer $1 Applications Designer $48.10 2 . $18.36 30 $45.95