Dine At Home provides home delivery of meals ordered from various local restaurants. You are the...

Transcribed Image Text:

Dine At Home provides home delivery of meals ordered from various local restaurants. You are the liaison between the company's information technology group and the accounting group. You are asked to explain the relationship among these tables to the accounting group. The tables are from the Dine At Home database. Restaurant RestaurantNumber RestaurantName Street City State Zip OwnerFirstName OwnerLastName Phone Website Order OrderNumber RestaurantNumber OrderDate OrderAmount CustomerID Customer1 CustomerID FirstName LastName Phone Site Address City State ZipCode (a) Identify the primary and foreign keys for each table. (Enter answers in alphabetical order.) Table Primary Key Restaurant RestaurantNumber Order Customer1 Foreign Key OwnerFirstName Dine At Home provides home delivery of meals ordered from various local restaurants. You are the liaison between the company's information technology group and the accounting group. You are asked to explain the relationship among these tables to the accounting group. The tables are from the Dine At Home database. Restaurant RestaurantNumber RestaurantName Street City State Zip OwnerFirstName OwnerLastName Phone Website Order OrderNumber RestaurantNumber OrderDate OrderAmount CustomerID Customer1 CustomerID FirstName LastName Phone Site Address City State ZipCode (a) Identify the primary and foreign keys for each table. (Enter answers in alphabetical order.) Table Primary Key Restaurant RestaurantNumber Order Customer1 Foreign Key OwnerFirstName