Assume you are a database developer for a company. You were asked to design a database for a restaurant. The restaurant currently using a manual system and the owner of the restaurant presented you...

- The restaurant has two waiters (named John and Ali) taking order and collect payment from the customer. The customer can choose to pay using cash, Touch’n Go or credit card. The customer detail in the receipt is optional. Base on the given information above, draw a complete Entity-Relationship Diagram (ERD) with Crow’s Foot notation. Write all appropriate attributes, connectivity and cardinalities in the ERD.

Extracted text: Assume you are a database developer for a company. You were asked to design a database for a restaurant. The restaurant currently using a manual system and the owner of the restaurant presented you the following document. Figure 2: Restaurant layout, menu and receipt Menu Table layout in the restaurant NO FOOD SIZE PRICE TO5 (RM) 3/5 T01 1 Nasi lemak Small / Big (Egg, rice, kang kung) Roti Canai 2 Standard 1.5 4/5 T02 3 Mee goreng Small / T06 Big Small / 4 Nasi goreng 5/6 Big тоз T07 NO DRINK ΤΥΡΕ PRICE (RM) 1.5/2 Hot / Cold Hot / Cold Hot / Cold 1 Teh O Kopi O Sky juice 2 1.5 / 2 TO8 3 1/1.2 T04 Sample receipt: Receipt No: 1029 Time: 2:15pm Staff name: John Date: 22/10/21 Table No: TO1 Customer Detail: David 1. Nasi goreng (small) x 2 2 Roti Canai x3 3. мее дoreng (big) 4.5 Total: 15.5