- 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. Assume you are a database developer for a company. You were asked to design a database for arestaurant. The restaurant currently using a manual system and the owner of the restaurant presented youthe following document.Figure 2: Restaurant layout, menu and receiptMenuTable layout in the restaurantNOFOODSIZEPRICETO5(RM)3/5T011Nasi lemakSmall /Big(Egg, rice,kang kung)Roti Canai2Standard1.54/5T023Mee gorengSmall /T06BigSmall /4Nasi goreng5/6BigтозT07NODRINKΤΥΡΕPRICE(RM)1.5/2Hot / ColdHot / ColdHot / Cold1Teh OKopi OSky juice21.5 / 2TO831/1.2T04Sample receipt:Receipt No: 1029Time: 2:15pmStaff name: JohnDate: 22/10/21Table No: TO1Customer Detail: David1. Nasi goreng (small) x 22 Roti Canai x33. мее дoreng (big)4.5Total:15.5

If we convert the given information into Entity Relationship Diagram, the entities present in the…

Answered: Assume you are a database developer for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

- 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.

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

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions