A particular database is normalized to satisfy a particular level of normalization (either 1NF or 2NF or 3NF). One of the tables contains, among other fields, a column for the City and a column for the Zip Code. Assuming that there is a many-to-one mapping between the set of Zip Code(s) and City, we may conclude that the database is definitely NOT in xNF form. What is the integer x (1, 2, or 3)?
@Shaik Masthan Yes I also think that without the knowledge of other fields the Normal Form in this question can't be determined.
without the knowledge of other fields the Normal Form in this question can't be determined.
Right. This relation could be even in BCNF or 4NF...Nothing can be said about it. Some information is certainly missing from the Question.
64.3k questions
77.9k answers
244k comments
80.0k users