Table 4-5 shows an invoice for an order. Your assignment is as follows:

A) Draw a relational schema and diagram the functional dependencies

B) in what normal form is this relation?

C) decompose invoice into a set of 3nf relations D)draw a relational schema for your 3nf relations and show your referential integrity constraints.

ABLE 4-5 Shipping Manifest Invoice No.: Shipping Address SKumar 12, R Street Pentope DEL-00037654 rderID: OD201945 OrderDate: 30/01/2015 nvoiceDate: 31/01/2015 Billing Address SKumar 12, R Street Pentope Price (S) 10 Tax (S) 13 Total ($ 11.3 Quantity Title HPX16GB PenDrive Toshibane 1TB HDD roduct ID 34768 15 24 17.4 52212 25 3.7 28.7 Total