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