Problem $1$

A company creates one or more purchase orders $("$PO$")$ for each customer, and every time a customer places an order, an invoice is generated and it's assigned a PO$.$ Each product that's ordered constitutes a line item on the invoice.

Here's a relation for tracking invoices for purchase orders $("$POID$"$ is "Purchase Order ID$")$:

PO$\_$INVICE$($ POID, CustID, CustName, ContactName, OrderDate, BillToAddress,

ShipToAddress, ProdID, ProdDescription, UnitPrice, Quantity, AmountDue$)$

And here are the functional dependcies for it:Normalize the relation above through BCNF$,$ including reference statements, using these relation names:POINVOICELINE$\_$ITEMCUSTOMERPRODUCT

Now, write a SQL script called Lastname$\_$PE$06.$sqI that creates a database called Lastname$\_$PE$06$ and then creates tables for these five relations, including primary and foreign keys. You must specify constraint names for the foreign keys.