Art Gallery Database Normalization

An art gallery wants to record data regarding its customers, artists and art projects.

The gallery may have multiple paintings of a particular artist at all times. Paintings may be sold and re-purchased more than one time by the gallery. In other words, the gallery can sell a painting and later on purchase the painting and resell it to the same or another customer.

Data:

John Doe
1 Freedom Street
Liverpool
L1 1DP
Tel: 0843 903 3249

Purchases:

Artist Project Purchase Date Price
13 John Wu 123 The Horse 12/12/2017 1000
28 Jenny Sun 222 Spring 01/03/2018 500
13 John Wu 139 Hunting 04/04/2018 3000
28 Jenny Sun 222 Spring 10/10/2018 600

Task:

  • Normalize the database up to 3NF
  • Provide the logical entity relationship (ER) diagram for the relational database.
  • Provide a potential alternative solution for a non-relational database using denormalization. Justify the approach.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.