Normalization:

Normalization:

Represent this form in UNF. In creating your representation you should note that Super Electronics wish to treat the client name, address and phone as simple attributes. Convert your UNF to first normal form (1NF) and then continue the normalization to fourth normal form (4NF). At each normal form show the appropriate dependencies for that normal 10+5=15 9 form, if there are none write "No Dependencies". Assume that Client Address and phone number is a multivalued attribute for the client number. We will store max two address and two phone numbers for each user.

Do not add new attributes during the normalization. Clearly write the relations in each step from the unormalized form (UNF) to the fourth normal form (4NF). Clearly, indicate primary keys on all relations from 1NF onwards. Specifically find the answer to the following question. While answering these questions define all the dependencies properly. For example, if you are talking about partial dependency then explain what is a partial dependency

The Super Electronics Invoice shown below displays the details of an invoice for the client Alice Paul. Super Electronics INVOICE Client Number: Client Name: Client Address: Invoice No.: 132 Invoice Date: 02/11/2018 C3178713 Alice Paul 43 High Street, Caulfield, VIC 3162 0411 245 718 Client Phone: ItemID Item Name 316772 Sonig S55UV16B 55" 452550 Microsoft Surface Pro 483041 Delonghi Digital Coffee Purchase Expected Quantity Cost Price Delivery Date 499.00 2 weeks 1 499.00 1198.00 1-3 weeks 1 1198.00 299.00 Same Day 2 598.00 SUB TOTAL: $ 2295.00 DELIVERY: $145.00 ORDER TOTAL: $2440.00