The previous report is the only supporting document a contracting company has provided for getting a new database design. As the companys owner is very busy, he has requested you to generate a set of suitable relations with the report above. The process you will follow is itemized below, be brief but provide a good explanation when asked: 1. Considering Employee 112, in how many projects do you find him? What does it tell you in relation to employees? (7 marks) 2. Employee James J. Frommer had a problem with his pay coming from project 18. Why did it happen? What kind of anomaly could have created this situation? Explain (8 marks) 3. 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) 8. How would you represent the project leader in your brand-new conceptual design? (8 marks)

Project Report Project NumberProject Name Employee Number Employee Name Job class June E. Arbough John G. News Alice K. Johnson* William Smithfield David H Charge/Hour Hour billed Total charged $ 84.50 $105.00 $105.00 s 2,011.10 S 2,037.00 3,748.50 450.45 s 2,302.65 Evergreen 103 101 105 Elec. Engineer Database Designer Database Designer Programmer Senior Systems Analyst $96.75 Subtotal Applications Designer General Support Systems Analyst DSS Analyst Subtotal Database Designer Systems Analyst 35.75 102 $10,549.70 Annelise Jones James J. Fromer Anne K. Ramoras Darlene M. Smithson Amber Wave S 1,183.26 118 18.36 S 831,71 $ 96.75 3,134.70 s 2,021.80 $7,171.47 Rolling Tide Alice K. Johnsorn Anne K. Ramoras Delbert K. Joenbrood*Applications Designer $48.10 Geoff B. Wabash William Smithfield $105.00 $96.75 105 S 6,793.50 4,682.70 S 1,135.16 591.14 457.60 113 Clerical Support Programmer Subtotal Programmer Systems Analyst Database Designer Applications Designer $ 48.10 Systems Analyst General Support DSS Analyst Subtotal 106 $35.75 $13,660.10 Starflight Maria D. Alonzo Travis B. Bawangi John G. News* Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson 879.45 S 4.431.15 S 5.911.50 1,592.11 s 2,283.30 559.98 1,902.33 $ 96.75 $105.00 101 108 118 96.75 $18.36 $17,559.82 $48,941.09 Note: A indicates the project leader