Skip navigation

WORKSHOP: THE DESKTOP DATABASE AS A DATA MANAGEMENT TOOL
   OTT's Logo
 

May 17 and 18, 2001
8:30 a.m. to 4:30 p.m.
Room 7238, Computer Science Bldg
San Juan Community College
Farmington, New Mexico

The instructors for this 2-day workshop are Alan Best, B&G Systems, Inc., Flagstaff, Arizona (Telephone: (520) 213 - 0370), and John Kern, Ph.D., Spectrum Consulting Services, Pullman, Washington (Telephone: (509) 339 - 2489). Case study presenters are Jim Smith, Jim Ohlman, and John Cochran. Topics for the workshop are as follows:

  1. Introduction (30 minutes) Alan Best and John Kern
    1. What is a relational database
    2. Databases vs. spreadsheets
    3. Desktop databases vs. enterprise databases
    4. Access vs. Paradox
    5. Paradox and ArcView, the dBase connection
  2. Designing a Database (1 hour) Alan Best
    1. Defining data sets and grouping
    2. Defining relationships between data sets
  3. Implementing a Database (2 hours) Alan Best
    1. Creating database tables for data sets
      1. Data field types
      2. Defining a table index
    2. Implementing relationships between data tables
    3. Referential Integrity, primary data relationships, and lookup tables
  4. Database Data Management (3 hours) Alan Best and John Kern
    1. Manual data entry
    2. Importing bulk data into a database
    3. Exporting data from a database to other applications
      1. Exporting to a spreadsheet
      2. Exporting to another database
      3. Exporting to a GIS
    4. Extracting data subsets from a database
      1. QBE vs. SQL