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