Perform Normalization on the database below, and explain (Describe the information requested in narrative form about Normalization steps you use to create an efficient and a functional database). The process must include creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.

Given a poor database design turn the unstructured data into a properly designed set of tables an data elements.

Test	Student	Date	Totalpoints	Grade	Testformat	Teacher	Assistant
Pronoun Quiz	Amy	2022-03-02	10	8	Multiple Choice	Smith	Collins
Pronoun Quiz	Jon	2022-03-02	10	6	Multiple Choice	Jones	Brown
Solids Quiz	Beth	2022-03-03	20	17	Multiple Choice	Kaplan	NULL
China Test	Karen	2022-02-04	50	45	Essay	Harris	Taylor
China Test	Alex	2022-03-04	50	38	Essay	Harris	Taylor
Grammar Test	Karen	2022-03-05	100	88	Multiple Choice, Essay	Smith	Collins