Lab Tutorial 6: Normalization. The_Kiosk StudentName CourseName Intro. Maths Basic English Major CourseNo N4001 N4550 InstructorNo...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these databases questions
-
This information requires you to create a process diagram (in swim lane format) for a Coffee Caf. The assignment is based on the simple concept of ordering, making, and providing Coffee or Tea in a...
-
The payroll clerk at Photo Workshop has asked you to create an application that displays an employees net pay. The application should allow the payroll clerk to enter the employees name, hours...
-
1. Dr. Jones has asked you to create a monthly Claim Status Summary report. He wants you to include the insurance company number, the patient number and name, the procedure date, the procedure code...
-
write a note on Moll Cutpurse Life?
-
What are some of the additional variables used for profiling the clusters?
-
The operations team at TelStar Motor Company also presented their major issues on your last visit. They feel that the executive management team ignored the company's science related to emission...
-
Susan Henderson, the vice president of marketing, was told by the CEO that she needs to understand the numbers because the company's existence depends on making money. It has been a long time since...
-
There is only one copying machine in the student lounge of the business school. Students arrive at the rate of = 40 per hour (according to a Poisson distribution). Copying takes an average, of 40...
-
___ Systematic Random Sampling ___ Stratified Random Sampling ___ Cluster Random Sampling ___ Simple Random Sampling ___ Probability Sampling Methods 1. Each member of the population has an equal...
-
A textile company produces shirts and pants. Each shirt requires two square yards of cloth, and each pair of pants requires three square yards of cloth. During the next two months the following...
-
Suppose the GPA for all students in this school follows a normal distribution with mean 3.15 and standard deviation 0.3. Pick three students randomly. The probability that the GPA for each of them is...
-
What is operational site activation and what is its scope?
-
What is a sensitivity analysis?
-
What are the basic modeling elements for a mechanical system? Explain the function of each element.
-
What is resistance?
-
For purposes of tests of controls, what is a deviation?
-
Which objectives are achieved through the use of transfer prices? B) Explain why companies would want to use transfer prices to achieve these objectives. 1. Explain the various types of intercompany...
-
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
-
Construct and graph a primal problem with two decision variables and two functional constraints that has feasible solutions and an unbounded objective function. Then construct the dual problem and...
-
A stockbroker, Richard Smith, has just received a call from his most important client, Ann Hardy. Ann has $50,000 to invest and wants to use it to purchase two stocks. Stock 1 is a solid blue-chip...
-
The Centerville Water Department provides water for the entire town and outlying areas. The number of acre-feet of water consumed in each of the four seasons of the three preceding years is shown...
-
Use the information for Hamlet House in Exercise E9-15 and assume a tax rate for the company of 35 percent. a. If Hamlet House wants to earn an after-tax profit of \(\$ 182,000\), how many garden...
-
Use the information for Austin Automotive in Exercise E9-16 and assume a tax rate for the company of 30 percent. a. If Austin Automotive wants to earn an after-tax profit of \(\$ 135,800\), how many...
-
In a risk management program, the unit of analysis is: a. The exposure on which the audit team is focusing b. The business process or function to be audited c. The weighting assigned to a generic...
Study smarter with the SolutionInn App