NEED TO USE ERDPLUS

Consider the universal relation schema Parts with the given functional dependencies PARTS P# P-name P.weight Color S name S location Quantity Ship.method Where = supplier nuinber P-weight part's weight S-location supplier location Ship-method method of shipment P# = part nuinber P-narne = part name S-name = supplier name Quantity quaty in a given shipment Color = part's color (a multivalued attribute since each part comes in several colors) a. Step-by-step normalize this relation to 3NF. First, show the normalization to 1NF, then to 2NF, and finally to 3NF. Underline primary key of every relation and nclude functional dependencies. (Provide solution on the next page.) b. Use ERDPlus to prepare the final database schema for the PARTS database with all relations in 3NF. Indicate primary keys, foreig keys, and referential integrity constraints. (Append the image of the schema to this assignment.) Normalization of Parts to 1NF: Normalization of Parts to 2NF (include all relations) Normalization of Parts to 3NF (include all relations) Consider the universal relation schema Parts with the given functional dependencies PARTS P# P-name P.weight Color S name S location Quantity Ship.method Where = supplier nuinber P-weight part's weight S-location supplier location Ship-method method of shipment P# = part nuinber P-narne = part name S-name = supplier name Quantity quaty in a given shipment Color = part's color (a multivalued attribute since each part comes in several colors) a. Step-by-step normalize this relation to 3NF. First, show the normalization to 1NF, then to 2NF, and finally to 3NF. Underline primary key of every relation and nclude functional dependencies. (Provide solution on the next page.) b. Use ERDPlus to prepare the final database schema for the PARTS database with all relations in 3NF. Indicate primary keys, foreig keys, and referential integrity constraints. (Append the image of the schema to this assignment.) Normalization of Parts to 1NF: Normalization of Parts to 2NF (include all relations) Normalization of Parts to 3NF (include all relations)