Lecture 2 – Relationships and Lookup fields Rebecca McCready Faculty of Medical Sciences Newcastle University

http://fms-itskills.ncl.ac.uk

Introduction to Databases

• • • • The ‘relationship’ in the database Types of relationship Lookup fields Relationship diagrams http://fms-itskills.ncl.ac.uk

The ‘relationship’

• Primary key – Foreign key

In Excel In Access

http://fms-itskills.ncl.ac.uk

Types of relationships

http://fms-itskills.ncl.ac.uk

Lookup fields

http://fms-itskills.ncl.ac.uk

Relationship diagrams

• Display the links between tables graphically.

http://fms-itskills.ncl.ac.uk