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