Given the Student Information Table below, perform the following steps:

1. Identifies an example of each of the update anomalies and complete the table entries (15 points)
2. Identify all functional dependencies? (15 points)

Using the format, AàB when A determines B.

• Make sure to underline the primary keys in each table you create.

3. 1 NF: (10 points)
   1. Write the rule(s) for First Normal form then
   2. Create tables as needed (in MS words similar to the table you see at the bottom of this document- but after applying normalization).
   3. Normalize the table into the first normal form?
   4. Show the new table/tables after normalizing to the first normal form.
   5. Underline the key(s) used in each table after normalizing to the first normal form.
4. 2NF: (10 points)
   1. Write the rule(s) for Second Normal form then
   2. Normalize the result from the previous step into the second Normal form?
   3. Show the table/tables after normalizing to the second normal form.
   4. Underline the key(s) used in each table after normalizing into the second normal form.
5. 3NF: (10 points)
   1. Write the rule(s) for Third Normal form then
   2. Normalize the result from the previous step into the third normal form.
   3. Show the table/tables after normalizing to the 3^rd normal form.
   4. Identify the key(s) used in each table after normalizing to the third normal form. 

Transcribed Image Text:

Studen t# 12345 walter@cs.com 12550 Insert. yoursel f as studen t in this table 18255 email 7211 carltonM@college. edu James@university. edu Thomas@company .com Stude Stude nt nt Name City Jim Walte Tulsa OK r Mary Carlto Dallas TX n James Broke Carlto n Arrow n Stat e Tim Thom as Little Rock OK AR Zip Cod e Adv Adv ID 7411 123 8 A 6532 123 1 B 7222 7 7401 123 3 B 147 Name Smith Smith Hamilt Grad Grad James 555 A C on Adv Roo Class Class er m 1 2 e 467 B 467 B e 301 C A B Semest Yea r Fall Spring Fall 21 20 20 Spring 21 Class 1 CS 2014: Intro to C++ CS 4343: Databa Math 2021: College Algebr a Class 2: add informati System on here se S Math 2021 College algebra add informati on here add informati Engl. on here add informati on here add informati on here Class 3 add informati on here Math3211 : College Algebra 1212: Intro to Compositi on Psycholog y 3113: Child developm ent Studen t# 12345 walter@cs.com 12550 Insert. yoursel f as studen t in this table 18255 email 7211 carltonM@college. edu James@university. edu Thomas@company .com Stude Stude nt nt Name City Jim Walte Tulsa OK r Mary Carlto Dallas TX n James Broke Carlto n Arrow n Stat e Tim Thom as Little Rock OK AR Zip Cod e Adv Adv ID 7411 123 8 A 6532 123 1 B 7222 7 7401 123 3 B 147 Name Smith Smith Hamilt Grad Grad James 555 A C on Adv Roo Class Class er m 1 2 e 467 B 467 B e 301 C A B Semest Yea r Fall Spring Fall 21 20 20 Spring 21 Class 1 CS 2014: Intro to C++ CS 4343: Databa Math 2021: College Algebr a Class 2: add informati System on here se S Math 2021 College algebra add informati on here add informati Engl. on here add informati on here add informati on here Class 3 add informati on here Math3211 : College Algebra 1212: Intro to Compositi on Psycholog y 3113: Child developm ent