DATABASE SYSTEMS AllTaste Restaurant database design: some entity information and documents are known as follows: Food Menu: food menu code, food menu name, food category, regional specialty, price,...

DATABASE SYSTEMS

AllTaste Restaurant database design: 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.


• Restaurant Branch: Branch code, branch name, address, city, phone number, WA number, email.

An example of a purchase receipt form as follows (picture):

TO-DO:

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

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