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