# Database: Relational Schema Exercise - Restaurant Comment Person

Name: _________________________________

(5 points) Restaurant Database Extended - Your restaurant database has been a big success, but anonymous comments allowed too many irresponsible responses. To give accountability, you decide to add a third table, Person. This has a person's email address (assume this is unique) and password in it. The email address is known to be valid because your program will send the password by email to that address.

### 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.
- A person may make more than one comment.
- A person can comment more than once on the same restaurant.

### The problem

The tables below don't have enough information to link a person with a comment about a restaurant.

1. Fill in the missing field(s) indicated in the diagram with "?". You don't have to fill in all the fields -- only those necessary to make the relationships work.
2. Draw lines connecting the tables indicating the cardinality/multiplicity of the relationships. Use crow's foot notation

Restaurant

rest_id
rest_name
rest_location
rest_phone
rest_description
?_______________
?_______________

Comment

comment_id
comment_date
comment_text
?_______________
?_______________

Person

person_email
person_pw
?_______________
?_______________