GEOG 868
Spatial Database Management




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.


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.


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.