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