Database Concepts and Relationships
CompTIA Data+ DA0-001 (V1) PBQ
This exercise focuses on matching database terms, such as primary keys, foreign keys, and normalization, to their functions or examples in database design.
Cardinality
Normalization
Attribute
Referential integrity
Relationship
Index
Composite key
Entity
Foreign key
Primary key
Organizes data to reduce redundancy
Speeds data retrieval
Unique identifier
Multiple columns forming a unique identifier
Association between entities
Characteristic of an entity
Defines number of relationships
Ensures valid link between records
Reference in another table
Represents a real-world object