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