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.
Primary key
Relationship
Entity
Referential integrity
Foreign key
Cardinality
Composite key
Index
Attribute
Normalization
Unique identifier
Multiple columns forming a unique identifier
Speeds data retrieval
Represents a real-world object
Defines number of relationships
Reference in another table
Association between entities
Characteristic of an entity
Organizes data to reduce redundancy
Ensures valid link between records