teach-ict.com logo

THE education site for computer science and ICT

1. Introduction

This section builds upon the "Introduction to Databases" miniweb, and you will need to have completed it before this one will make much sense. If you haven't read that section yet, you can find it here.

 

Keys are a way of sorting and filtering data within a database. In this section, we will discuss how keys are used, and their variations. This will include:

  • Primary keys
  • Compound keys
  • Secondary keys
  • Foreign keys

image

 

 

Teach-ICT SQA Nationals 4 5 Computing Science Database Key Primary Foreign Secondary Compound