Suppose we have a real estate listing database that deals with homes for sale. There are many relations in this database. One of them is the Houses table and its schema (including its functional dependencies) is shown in Figure 2. The Master Listing Serial number is the identifying attribute for this table. The style of the house describes how the house is built, examples of style are: split-level, two story home, etc. MLSArea describes the area where the house is located. We assume that the property tax of a house is based on the sale price. Using the knowledge about normal forms, decompose the Houses table into a set of smaller tables so there are no anomalies. You need to indicate which normalization you are using, and the primary keys in the resulting tables.

Houses MLSArea Price SqFt Property Tax Style fdi fd2. Figure 2: A schema and functional dependencies for Houses