Answered: Menu Code Menu Name Price Quantity…

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

Database Systems

Here is a receipt form of a restaurant called Kiky.

Branch Code: NY-20

Branch Name: Kiky Restaurant - New York Branch #20

Transaction Code: 2018302888

Date: 13 October 2020, 09.00 AM

Customer Code: 1034

Customer Name: Robinson

Customer Phone: 192838222

Payment Mode: Cash

Cashier Code: CSR232

Cashier Name: Julia

Menu Code	Menu Name	Price	Quantity	Discount	Total
88	Chicken	$15	2	$2,5	$30
12	Salad	$13	2	-	$26
97	Spaghetti	$12	1	-	$12
45	Yoghurt	$10	2	-	$20

			Total:	$2,5	$88
				Discount:	$2,5
				Total Purchase:	$85,5

From information above, please do Normalization: 1NF, 2NF, and 3NF.

Expert Solution

Step by step

Solved in 4 steps

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