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