Create an ER model for a restaurant. The specifications are as follows: The customer has an id, name, address and telephone number. The customer can reserve a table before arrival. Each reservation...


Create an ER model for a restaurant. The specifications are as follows:<br>The customer has an id, name, address and telephone number. The customer can<br>reserve a table before arrival. Each reservation has a unique key and includes the date<br>and time of reservation and the number of seats. Upon arrival, the customer places an<br>order. Each order has a unique order number and includes one or more food items.<br>Each food item is distinguished by an id and has name and price. We also keep track<br>of the cashier who settle the payment with the customer before he leaves the<br>restaurant. The cashier has an id and name.<br>

Extracted text: Create an ER model for a restaurant. The specifications are as follows: The customer has an id, name, address and telephone number. The customer can reserve a table before arrival. Each reservation has a unique key and includes the date and time of reservation and the number of seats. Upon arrival, the customer places an order. Each order has a unique order number and includes one or more food items. Each food item is distinguished by an id and has name and price. We also keep track of the cashier who settle the payment with the customer before he leaves the restaurant. The cashier has an id and name.

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here