Relational Databases for Archaeology Main Menu

Relational Databases for Archaeology

2
by Peter J. Cobb, University of Pennsylvania
version: December 2017

<back to Methods Exchange

This online guide introduces the topic of relational databases and is intended for an archaeological audience.  This was written as a textbook to introduce archaeology students to this technology within a classroom setting.  Each subsequent section covers a more advanced topic and includes practice exercises to help build skills.

Contents of this path:

  1. Why Relational Databases
  2. What is a Relational Database
  3. Software
  4. Example Archaeological Recording System
  5. Fields and Data Types in Tables
  6. Constraints
  7. The Primary Key
  8. Saving the Database
  9. Relationships
  10. Normalization
  11. Data Entry Forms
  12. Structured Query Language (SQL)