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