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
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.
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