1. List the Functional Dependencies

2. Normalize the table from 1NF to 3NF

3. Draw ER diagram of the 3NF

Question 2 Given the following relation and example data, list the functional dependencies and normalize this table into 3NF. Then use MySQL workbench to draw the ER diagram of the resulting tables. PartNumber Description Supplier Supplier Address Price 10010 20 TB Disk Seagate Cupertino, CA $100 10010 20 TB Disk IBM Armonk, NY $90 10220 256 GB RAM Card Kensington San Mateo, CA $220 10220 256 GB RAM Card IBM Armonk, NY $290 10220 256 GB RAM Card Sun Microsystems Palo Alto, CA $310 10440 21" LCD Monitor IBM Armonk, NY $2,100 Deliverables In your Word document, show the normalization steps. Then insert a screenshot of the completed ER diagrams. Submit the Word document on Blackboard. Question 2 Given the following relation and example data, list the functional dependencies and normalize this table into 3NF. Then use MySQL workbench to draw the ER diagram of the resulting tables. PartNumber Description Supplier Supplier Address Price 10010 20 TB Disk Seagate Cupertino, CA $100 10010 20 TB Disk IBM Armonk, NY $90 10220 256 GB RAM Card Kensington San Mateo, CA $220 10220 256 GB RAM Card IBM Armonk, NY $290 10220 256 GB RAM Card Sun Microsystems Palo Alto, CA $310 10440 21" LCD Monitor IBM Armonk, NY $2,100 Deliverables In your Word document, show the normalization steps. Then insert a screenshot of the completed ER diagrams. Submit the Word document on Blackboard