The Contact relation scheme attributes are:

The primary key attributes of the Contact relation are first name, last name, and street. These attributes, together, functionally determine the other three attributes in the relation. The zip code attribute, not a part of the primary key, functionally determines the city and state, and is therefore a subkey of the relation.

Return to main page