What would be the minimum number of tables for the given ER-Diagram such that the relational database satisfies 1NF?
The question has already been discussed in the link here but its concept is contradicting the concept explained here . So i am confused which one is right.
You can store it in 1 table with primary key(say P) + MVA(multi valued attribute) as the new primary key is MVA is having the NOT NULL constraint.
But then you will be replicating the every attribute in the tuple except for the MVA multiple times which will lead to redundancy of data but that is okay in 1NF.
This redundancy will be removed in 2NF because except for the MVA every other non key element is uniquely dependent on the initial primary key(P) which is now a proper subset of the current primary key(P + MVA). And hence that dependency will be removed.
So its not necessary to take MVA to new table if it is having NOT NULL constraint.