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 |
