The Gill Art Gallery wishes to maintain data on the sales of their paintings. Th
ID: 3882895 • Letter: T
Question
The Gill Art Gallery wishes to maintain data on the sales of their paintings. The art gallery buys and sales paintings so it is conceivable that they could sale the same painting twice. Normalize the Gill Art Gallery Sales Database as represented in sample data below.
CustName
CustPhone
ArtistId
ArtistName
ArtTitle
ArtMedium
SaleDate
SalePrice
James
206-284-6783
03
Channing
Laugh with Teeth
Oil
9/17/2020
7000.00
Greene
449-243-8765
15
Frings
South toward the Sea
Water Color
5/11/2021
1800.00
James
206-284-6783
03
Channing
At the Movies
Acrylic
4/12/2020
5550.00
Davis
515-636-9874
15
Frings
South toward the Sea
Water Color
8/11/2022
9500.00
Identify functional dependencies. {These are your business rules – in this case, you will want to make those rules by looking the data – some questions include – How will you identify customers, works of arts and their artists? - Can artists have more than one work of art? Can customers buy more than one work of art?
Normalize the listing – with just attribute names into 3NF.
CustName
CustPhone
ArtistId
ArtistName
ArtTitle
ArtMedium
SaleDate
SalePrice
James
206-284-6783
03
Channing
Laugh with Teeth
Oil
9/17/2020
7000.00
Greene
449-243-8765
15
Frings
South toward the Sea
Water Color
5/11/2021
1800.00
James
206-284-6783
03
Channing
At the Movies
Acrylic
4/12/2020
5550.00
Davis
515-636-9874
15
Frings
South toward the Sea
Water Color
8/11/2022
9500.00
Explanation / Answer
customer [ custno, cust_street, cust_city, cust_prov, cust_pstlcd, cust_phone]
3NF:
cust_art [ custno, phone number,artist_id, sale_date, price ]
art [ art_title, art_medium,artist_id(FK) ]
artist [ artist_id, artist_name ]
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.