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