Skip to main content
Penn State College of Earth and Mineral Sciences Logo Penn State shield logo with links to Penn State homepage and College of Earth and Mineral Sciences

Department of Geography

Department of

Geography

GEOG 868: Spatial Database Management for the Geospatial Professional

User account menu

  • Log in
  1. Home
  2. Welcome to GEOG 868 - Spatial Database Management

Lesson 2: Relational Database Concepts and Theory

  • Overview
  • Checklist
  • Relational DBMSs Within The Bigger Picture
  • Database Design Concepts
  • Implementing a Database Design
  • Adding Records to a Table
  • Updating Existing Records
  • Deleting Records
  • Project 2: Designing a Relational Database

Book traversal links for Lesson 2: Relational Database Concepts and Theory

  • ‹ Project 1: Writing SQL SELECT Queries
  • Up
  • Overview ›
Printer-friendly version

Search

Lessons

  • Welcome to GEOG 868 - Spatial Database Management
    • Lesson 1: Retrieving Data From a Relational Database
    • Lesson 2: Relational Database Concepts and Theory
      • Overview
      • Checklist
      • Relational DBMSs Within The Bigger Picture
      • Database Design Concepts
      • Implementing a Database Design
      • Adding Records to a Table
      • Updating Existing Records
      • Deleting Records
      • Project 2: Designing a Relational Database
    • Lesson 3: Building a Postgres/PostGIS Database
    • Lesson 4: Advanced Postgres/PostGIS Topics
    • Lesson 5: Working with Esri's Desktop Geodatabases
    • Lesson 6: Introduction to the Enterprise Geodatabase
    • Lesson 7: Data Management in an Enterprise Geodatabase
    • Lesson 8: Versioned Editing
    • Final Project

Course materials prepared by Jim Detwiler and Jim Sloan, College of Earth and Mineral Sciences, The Pennsylvania State University

Unless otherwise noted, this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License(opens in a new tab), part of Penn State's College of Earth and Mineral Sciences' OER Initiative and the Libraries’ Repository of Open and Affordable Materials (ROAM(opens in a new tab)).

The College of Earth and Mineral Sciences is committed to making its websites accessible to all users, and welcomes comments or suggestions on access improvements. Please send comments or suggestions on accessibility to the site editor. (opens email client).

The John A. Dutton Institute for Teaching and Learning Excellence is the learning design unit of the College of Earth and Mineral Sciences at The Pennsylvania State University. About the Institute | Contact Us | Email the Site Editor. (opens email client)

© The Pennsylvania State University | Privacy | Non Discrimination | Accessibility | Equal Opportunity | Copyright