GEOG 897D
Spatial Database Management

Overview

PrintPrint

Now that you've gotten a taste of the power provided by relational databases to answer questions, let's shift our attention to the dirty work: designing, implementing, populating and maintaining a database.

Objectives

At the successful completion of this lesson students should be able to:

  • design a relational database and depict that design through an entity-relationship diagram
  • create new tables in MS-Access
  • develop and execute insert, update and delete queries in MS-Access
  • describe what is meant by 1st, 2nd and 3rd normal forms in database design
  • explain the concept of referential integrity

Questions?

If you have any questions now or at any point during this week, please feel free to post them to the Lesson 2 Discussion Forum in Canvas.