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