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