Question

FSDM / CPCM - 2023S Database Design & SQL Student ID : Student Name : Practical Exercise 9_10_11_12 . Normalize the following table up to Third Normal Form (3NF). StudentID Student ProfID ProfFirst ProfLast Department Major1 Major2 003-112-224 Alexia Carnell AKZ Akram Aziz Computer Science Programming Web Development 013-112-229 Savanna Sanderlin Programming 009-112-227 Buddy Pothier DOM Donnell Meaders Business Accounting 012-111-228 Verline Papadopoulos Auto Technology 002-111-223 Buddy Pothier JJJ James Justus Technology Welding 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 PPPPPPPPPPPPPPPPPPPPPPPPPPPP - Explain each step clearly. - State any assumptions. - If new tables created (during the process) show the new table structure with all the relevant information

          FSDM / CPCM - 2023S
Database Design & SQL
Student ID :
Student Name :
Practical Exercise 9_10_11_12
. Normalize the following table up to Third Normal Form (3NF).
StudentID	Student	ProfID	ProfFirst	ProfLast	Department	Major1	Major2
003-112-224	Alexia Carnell	AKZ	Akram	Aziz	Computer Science	Programming	Web Development
013-112-229	Savanna Sanderlin				Programming	
009-112-227	Buddy Pothier	DOM	Donnell	Meaders	Business	Accounting	
012-111-228	Verline Papadopoulos				Auto Technology	
002-111-223	Buddy Pothier	JJJ	James	Justus	Technology	Welding	
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
PPPPPPPPPPPPPPPPPPPPPPPPPPPP
- Explain each step clearly.
- State any assumptions.
- If new tables created (during the process) show the new table structure with all the
relevant information

FSDM / CPCM - 2023S
Database Design SQL
Student ID :
Student Name :
Practical Exercise 9101112
. Normalize the following table up to Third Normal Form (3NF).
StudentID Student ProfID ProfFirst ProfLast Department Major1 Major2
003-112-224 Alexia Carnell AKZ Akram Aziz Computer Science Programming Web Development
013-112-229 Savanna Sanderlin Programming
009-112-227 Buddy Pothier DOM Donnell Meaders Business Accounting
012-111-228 Verline Papadopoulos Auto Technology
002-111-223 Buddy Pothier JJJ James Justus Technology Welding
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
PPPPPPPPPPPPPPPPPPPPPPPPPPPP
- Explain each step clearly.
- State any assumptions.
- If new tables created (during the process) show the new table structure with all the
relevant information

Added by Concepci-N B.

Question

Please give Ace some feedback