In: Computer Science
Demonstrate 1NF Normalization Techniques
Procedure
Bring the following table structure to first normal form and explain the errors in the current structure. Your submission can be drawn in Word or hand drawn and attached to your submission. Be sure to write out your explanation of the errors in the normal form.
Instructor Name Instructor Phone Instructor Email Course Name Course Number Course Description Student1 Name Student1 Phone Student1 Email Student1 GPA Student2 Name Student2 Phone Student2 Email Student2 GPA … Student15 Name Student15 Phone Student15 Email Student15 GPA |
University
Demonstrate 2NF Normalization Techniques
Procedure
Bring the following table structure to second normal form and explain the errors in the current structure. Your submission can be drawn in Word or hand drawn and attached to your submission. Be sure to write out your explanation of the errors in the normal form.
Course Number Course Description Course Credit Hours Student ID Student Name Student Phone Student Email Student Grade |
Courses
Procedure
Bring the following table structure to third normal form and explain the errors in the current structure. Your submission can be drawn in Word or hand drawn and attached to your submission. Be sure to write out your explanation of the errors in the normal form.
Instructor Name Instructor Phone Instructor Email Course Name Course Number Course Description Student1 Name Student1 Contact Info Student1 Major Student1 GPA Student2 Name Student2 Contact Info Student2 Major Student2 GPA … Student15 Name Student15 Contact Info Student15 Major Student15 GPA |