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