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