Apply and illustrate the process of normalizing the data shown in this table 1 to first...

Transcribed Image Text:

Apply and illustrate the process of normalizing the data shown in this table 1 to first normal form (1NF), Second Normal Form(2NF) and third normal form (3NF). Student # 1022 4123 Studen Phone number t Name Abdulla 0564789,05589 Hamadi 63 0114587,06589 Alya Alsuwai 4 di Advisor # 10 12 Advis or Susan Jones Anne Smith Adv- Roo m 412 216 Class Class Class 2 1 3 101- 07 101- 07 143- 01 159- 02 159- 02 214- 01 Apply and illustrate the process of normalizing the data shown in this table 1 to first normal form (1NF), Second Normal Form(2NF) and third normal form (3NF). Student # 1022 4123 Studen Phone number t Name Abdulla 0564789,05589 Hamadi 63 0114587,06589 Alya Alsuwai 4 di Advisor # 10 12 Advis or Susan Jones Anne Smith Adv- Roo m 412 216 Class Class Class 2 1 3 101- 07 101- 07 143- 01 159- 02 159- 02 214- 01

Answer rating: 100% (QA)

1NF First Normal Form Rules Each table cell should contain a sing... View the full answer