In this normalization question

enter image description here

When we convert it into 1NF according to the given site the answer is

enter image description here

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


1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.