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