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