This Question is from Database management course.This Table below needs to be converted in 1NF, 2NF, 3NF and the E-R diagram and UML notation.

Convert the data contained in the report to 1NF by means of flattening (7 marks) 4. Convert your resulting 1NF to 2NF (10 marks) 5. From the tables generated in 2NF. What kind of attribute do you think Total charged is? Do you recommend keeping it as a column in the resulting table? Explain (10 marks) 6. After reaching third normal form Job class can still be subject to anomalies or redundancy, why? What do you propose to solve the issue? (8 marks) 7. Generate an E-R diagram, in UML notation, that is a constitutes a good conceptual design of your resulting database (12 marks)

Project NumberProject NameEmployee Number Job class Charge/Hour Hour billed Total charged 84.50 105.00 105.00 35.75 Employee Name 103 101 une E. Arbough John G. News Alice K. Johnson William Smithfield 2,011.10 2,037.00 3,748.50 450.45 2,302.65 Elec. Engineer Database Designer Database Designer Programmer Senior Systems Analyst 96.75 Subtotal Applications Designer $48.10 General Support Systems Analyst DSS Analyst Subtotal Database Designer Systems Analyst Evergreen 23.8 102 $10,549.70 1,183.26 831.71 3,134.70 S2,021.80 Amber Wave114 Annelise Jones James J. Fromer Anne K. Ramoras Darlene M. Smithson $ 18.36 96.75 S45.95 44.0 $7,171.47 Rolling Tide 105 105.00 96.75 6,793.50 4,682.70 1,135.16 591.14 457.60 Alice K. Johnson Anne K. Ramoras Delbert K. JoenbroodApplications Designer $48.10 Geoff B. Wabash William Smithfield $26.87 35.75 Clerical Support Programmer Subtotal Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst Subtotal 22.0 12.8 13,660.10 $879.45 Starflight 35.75 96.75 107 Maria D. Alonzo Travis B. Bawangi John G. News Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson $ 4,431.15 5,911.50 1,592.11 2,283.30 559.98 1,902.33 101 $105.00 48.10 96.75 45.95 $17,559.82 48,941.09 Note: A indicates the project leader