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