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


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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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