Assignment G (Restaurant Reviews)

Solution G:

RESTAURANT(Restaurant-Name,Phone-Number,Number-of-Locations,Town,Number-of-Tables,Head-Chef,Specialities,Nearest-T-Stop)

TESTMEAL(Meal-Number,Date-Tried-Location-Address)

REVIEWER(Reviewer-Name,Reviewer-Phone-Number,Quality-Rating,Review-Comments,Food-Ordered,Time-of-Reservation,Time-Meal-Served,Time-Seated,Price-Range-High,Price-Range-Low,Number-of-Specials,Count-of-Items-on-Menu)

Relationships

Conducts REVIEWER 1:1 TESTMEAL

Sample REVIEWER M:M RESTAURANT

Based on your finished Assignment G (Restaurant Reviews) 3rd Normal Form logical data model (LDM), create the Relational Physical Data Model (RPDM) that implements your solution. Submit BOTH your finished LDM and the RPDM you derive from it.

Identify all foreign keys by marking them clearly ("(FK)").

Note that your creating the RPDM must not change your LDM [unless reading back your RPDM lets you discover errors that were in your LDM (requiring you to fix the LDM)]. The RPDM you submit must be directly derived from the 3NF LDM.

Note that a RPDM does not contain any relationship statements. The RPDM contains only Table definitions. Any relns from the LDM must be implementing in the RPDM using Foreign Keys (FK).

Be sure to check that your finished RPDM satisfies all of the original fact statements from the LDM assignment. If it does not, that suggests that either your LDM to RPDM conversion was incorrect or there is a flaw in the LDM (if so, fix that flaw now).

Conducts REVIEWER