Normalization is a method for organizing data elements in a database into tables.

Apply the principles of full functional dependency to normalize the problem below into the 3^rd Normal form.

Before Normalization: Create a list of the the name of the attributes and their data types needed to support the invoice below, and an example of value entered for each of the listed attribute. Additional attributes besides those for the entities described on the document can be added to the database.

Example:

Column name	Data type	Sample value
Invoice number	Int	4124

Notice you dont need to create the database on the server and you dont need to use SQL to complete this homework assignment. Complete the following steps:

Tabulate your data

Identify all functional dependencies on the table (tables) before normalization.

Normalize the data into the first normal form

Identify all functional dependencies on the first normal form

Normalize the data into the second normal form

Identify all functional dependencies on the first normal form

Normalize the data into the third normal form

Your final database design should be presented as a group of tables. Each table must have a table name, clearly include the list of all attributes, a primary key clearly identified (underlined), and the data type of each attribute.