10:44 ON ... 82% /^():) caucation Package Sales Bonus Get instant rewards when an Affiliate choose to purchase an Educational package! W White Binary Bonus 18 up to 36 B Black Binary Bonus 54 up to 108 G Gold Binary Bonus 144 up to 288 Titanium Binary Bonus 450 up to 900 III Lab Tutorial 6: Normalization. The_Kiosk Student Studenten Male Course No Course Name Istruttore Maths N001 Intro. Math 5201 English NASSO Basic English 5123 N3456ERIOARE 5433 2001 That Paris N1 Instructorhame Instructorication Grade Van W ein Windhoek 25 Shiko | Eros low Cimbebas The above table (The_Kiosk) contains academic records of students at ABC college in Windhoek. The principal of ABC college has asked you to create a database that can store all the students records as shown in table. The database should support transactions such as adding, removing and updating of student records To realize the above task, you are required to do the following i Normalize the The_Kiosk to Third Normal Form (3NF). [14 marks) ii. In each Normal Form presented indicate using an example the anomalies that need to be eliminated 16 marks] Lab Tutorial 7: MySQL Implementation. This tutorial is based on Lab Tutorial 6 that we did previously. To successfully complete this Lab Tutorial, you are required to write SQL queries in MySQL to realize the following: i. Implement the "The final tables" you obtained in Lab Tutorial 6(i). [6 marks i. Populate the tables with records as shown in The_Kiosk table (Lab Tutorial 6) 16 marks! iii. Display all the records in tables. [2 marks] iv. Update InstructorLocation for Van Dyk Katutura [6 marks] Note: Please note that you are required to print screen" both your SQL queries and output screen, and paste them onto your MS Word document for submission into elearning, 10:44 ON ... 82% /^():) caucation Package Sales Bonus Get instant rewards when an Affiliate choose to purchase an Educational package! W White Binary Bonus 18 up to 36 B Black Binary Bonus 54 up to 108 G Gold Binary Bonus 144 up to 288 Titanium Binary Bonus 450 up to 900 III Lab Tutorial 6: Normalization. The_Kiosk Student Studenten Male Course No Course Name Istruttore Maths N001 Intro. Math 5201 English NASSO Basic English 5123 N3456ERIOARE 5433 2001 That Paris N1 Instructorhame Instructorication Grade Van W ein Windhoek 25 Shiko | Eros low Cimbebas The above table (The_Kiosk) contains academic records of students at ABC college in Windhoek. The principal of ABC college has asked you to create a database that can store all the students records as shown in table. The database should support transactions such as adding, removing and updating of student records To realize the above task, you are required to do the following i Normalize the The_Kiosk to Third Normal Form (3NF). [14 marks) ii. In each Normal Form presented indicate using an example the anomalies that need to be eliminated 16 marks] Lab Tutorial 7: MySQL Implementation. This tutorial is based on Lab Tutorial 6 that we did previously. To successfully complete this Lab Tutorial, you are required to write SQL queries in MySQL to realize the following: i. Implement the "The final tables" you obtained in Lab Tutorial 6(i). [6 marks i. Populate the tables with records as shown in The_Kiosk table (Lab Tutorial 6) 16 marks! iii. Display all the records in tables. [2 marks] iv. Update InstructorLocation for Van Dyk Katutura [6 marks] Note: Please note that you are required to print screen" both your SQL queries and output screen, and paste them onto your MS Word document for submission into elearning