Database Concepts and Relationships
CompTIA Data+ DA0-001 (V1) 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
Cardinality
Composite key
Relationship
Foreign key
Primary key
Entity
Attribute
Organizes data to reduce redundancy
Speeds data retrieval
Reference in another table
Characteristic of an entity
Ensures valid link between records
Defines number of relationships
Represents a real-world object
Association between entities
Multiple columns forming a unique identifier
Unique identifier