This project simulates a hardware store's database, used to keep track of all the items sold.

Study the following invoice:

Customer ZZZ:

User $IDMA$

Password :$40$

Name & Surname : Mary Williams

Phone Number : $01023465782$

E$-$Mail Address :

mwilliams@yahoo.com

Item ID:

Product Name:

Price:

Date:

$1$

Door Knob

R$128\mathrm{.}00$

$2020-06-10$

$2$

Sliding Door Lock

R$1290\mathrm{.}00$

$2020-07-17$

$3$

Door Chain Lock

R$286\mathrm{.}00$

$2020-07-20$

Total Items

:$3$

Total Products

:$3$

Figure $1$: Customer InvoiceYou are required to do the following:

$1\mathrm{.}1$ List all the attributes of the invoice to create Zero Normal Form.

$1\mathrm{.}2$ Normalise the list that you created in Question $1\mathrm{.}1,$ showing each step from First Normal Form to Third Normal Form. Clearly indicate Primary and Foreign Keys.

$1\mathrm{.}3$ Draw the Entity Relationship diagram from the Third Normal Form of Question $1\mathrm{.}2.$ Use it to set up the tables in the next question.

$1\mathrm{.}4$ Write a script file that will create the database and tables that you have designed in your ER diagram. Include Primary Keys, Foreign Keys and other constraints where appropriate.

$1\mathrm{.}5$ Insert sample dat$$asinto the tables you have created. Each table should have a minimum of five rows.

$1\mathrm{.}6$ Write a view to display all the sales where the saleDate is less than today's date. The view must return the itemID, name of customer and the saleDate.

$1\mathrm{.}7$ Create a procedure that will print out a specified invoice for a customer.