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