Normalise the table below to 3NF. Describe each of the steps involved aided by dependency diagrams. Label all partial and transitive dependencies in the dependency diagram as well as the normal form of the table.

Note: You only have to draw the dependency diagrams. you do not need to redraw the table.

Additional Instructions:

• You are allowed to draw the dependency by hand on a piece of paper or using any other means like Microsoft PowerPoint
• You need to write/include your index number beside the diagram before uploading the image file on eLearn
• Image file format should preferably be in JPEG or PNG
• Upload the dependency diagram image in the Files box (Max. size is 4 GB)

FAC FAC STUD TEAM_ID TEAM_NAMESTUD_IDNAME MAJOR MAJOR CODE DESC CODE DESC Computer Science T001 Decepticons 123518 Ahmad Al Artificial Intelligence cs Artificial Intelligence CS Computer Science 122548 Brad AL Electrical and Electronics 115224 Hock NANO Nanotech EE Software Engineering CS Computer Science 115488 Eve SE Computer Science TOO2 Artificial Intelligence CS Autobots 121589 Chris AI Computer Science 123334 lane SEC Security CS Electrical/ Electronics EE Electrical and Electronics 236587 Siti EE Computer Science 123123 Selvan AL Artificial Intelligence CS Electrical/ Electronics EE Electrical and Electronics T003 Transformers 112558 Sandeep EE Software Engineering CS Computer Science 232569 Kenneth SE Computer Science 112358 Shan SEC Security CS Electrical and Electronics 101225 Danial NANO Nanotech EE Artificial Intelligence CS Computer Science T004 Beast Wars 212111 Shafiq AL 123542 Syed Electrical/ Electronics Electrical and Electronics EE EE 111358 Jimmy Software Engineering CS Computer Science SE Software Engineering CS Computer Science 112251 Angelina SE