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