Database System Questions It should be noted that in these questions they are related to each other.

1. As a continuation of the AllTaste Restaurant database design stage, some entity information and documents are known as follows:
   • Food Menu: food menu code, food menu name, food category, regional specialty, price, menu image (one menu can have many pictures), number of portions available per day.
   • Customer: customer code, customer's full name, place of birth, date of birth, gender, address, email, phone number, WA number.
   • Employee: employee code, employee name, phone number, position.
   • RM Branch: Branch code, branch name, address, city, phone number, WA number, email.
   • An example of a purchase receipt form as follows:

From the information above, do the normalization steps from 1NF, 2NF, 3NF, to BCNF.

2. Draw ERD from the table of results of the normalization steps in question number ERD is completed with all the attributes of each entity, PK, FK, multiplicity (participation and cardinality).

3. Create an enhanced entity-relationship with ERD from question number 3, complete with participation and disjoint constraints.

P.S:

- Please answer in a proper format - Please answer in a typed or softcopy format - Please don't do it with pen or pencil, do it with software or tools - If you want to ask any question, ask it in the comment section, I will try to answer it

Thanks!

AllTaste Restaurant - South Jakarta Branch Address: Jl. Raya Rasa No.20 Jakarta Selatan, Phone: 021-59983744, WhatsApp: 08123456789 Transaction Code : 202012120 Date : 11 Nov 2020 12:00 Code - Customer : 100 - Andy, Phone number: 082123456789 Payment Type : Cash/e-payment Cashier : KSR1905 - Julia Menu Code 77 65 25 Menu Grilled Chicken Satay Tongkol Asam Padeh Sayur Lodeh Price 15000 13000 12000 10000 Quantity Discount Total (Rupiah) 2 2500 30000 2 26000 1 12000 2 20000 2500 88000 12 Discount Total Pay 2500 85500 AllTaste Restaurant - South Jakarta Branch Address: Jl. Raya Rasa No.20 Jakarta Selatan, Phone: 021-59983744, WhatsApp: 08123456789 Transaction Code : 202012120 Date : 11 Nov 2020 12:00 Code - Customer : 100 - Andy, Phone number: 082123456789 Payment Type : Cash/e-payment Cashier : KSR1905 - Julia Menu Code 77 65 25 Menu Grilled Chicken Satay Tongkol Asam Padeh Sayur Lodeh Price 15000 13000 12000 10000 Quantity Discount Total (Rupiah) 2 2500 30000 2 26000 1 12000 2 20000 2500 88000 12 Discount Total Pay 2500 85500