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