Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Anita Wooten Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the
The Anita Wooten Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer. Using MySQL Workbench Data Modeler, create a model showing the below table in 3rd Normal Form. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies. ArtistlD PurchaseDatelCustomerName CustomerAddress CustomerPhone PurchasePrice ArtTitle ArtistName Carol Channin Dennis Frings Carol Channing Dennis Frings 3 Sep 17 2012Mark Evans 15 May 11 2013Mark Evans 3 Feb 14 2014Mark Evans 123 This Street Orlando, FL (407) 555-1212 7,000.00 Laugh with Teeth 123 This Street Orlando, FL(407) 555-1212 1,800.00 South Toward Emerald Sea 123 This Street Orlando, FL (407) 555-1212 5,550.00 At the Movies 123 This Street Orlando, FL (407) 555-1212 S2,200.00 South Toward Emerald Sea 15 Jul 15 2015 Mark Evans
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started