Non-spatial Database Models

by Thomas H. Meyer, Mapping Sciences Laboratory, Texas A&M University, USA
 
This unit is part of the NCGIA Core Curriculum in Geographic Information Science. These materials may be used for study, research, and education, but please credit the author, Thomas H. Meyer, and the project, NCGIA Core Curriculum in GIScience. All commercial rights reserved. Copyright 1997 by Thomas H. Meyer.

Your comments on these materials are welcome. A link to an evaluation form is provided at the end of this document.


Advanced Organizer

Topics covered in this unit

Intended Learning Outcomes

Instructors' Notes

Full Table of Contents

Metadata and Revision History


Non-spatial Database Models

1. Motivation: Why database management systems?


2. Fundamental Concepts and Terminology

2.1. Data

2.2. Spatial vs. Non-spatial Data

2.3. Database

2.4. Repository

2.5. Database Management System (DBMS)

2.6.  Queries

2.7.  Data Models


  3. Common Data Models

3.1. Entity-Relationship Model

3.1.1. Entities

3.1.2. Relationships

3.2. The Network Model

3.3. The Relational Model

3.3.1. Tuples

3.3.2. Relations

3.3.3. Tuples, Relations and Keys

3.3.4. Relationships

3.3.5. Query Languages

3.3.6. Relational Database Management System (RDBMS)

3.3.7. Advantages of the Relational Model

3.4. The Object Model

3.4.1. What is the Object Model?

3.4.2. Inheritance (isa) Relationships and Typing

3.4.3. Encapsulation

3.4.4. Comparison to the Relational Model


4. Summary


5. Review and Study Questions

5.1. Essay and Short Answer Questions

5.2. Multiple-choice questions

Choose the best or most appropriate answer(s) to the question.


6. Bibliography


7. Reference Materials

7.1. Print References


Evaluation

We are very interested in your comments and suggestions for improving this material.  Please follow the link above to the evaluation form if you would like to contribute in this manner to this evolving project..


Citation

To reference this material use the appropriate variation of the following format:

The correct URL for this page is: http://www.ncgia.ucsb.edu/giscc/units/u045/u045_f.html.
Last revised: November 19, 1997.


Gateway to the Core Curriculum