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