1. How many minimum tables required which satisfy 1NF.
2. How many minimum tables required which satisfy BCNF.
3. How many minimum tables required which satisfy 4NF.
@aehkn for 2NF and 3NF we need 2 tables right?
@aekhn
for some EID, it might be case that it has no phone no., in that case phone no. = NULL, but prime attributes should never be NULL according to entitiy intigrity constraint. so EID PolicyNo. PhNo. Email can not be primary key..
for 3 NF, 4 tables are required, one for orginal entitiy and 3 each for multivalued attribute.
@ joshi_nitish
we use multivalued attribute for 4 NF
not for 3 NF
rt?
64.3k questions
77.9k answers
244k comments
80.0k users