Question :

1. Make normalization for Sales Invoice! (UNF, 1NF, 2NF, 3NF)

Cuppa Coffee 27 Abbey Road New York Coffee Bean Purchase Purchase ID : PU001 Purchase Date : 31 Juli 2021 Staff ID Staff Name Staff Phone : ST217 : Skolastika Gabriella : +1 -217-221 - 174 Vendor ID Vendor Name Vendor Phone : VE001 : Better Beans : +1 - 122 - 233 - 455 No 1 2 3 4 Coffee Bean ID CB001 CB002 CB003 CB004 Coffee Bean Name Robusta Arabica Excelsa Liberica Quantity (in kilogram) Coffee Bean Price (per kilogram) Total Price 3 Rp. 150.000 Rp. 450.000 2 RP. 200.000 Rp. 400.000 1 Rp. 100.000 Rp. 100.000 1 Rp. 120.000 Rp. 120.000 Total Payment Rp. 1.070.000 Signature Skolastika Gabriella (ST217)