Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 5
Easy

A marine biology research institute uses a relational database to track whale sightings. The schema contains two tables, tblEncounter and tblWhale, linked by a relationship as shown below:

Database Schema

With reference to this schema, define the term foreign key and explain its role in linking the tables.

[2]

Relational databases Questions

  1. GCSE
  2. /Computer Science
  3. /Relational databases