CSE 311- Database Management Systems

Problem 4 Consider the following schema - R \{City, Street, HouseNumber, HouseColor, CityPopulation With the following information 1. Primary Key City, Street, HouseNumber } 2. FD1 { City, Street, HouseNumber }{ HouseColor } 3. FD2 { City }{ CityPopulation } Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why or why not? How would you successively normalize it completely? Draw the resulting relations after Normalization