Database design and implementation  ARC00036M

Module leader: Jen Mitcham

Aims

  • To teach the basic principles of relational database design and its applications.
  • To provide the necessary skills to build such database structures and implement them.
  • To ensure an understanding of the range of applications of database technologies in archaeology and the decision processes involved in choosing, designing and implementing them.

Learning Outcomes

Upon completion of this module students should be able to:

  • understand the principles of the relational database model
  • design simple databases using entity relationship modelling techniques and to check designs using normalisation rules
  • write SQL queries for defining, querying and manipulating databases
  • apply basic database design and SQL concepts to a database project for archaeological applications.
  • be able to describe and evaluate other (non-relational) approaches to database manipulation
  • describe the uses of database technologies in archaeology
 
database design & implementation