In: Computer Science
This is in MySQL
Part one: Using the MySQL Workbench Data Modeler, construct a diagram that shows the table in 3rd Normal Form.
Part two: Provide a summary of the steps you took to achieve 3rd Normal form. Include your rationale for new table creation, key selection and grouping of attributes.
Table Details:
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.
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 |
PLEASE GIVE IT A THUMBS UP, I SERIOUSLY NEED ONE, IF YOU
NEED ANY MODIFICATION THEN LET ME KNOW, I WILL DO IT FOR YOU
AS I DONE MOST OF YOUR ANSWERS, THOUGH WE ARE ONLY ALLOWED TO
ATTEMPT ONE ANSWER OR FOUR SUB PARTS, PLEASE GIVE IT A THUMBS
UP
'