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