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