Question $1[10$ Marks$]$: Perform a decomposition of the table below to form a normalized schema of tables that yields limited redundancy. Document your schema design by describing the contents of each table, what the primary key is $($creating any surrogate keys as necessary$)$ and the relationships $($foreign keys$)$ to other tables in your schema. Include all the steps, $1$NF$,2$NF and $3$NF in your solution.

Question $2[10$ Marks$]$:

Write the SQL commands to physically create the different tables.

Make sure to include all constraints $($PK$,$ FK$,$ NOT NULL, $...)$

Add more fields to make your tables closer to a real$-$world application.

Problem Statement:

The company Business Inc, has a number of invoices for several customers.

Business Inc. wants to migrate from the flat file DB to a relational database.

The company has collected details about her invoices as follows:

$-$ Inv.no: Invoice Number

$-$ Date: Invoice Date

$-$ Customer: the customer name

$-$ Cust. no: the customer Number in her system

$-$ Address: the customer's address

$-$ Inv.item.no: the invoice item number

$-$ Product: the product name

$-$ Prod.no: the product number in her system

$-$ No: the quantity purchased

$-$ Price: The unit price of each product.

Please note that every invoice is relative to only one customer. Many products can be

purchased within the same invoice.