ITGD2023: Convert the Report from the un-normal form into the third normal form. Provide appropriate names for each Entity and attributes: Database Design and Modelling Report, PSB, Singapore

Task 1 – Convert the Report from the un-normal form into the third normal form. Provide appropriate names for each Entity and attributes. Find the primary, Foreign, and composite
Note:

•  Find Un-Normalized form data
• Convert un-normalized set to 1NF
•  1NF to 2NF
• 2NF to 3NF
• In between the process of normalization find out Primary, foreign, and Composite keys.
• Discuss the steps of normalization while carrying each NF.
• Use appropriate tool to do the task

Task 2
1) Key in appropriate records for all the tables. (Sample, take from the project report given and add further meaningful records in the derived tables. Note: Minimum 20 records in Employee table and other tables any number of records)
2) Display Employee Name belongs to department either IT or Finance
3) Count No of Employees whose Hourly rate above 50
4) Find employee names starts with ‘S’
5) Display Department Name and Sum of Hourly Rate for each Department.