Match Database Terms
Drag terms to their matching definitions
Terms
Table
Record
Field
Primary Key
Foreign Key
Query
Data Validation
Normalisation
Definitions
Key Relationships
Primary keys and foreign keys work together to link tables:
Students Table: StudentID (Primary Key), Name, Class
Grades Table: GradeID, StudentID (Foreign Key), Subject, Mark
The StudentID in Grades links back to Students, creating a one-to-many relationship.
Review database concepts →