Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5 The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the
5 The Gill 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 later and sell it to another customer. Customer ID Customer Name Phone Address Gill Art Gallery Customer History Form :C26 : Elizabeth Jackson : (206) 284-6783 : 123-4th Avenue Fonthill, Perth Australia. Purchases Details: Artist ID Artist Name Art Code Art Title Purchase Date Sales Price 03 Carol Chan 0301 Sunset 17 Dec 2000 7000.00 15 Dennis Fred 1501 Emerald Sea 11 May 2000 1800.00 03 Carol Chan 0302 Pleasure 14 Feb 2002 5550.00 15 Dennis Fred 1501 Emerald Sea 15 Jul 2003 2200.00 a) Convert the above report into a relational schema. b) Identify appropriate primary key(s). (1 mark) (2 marks)
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