🏝️ We've extended our Summer Sale — 30% off all packages — Grab it before it's gone! 🏄

Preview Mode — This PBQ requires a Premium Membership and is being shown in a read-only preview mode.     See Plans

Database Concepts and Relationships

CompTIA Data+ DA0-002 (V2) PBQ

This exercise focuses on matching database terms, such as primary keys, foreign keys, and normalization, to their functions or examples in database design.


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