Question

. Normalize the following table up to Third Normal Form (3NF). StudentID Student ProfID ProfFirst ProfLast Department Major1 003-112-224 Alexia Carnell 013-112-229 Savanna Sanderlin 009-112-227 Buddy Pothier 012-111-228 Verline Papadopoulos 002-111-223 Buddy Pothier Practical Activity #1 Major2 AKZ Akram Aziz Computer Science Programming Web Development DOM Donnell Meaders Business Programming Accounting JJJ James Justus Technology Auto Technology Welding Specify the criteria for 1NF, 2NF and 3NF Practical Activity #2 Apply the criteria and Normalize the above table into 1NF Practical Activity #3 Apply the criteria and Normalize the above table into 2NF Practical Activity #4 Apply the criteria and Normalize the above table into 3NF - Explain each step clearly. - State any assumptions. If new tables created (during the process) show the new table structure with all the relevant information gara Samarawickrama | 20235

          . Normalize the following table up to Third Normal Form (3NF).
StudentID
Student
ProfID ProfFirst ProfLast Department Major1
003-112-224 Alexia Carnell
013-112-229 Savanna Sanderlin
009-112-227 Buddy Pothier
012-111-228 Verline Papadopoulos
002-111-223 Buddy Pothier
Practical Activity #1
Major2
AKZ Akram Aziz Computer Science Programming Web Development
DOM Donnell Meaders Business Programming Accounting
JJJ James Justus Technology Auto Technology Welding
Specify the criteria for 1NF, 2NF and 3NF
Practical Activity #2
Apply the criteria and Normalize the above table into 1NF
Practical Activity #3
Apply the criteria and Normalize the above table into 2NF
Practical Activity #4
Apply the criteria and Normalize the above table into 3NF
- Explain each step clearly.
- State any assumptions.
If new tables created (during the process) show the new table structure with all the
relevant information
gara Samarawickrama | 20235

. Normalize the following table up to Third Normal Form (3NF).
StudentID
Student
ProfID ProfFirst ProfLast Department Major1
003-112-224 Alexia Carnell
013-112-229 Savanna Sanderlin
009-112-227 Buddy Pothier
012-111-228 Verline Papadopoulos
002-111-223 Buddy Pothier
Practical Activity #1
Major2
AKZ Akram Aziz Computer Science Programming Web Development
DOM Donnell Meaders Business Programming Accounting
JJJ James Justus Technology Auto Technology Welding
Specify the criteria for 1NF, 2NF and 3NF
Practical Activity #2
Apply the criteria and Normalize the above table into 1NF
Practical Activity #3
Apply the criteria and Normalize the above table into 2NF
Practical Activity #4
Apply the criteria and Normalize the above table into 3NF
- Explain each step clearly.
- State any assumptions.
If new tables created (during the process) show the new table structure with all the
relevant information
gara Samarawickrama | 20235

Added by Lisa M.

Question

Please give Ace some feedback