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