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