Case Study: DesktopDesign Database

In "The Computer as an Expressive Medium," the relational database of DesktopDesign illustrates the basic ability of expressing relationships between bodies of data.

The integrity of the structure is key to using the timeless power of relational databases. Maintaining strict rules and well-defined relationships within and between each component of the database ensures correct, accurate and predictable behaviors. This system consists of three files: a client file, a job file, and a vendor services file.

The client file contains a record for each client with pertinent contact and business information.

DesktopDesign client info screen

The job file generates (among other forms) a job requisition and time sheet for each job that is initiated. Upon input, tracking of all costs and services associated with the job are facilitated.

DesktopDesign database second screen

An invoice is generated from data in various tables.

DesktopDesign database third screen

Aging reports rely on the integrity of the data types for accuracy.

DesktopDesign database fourth screen

The vendor services file contains pricing and specification information of frequently used vendors. Information from this file is automatically pulled into the job file when needed, and automates ordering, scheduling, markups and billing.


Go back to Maryann Westfall, the designer home page
Go back to Jumping Weasel, Inc. home page
Go back to Online Job Board home page
Go back to The Westfalls' personal home page

© 2004 Jumping Weasel Corporation. All rights reserved.


Game Design short papers


• Stephen Mamber
• Eugene Thacker


Understanding the
  representational power
  of computer code

Translating computer code
  from one abstraction
  into another.

Other Course Papers:

• Sim City (simulation)
• 3D Modeling


• PlantTracker™