Process of Normalizing, Database and Information Table below shows the lists of staffs who work in a

Process of Normalizing, Database and Information

Transcribed Image Text:

Table below shows the lists of staffs who work in a given project. Each staff has their own Job Department, Price (per hour) and Total Hours. Employee Number (empID) is unique for every member of staff. projNo 1 STID3014 (DATABASE AND INFORMATION RETRIEVAL) GROUP C ASSIGNMENT 2 (Pair) 2 projName emplD Sunshine 11 22 33 Symphony 55 77 empName Adam Smith Amanda Jasmine Ann Rose Simon Lucas Julia Gisella jobDep hourPrice hour Total 15 17 Computing 77 Communication 66 Information Sc Electrical 57 71 Food Engineering 55 19 17 22 Show the process of normalizing the table from the First Normal Form (1NF) until the Third Normal Form (3NF). State any assumptions you make about the data shown in this table. Table below shows the lists of staffs who work in a given project. Each staff has their own Job Department, Price (per hour) and Total Hours. Employee Number (empID) is unique for every member of staff. projNo 1 STID3014 (DATABASE AND INFORMATION RETRIEVAL) GROUP C ASSIGNMENT 2 (Pair) 2 projName emplD Sunshine 11 22 33 Symphony 55 77 empName Adam Smith Amanda Jasmine Ann Rose Simon Lucas Julia Gisella jobDep hourPrice hour Total 15 17 Computing 77 Communication 66 Information Sc Electrical 57 71 Food Engineering 55 19 17 22 Show the process of normalizing the table from the First Normal Form (1NF) until the Third Normal Form (3NF). State any assumptions you make about the data shown in this table.