Question

Exercise 2 Based on the following table Students FirstName LastName Knowledge Thomas Mueller Java, C++, PHP Ursula Meier PHP, Java Igor Mueller C++, Java Startsituation 1. Determine the normal form of Students relation 2. Draw the result table after applying the appropriate NF

          Exercise 2
Based on the following table
Students
FirstName LastName Knowledge
Thomas Mueller Java, C++, PHP
Ursula Meier PHP, Java
Igor Mueller C++, Java
Startsituation
1. Determine the normal form of Students relation
2. Draw the result table after applying the appropriate NF

Exercise 2
Based on the following table
Students
FirstName LastName Knowledge
Thomas Mueller Java, C++, PHP
Ursula Meier PHP, Java
Igor Mueller C++, Java
Startsituation
1. Determine the normal form of Students relation
2. Draw the result table after applying the appropriate NF

Added by Charles S.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Md.Daniyal Arshad

12/01/2021

Step 1

Step 1: The given table is in the first normal form (1NF) because it contains atomic values in each cell and there are no repeating groups. Show more…

Show all steps

Thanks for your feedback!

Exercise 2 Based on the following table: Students FirstName LastName Knowledge Thomas Mueller Java, C++, PHP Ursula Meier PHP, Java Igor Mueller C++, Java Start situation: 1. Determine the normal form of the Students relation. 2. Draw the result table after applying the appropriate NF.