Friday, October 5, 2007

Module 7 - Attribute Data and Tables










ANNOUNCEMENTS

none
LEARNING OBJECTIVES
  1. Describe the difference between a database and a database management system
  2. Describe the basic database components and characteristics
  3. Distinguish between physical, logical and conceptual database structures
  4. Compare and contrast non-relational and relational databases
  5. Perform queries based on attribute information
  6. Discuss the normal forms in database design
  7. Describe object-relational data models
  8. Discuss current and future trends in spatial DBMS

TERMS TO KNOW

Lecture - GIS Fundamentals

  • Database Management System (DBMS)
  • data independence
  • multiple user views
  • centralized control and maintenance
  • data items or attributes
  • entity
  • instance
  • record
  • row
  • file
  • relational table
  • server
  • clients
  • multi-tiered architecture
  • transaction manager
  • applications server
  • schema
  • entity-relationship diagram
  • conceptual database design
  • logical database design
  • physical design
  • parent
  • children
  • relations
  • relational algebra
  • restrict
  • project
  • union
  • intersection
  • difference
  • product
  • join
  • divide
  • table query
  • AND
  • OR
  • NOT
  • normal forms
  • primary key

  • READING ASSIGNMENT

    GIS Fundamentals - Chapter 8 - Attribute Data and Tables - GET THE POWERPOINT SUPPLEMENT HERE - refresh page if it does not download

    Read the chapter but study the powerpoint for the test

    ASSIGNMENTS (ACTIVE LEARNING EXERCISES)

    7A) Getting to Know ArcGIS - Chapter 8 - Querying Data
    7B) Getting to Know ArcGIS - Chapter 9 - Joining and relating tables

    No comments: