Art Exchange operates an art exchange program that allows paintings to be moved
ID: 3908963 • Letter: A
Question
Art Exchange operates an art exchange program that allows paintings to be moved around through private collections. Art Exchange wishes to use a relational database to record information about which painting is being held in which. Study the data in the table below:
55(a) Using only the attributes in this table, what would be a suitable primary key? [2 marks] ___________________________________________________________________________ __________________________________________________________________________
55(b) Make a list of all the issues you see in the table [4 marks] __________________________________________________________________________ __________________________________________________________________________ __________________________________________________________________________ __________________________________________________________________________ __________________________________________________________________________ __________________________________________________________________________
55(b) Explain what you would do to improve the quality of the data stored by Art Exchange in this database [4 marks] __________________________________________________________________________ __________________________________________________________________________ ______________________________________________________________________
PaintingN ame Painti Descri PaintingValu CollectorlD CollectorNameCollectorLocation CollectStart CollectEnd Artist iemba Djaru Tears of Jiemba Djaru Tears of Joy Oil on Canvas Xihua Gu Jiemba Oil on Canvas $7500 M23 Rolande Yisman Canberra, ACT 15/07/2001 29/08/2015 Rolande Yisman Canberra, ACT 15/02/2009 Jayesh Malhotra Sydney, NSW 10/05/2012 30/01/2014 ne Green Brisbane, QLD Orchid Night Watercolour Dream Watcher Oil on Canvas $5,230 M23 $3,000 M26 $9,000 J03 Melbourne, VIC 1/10/2002Explanation / Answer
Answers)
55(a) Using only the attributes in this table, what would be a suitable primary key? [2 marks]
Answer)
PaintingName, CollectorID is the primary key which would be unique in the table.
55(b) Make a list of all the issues you see in the table [4 marks]
Answer)
The issues in the table are:
a) There is no primary key column for the Art Exchange
b) For CollectEnd, it should not be left blank, should be null in case there is not end date
55(b) Explain what you would do to improve the quality of the data stored by Art Exchange in this database [4 marks]
Answer)
To improve the quality of the data stored by Art Exchange in this database:
a) Add a primary key column for the exchange table in the table such as ExchangeID
b) Make the CollectEnd date as null, when there is no end date.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.