Luxury Restaurant Sdn Bhd, was set-up in Jan 2019. The retail outlet was conveniently located in...

Transcribed Image Text:

Luxury Restaurant Sdn Bhd, was set-up in Jan 2019. The retail outlet was conveniently located in Paragon Mall, Penang to offer a complete range of local and western food. Below form shows the examples of bookings form record which requires normalization process. You as the database administrator, normalize the below information from Unnormalized Form (UNF), First Normal Form (INF), Second Normal Form (2NF) and Third Normal Form (3NF). Staff No: Staff Name: P123 Amy Customer ID: C223 Customer Name Candy Table No T11 T20 Type Birthday Wedding Booking Form Quantity 10 100 Date: 28th Dec 2018 Payment: Cash Luxury Restaurant Sdn Bhd, was set-up in Jan 2019. The retail outlet was conveniently located in Paragon Mall, Penang to offer a complete range of local and western food. Below form shows the examples of bookings form record which requires normalization process. You as the database administrator, normalize the below information from Unnormalized Form (UNF), First Normal Form (INF), Second Normal Form (2NF) and Third Normal Form (3NF). Staff No: Staff Name: P123 Amy Customer ID: C223 Customer Name Candy Table No T11 T20 Type Birthday Wedding Booking Form Quantity 10 100 Date: 28th Dec 2018 Payment: Cash

Answer rating: 100% (QA)

1 Partially dependency 1 CustomerID CustomerName StaffNo StaffName DatePa... View the full answer