Question: please help answer my homework Question (DATABASE) : 1. please create and draw the correct normalization from 1NF,2NF,3NF based on below Details : - Employee:
please help answer my homework
Question (DATABASE) : 1. please create and draw the correct normalization from 1NF,2NF,3NF based on below
Details : - Employee: employee code, employee name, phone number, and position. - Customer: customer code, full name, POB, DOB, gender, address, email, phone number.
- Menu: consists of menu code, name of the food menu, food category, a regional specialty, price, menu image (one menu can have many pictures), the number of portions available per day. - Restaurant Branch: Branch code, branch name, address, city, phone number, email.
Purchase receipt form example :

Andrew Restaurant - California 832 Coffee Road, Phone (800) 477-1477, Whatsapp: 818-971-2154 Transaction Code : 202101233 Date : 6 June 2015 15:00 Kd - Customer : 001 - Daniel, Phone: 619-637-6xxx Payment Type : Cash/e-payment Cashier CSR6942-Robert Kd Menu Menu Price(S) Qty Discount(s) Total (S) 17 Chicken 5 2 2 2 10 25 Egg 3 2 6 2 2 1 2 35 Lasagna 8 8 1 8 42 Spaghetti 7 2 14 2 38 Discount 2 Total 36 Andrew Restaurant - California 832 Coffee Road, Phone (800) 477-1477, Whatsapp: 818-971-2154 Transaction Code : 202101233 Date : 6 June 2015 15:00 Kd - Customer : 001 - Daniel, Phone: 619-637-6xxx Payment Type : Cash/e-payment Cashier CSR6942-Robert Kd Menu Menu Price(S) Qty Discount(s) Total (S) 17 Chicken 5 2 2 2 10 25 Egg 3 2 6 2 2 1 2 35 Lasagna 8 8 1 8 42 Spaghetti 7 2 14 2 38 Discount 2 Total 36
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
