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