A company purchase parts from vendors that are used by employees to assemble machines Customers purchase the as diftrent machines Each employee only works on the assembly of one machine. However, many employees work on assembling the same ma parts are used by the different machines; these parts are identified by color sembled machines, Customers purchase many Given attributes: va, vname, vstate, price, p4, pname, pcolor, mg , mname, mweight. e#, ename, qty, c # cname, cadd Given dependencies: cs determines c, cname, cadd c#. m" determines c#, m#. qty pt, price me determines ma, mname, mweight R make certain to use the appropriate conventions and underline key attributes (points will be taken off. Make certain you lidentify EACH section or you will lose points if I cannot identify the step. Submit all of your answers including the diagrams in ONE Word or pdf document. Section 1: Write a 1NF table: be certain to underline the key attributes (10 points). Section 2: Create 2NF tables (5 points) Section 3: Create 3NF tables (S points, identify whether the table is E for entity or R for composite relationship and name the tables (5 points) Section 4 Draw an E/R Dlagram showing all ardinality 10 points for the ER dagram and 5 point fr Cardinalityil You do NOT have to do the degee of cardinality. Your final diagram should have 1:m relationships ONLY Section 5: Draw a Relational Schema (10 points)