The Customers relation scheme attributes are:
- Customer first name, a person's first name.
- Customer last name, a person's last name.
- Customer phone, a valid telephone number.
- Customer street, a street address.
- Customer zip code, a zip code designated by the United States Postal Service.
The primary key attributes of the Customers relation are the
first name, last name, and phone.
The Orders relation scheme attributes are:
- Customer first name, foreign key from Customers.
- Customer last name, foreign key from Customers.
- Customer phone, foreign key from Customers.
- Order date, a calendar date possibly with the clock time.
- Sold by, the first name of the sales person taking the order.
The primary key attributes of the Orders relation are the three foreign key
attributes plus the order date.
Return to main page