I need an explanation for this question:

Question #1

Consider the following data. Arrows show the functional dependency.

The arrows in this question indicated the determination of two attributes.

For example, the arrow that goes ProductID to ProductDescription indicates that ProductID determines the ProductDescription.

This in turn means that ProductId can be considered as primary key for ProductDescription.

a. Write the tables

b. Place the tables in 3^rd normal form (if necessary)

c. Create ERD based on the normalized tables

d. Write a script to create a database. Your script should create the tables and ensures that all constraints are set properly.

Here is some information to create your tables

Data Item (Column Name)	Type	Restriction
ProductId	Numeric Integer
ItemNum	Numeric Integer	Not null
QuantityUsed	Numeric Integer	>= 0
ItemDescription	Character Up to 200
ProductDescription	Character Up to 200
ReceiptNumber	Numeric Integer	Not null
QuantitySold	Numeric Integer	> = 0
SalesDate	Date

This is what i have so far for my table:

SalesDate(ReceiptNumber)

QuantitySold(ReceiptNumber, ProductId)

ProductDescription(ProductId)

ItemDescription(ItemNum)

QuantityUsed(ProductId,ItemNum)

I Need help understanding how to convert the table above to second and third normal form, then from there draw the ERD, and a explaination about how to convert the Table above to SQL would be apprticated.