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.
|