The Contact relation scheme attributes are:

• Contact first name, a person's first name.
• Contact last name, a person's last name.
• Contact street, a street address.
• Contact zip code, foreign key from zip locations.

The primary key attributes of the Contact relation are first name, last name, and street.

The Zip Locations relation scheme attributes are:

• Zip code, a zip code designated by the United States Postal Service.
• City, a city name in the United States.
• State, a state abbreviation, external key defined by the United States Postal Service.

The primary key attribute of the Zip Locations relation is zip code.

Return to main page