Database Concepts and Relationships
This exercise focuses on matching database terms, such as primary keys, foreign keys, and normalization, to their functions or examples in database design.
Cardinality
Foreign key
Composite key
Referential integrity
Normalization
Attribute
Relationship
Entity
Primary key
Index
Multiple columns forming a unique identifier
Ensures valid link between records
Represents a real-world object
Organizes data to reduce redundancy
Association between entities
Characteristic of an entity
Reference in another table
Speeds data retrieval
Unique identifier
Defines number of relationships