# Database: Relational Schema Exercise - Restaurant Comment

Name: _________________________________

## Restaurants Database

You're building a database of restaurants. Each row of the Restaurant table is a description of a single restaurant, with a primary key of rest_id. A second table has anonymous user comments about restaurants.

### Assumptions

- The primary key of each table is in bold
- There may be more than one comment about a given restaurant.
- There may be no comments about a restaurant.
- Each comment is about one restaurant.

### Incomplete Schema

Restaurant

rest_id
rest_name
rest_location
rest_phone
rest_description
?__________

Comment

comment_id
comment_date
comment_text
?____________

## Questions

1. (2 points) There must be some kind of key information that associates restaurants and comments. Which of these is the correct way to make this association?
   1. Add a foreign key, rest_id, to the Comment table.
   2. Add a foreign key, comment_id, to the Restaurant table.
   3. Both A and B above.
2. (2 points) Fill in the missing key(s) you chose in the previous question. Draw a line connecting the two tables indicating the cardinality/multiplicity of the relationship using Crow's foot notation.