Lab Tutorial 6: Normalization. The_Kiosk StudentName CourseName Intro. Maths Basic English Major CourseNo N4001 N4550 InstructorNo...

  

Transcribed Image Text:

Lab Tutorial 6: Normalization. The_Kiosk StudentName CourseName Intro. Maths Basic English Major CourseNo N4001 N4550 InstructorNo InstructorName InstructorLocation Grade StudentNo. 2000 2001 2002 2003 Maths English Art Physics Van Wyk Shikongo Van Dyk Browns S201 5323 Klein Windhoek 75 James Mary Hafeni Thato Windhoek West 66 69 33 Intro. Art N3456 N2314 $433 Intro. Physic S122 Eros Cimbebasia 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). ii. In each Normal Form presented indicate using an example the anomalies that need to be eliminated. [14 marks) [6 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 (ii). ii. Populate the tables with records as shown in The_Kiosk table (Lab Tutorial 6) (6 marks] i. Display all the records in tables. iv. Update InstructorLocation for Van Dyk Katutura (6 marks) (2 marks) (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. Lab Tutorial 6: Normalization. The_Kiosk StudentName CourseName Intro. Maths Basic English Major CourseNo N4001 N4550 InstructorNo InstructorName InstructorLocation Grade StudentNo. 2000 2001 2002 2003 Maths English Art Physics Van Wyk Shikongo Van Dyk Browns S201 5323 Klein Windhoek 75 James Mary Hafeni Thato Windhoek West 66 69 33 Intro. Art N3456 N2314 $433 Intro. Physic S122 Eros Cimbebasia 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). ii. In each Normal Form presented indicate using an example the anomalies that need to be eliminated. [14 marks) [6 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 (ii). ii. Populate the tables with records as shown in The_Kiosk table (Lab Tutorial 6) (6 marks] i. Display all the records in tables. iv. Update InstructorLocation for Van Dyk Katutura (6 marks) (2 marks) (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.