CBEHub

← 3.3 Relational Database Fundamentals

Key fields

Computer Studies · Grade 11 · about 40 minutes

Describe primary, foreign, composite and secondary keys.

Sign in to read this lesson

Lessons are for learners and teachers with an account. Browsing the curriculum — subjects, strands and what each sub-strand covers — stays open to everyone.

  • 8 sections of explanation, worked examples and diagrams
  • 1 practice task with hints and worked answers
  • A quiz that marks itself as you go
  • Your progress kept across every subject you take
Sign in Create an account

Other lessons in this sub-strand

  1. Database terms
  2. Database and DBMS components
  3. Types of database models
  4. The relational model
  5. Entities and attributes
  6. Data types
  7. Key fields
  8. Listing entities, attributes and keys
  9. Creating a database for a real task
  10. Representing a database in an ERD
  11. Creating relationships between entities
  12. Importance of relational databases
  13. Creating an operational database
  14. Reviewing relational databases