In: Computer Science
Can a table that is already in 1NF be in 2NF and 3NF without making any changes? Explain and give one specific example of such table.
Sol.
Claer Answer Is NO....
Why? First understand what is first normal form...
First normal form eliminate all multiple entries for single attributes. like one student have more than 1 contact no.
Ex.
Name | id | contact no. | state |
Rohan | 1 | 83****2772, 99**162161 | RAJ |
Aksthat | 2 | 99***72737 | U.P |
Ramesh | 3 | 98***66262 | M.P |
So, in this table we have entry anme rohan which is having multiple contact no. so thsi table is not in first normal form.
And above quetion author examiner about If a table which is already in 1NF can be in 2NF and 3NF..
let's understand when we eleminate multiple entries then relation come into 1NF and after if we want to convert this rellation in 2NF then we need to eleminate partial dependencies. And we convert into 3NF if we have relation in 2NF to convert into 3NF we need to eleminate transitive dependencies from the relation or table..
So,the map of the normal form will be .
plzz upvote..