Question: please answer my homework Question (DATABASE) : 1. please create and draw the normalization from 1NF,2NF,3NF based on below 2. please create and draw ERD
please answer my homework
Question (DATABASE) : 1. please create and draw the normalization from 1NF,2NF,3NF based on below 2. please create and draw ERD from 3NF results in number 1. ERD must-have attributes of each entity, PK, FK, and multiplicity(participation and cardinality)
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
