JFD Art - 1 - Introduction

John Dean has asked you to create a catalogue for his art gallery

Before you go any further you must have done Task 2 of Relational Database Design Ask your teacher if you should do JFD Art by yourself or with a partner

Introduction

John currently stores information on his paintings on small cards.  This causes several problems.

• They are difficult to update
• John has up to 50 paintings at anyone time - searching for paintings can take a long time

John wants you to set up a database so that he can

• print out lists of paintings in order - from most to least expensive, by year
• print out specialist lists to send to customers: some customers collect watercolors, others prefer oil-paintings, some prefer sketches
• find out the value of all his current stock