You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
This lesson brings together all the database concepts covered in this course with exam-style questions, model answers, and strategies for tackling each question type. Use this lesson to consolidate your knowledge and develop your exam technique.
Define the following database terms: (a) primary key, (b) foreign key, (c) referential integrity. [6 marks]
(a) Primary key: A field (or combination of fields) that uniquely identifies each record in a table. The primary key value must be unique and cannot be NULL. [2 marks]
(b) Foreign key: A field in one table that references the primary key of another table, creating a link between the two tables. It is used to enforce relationships between entities. [2 marks]
(c) Referential integrity: The principle that every foreign key value must correspond to an existing primary key value in the referenced table, or be NULL if the field allows it. This ensures that relationships between tables remain consistent and that no orphan records exist. [2 marks]
Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.