Scenario

In this Lab, you will create an entity relationship diagram for a restaurant review website.

The major entities involved in this database design are the following.

Restaurant $-$ the eating establishment being reviewed

Administrator $-$ a person authorized to enter and update information about a restaurant such as name, address, hours of operation, etc.

Reviewer $-$ a person who write reviews of restaurants

Review $-$ the review of a restaurant

These are the business rules that apply to these entities.

Each Restaurant can be administrated by one or many Administrators; each Administrator can administer one or many Restaurants

Each Review is for one and only one Restaurant, each Restaurant can have zero or many Reviews.

Each Review is written by one and only one Reviewer; each Reviewer can write zero or many Reviews.

A table provided in the lab instructions gives detailed information about the attributes that must be stored for each entity.

Deliverables

After completing the steps below, submit a single Microsoft Word document file named LabWeek$2$xxx$.$docx $($where $x=$ your initials$).$

This file will contain two Entity Relationshin Diacrams. $($ERDs$)$ conied and nasted from Microsoft Vicio