Normalize the following table up to Third Normal Form (3NF)

Practical Activity #1 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
 

Transcribed Image Text:

StudentID Student 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 ProfID ProfFirst ProfLast Department Major1 AKZ Akram Aziz Computer Science Programming Programming Accounting DOM Donnell Meaders Business JJJ James Justus Technology Auto Technology Welding Major2 Web Development StudentID Student 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 ProfID ProfFirst ProfLast Department Major1 AKZ Akram Aziz Computer Science Programming Programming Accounting DOM Donnell Meaders Business JJJ James Justus Technology Auto Technology Welding Major2 Web Development

Answer rating: 100% (QA)

Practical Activity 1 1NF First Normal Form Criteria Each table cell should contain a single value atomic Each row in the table should be uniquely iden... View the full answer