Database terminology: Theory

Specification Points
Specification Reference Specification Point
3.1.5 a

describe the terms typically used in relational database terminology:

tables, primary keys, fields, records, relationships, foreign keys, duplicate data, referential integrity, entity, attribute, explaining the role and purpose of each

Resources

Mini Website

This mini website covers the specification points above.

Students should read through the information and make their own notes.

There are some suggestions for tasks in the 'Lesson Ideas' section which could be used to accompany the website.

storage theory miniweb