Access Tables

Painting Database

An artist would like to hire the CIS110 Database Design Company to design and create a database to keep track of her artwork. She needs to keep track of both her customers and her inventory (paintings).

These are her customers, their addresses and phone numbers:

  • Elizabeth Walsh  1234 Fen View       Elgin, IL 60123         (847) 123-4567
  • Bob Roberts      765 Coyote Drive   Geneva, IL 60134       (630) 232-0123
  • Sam Stone        987 Rock Road      St. Charles, IL 60174  (630) 576-9876
  • Amy French       111 Winding Trail    Elgin, IL 60123         (847) 931-9999
  • John Jones         333 Ocean View      Lakes, WI 54138       (715) 987-6543
  • Suzy Snowflake   24 Winter Road      Nippy, WI 56789       (414) 123-4321

* hint: Use an input mask for the phone number

These are her current paintings
(make sure you build the tables to make future expansion possible):

  • Winter Wonderland    pastel         14 x 23    $240
  • Pecatonica River         pastel          24 x 48   $480
  • Seahorses                watercolor   14 x 28    $320
  • Coneflowers              pastel         16 x 20     $340
  • Prairie View               pastel         16 x 20     $450
  • Lady Slippers              pastel        14 x 20    $380
  • October Moon             watercolor   20 x 24     $480
  • First Frost                  watercolor   18 x 24     $250
  • Clown Fish                 watercolor   20 x 24     $280
  • Kitchen Still Life         pastel         24 x 36     $590
  • Still Life with Flowers  pastel         18 x 20     $270

*Hint: Use the lookup wizard to create a menu for the media field.

  • Suzy bought Winter Wonderland and First Frost.
  • Bob bought Pecatonica River.
  • Sam bought October Moon.
  • Amy bought Still Life with Flowers.
  • Elizabeth bought lady Slippers and Prairie View.
  • John bought Clown Fish and Seahorses.

As the artist’s representative, Lynne Mayer is available for questions.  For example, you may want to know whether pastels and watercolors are the only media the artist uses.

 

lmayer@elgin.edu