patternMinor
Is this normalization done right?
Viewed 0 times
thisnormalizationdoneright
Problem
In this normalization question
When we convert it into 1NF according to the given site the answer is
Is there a need to take out movie category?
Won't it cause information lose?
Also when we convert it in 2NF the table of movies doesn't contain category column.
Isn't there transitive dependency between movie name and its category?
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples
When we convert it into 1NF according to the given site the answer is
Is there a need to take out movie category?
Won't it cause information lose?
Also when we convert it in 2NF the table of movies doesn't contain category column.
Isn't there transitive dependency between movie name and its category?
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples
Solution
I believe removing the category without showing it as being moved into a "movies" reference table is an oversight.
Yes, removing that column as shown in your question does result in data loss.
Yes, removing that column as shown in your question does result in data loss.
Context
StackExchange Database Administrators Q#174498, answer score: 3
Revisions (0)
No revisions yet.