This is in MySQL

Part one: Using the MySQL Workbench Data Modeler, construct adiagram that shows the table in 3rd Normal Form.

Part two: Provide a summary of the steps you took to achieve 3rdNormal form. Include your rationale for new table creation, keyselection and grouping of attributes.

Table Details:

The Anita Wooten Art Gallery wishes to maintain data on theircustomers, artists and paintings. They may have several paintingsby each artist in the gallery at one time. Paintings may be boughtand sold several times. In other words, the gallery may sell apainting, then buy it back at a later date and sell it to anothercustomer. Using MySQL Workbench Data Modeler, create a modelshowing the below table in 3rd Normal Form. Note that you only canmodel table and column names and data types. The data shown is foryour reference to determine functional, partial, and transitivedependencies.

ArtistName	ArtistID	PurchaseDate	CustomerName	CustomerAddress	CustomerPhone	PurchasePrice	ArtTitle
Carol Channing	3	Sep 17 2012	Mark Evans	123 This Street Orlando, FL	(407) 555-1212	$         7,000.00	Laugh with Teeth
Dennis Frings	15	May 11 2013	Mark Evans	123 This Street Orlando, FL	(407) 555-1212	$         1,800.00	South Toward Emerald Sea
Carol Channing	3	Feb 14 2014	Mark Evans	123 This Street Orlando, FL	(407) 555-1212	$         5,550.00	At the Movies
Dennis Frings	15	Jul 15 2015	Mark Evans	123 This Street Orlando, FL	(407) 555-1212	$         2,200.00	South Toward Emerald Sea