A relation ADDRESS is defined as follows.

c) A relation ADDRESS is defined as follows.
ADDRESS(Name, Street, City, State, Postal_code)
Where name is unique, and for any given postal code, there is just one city and state.
i) Give a set of FDs for this relation.
ii) Is ADDRESS in 3NF or 2NF? Explain why? If it is not in 3NF, normalize it into 3NF
relations.


Leave a Reply