View Competency

Term identifier

Design relational databases

Prose Task Statement

Involves creating a structured framework to store and manage data effectively.

Applied Dispositions

Self-Directed, Purpose-driven, Meticulous

Knowledge Skill Pairs

Anomalies, functional dependencies, normalization, normal forms, and conversion to BCNF and Skill Level: 5 - Evaluating

Integrity, entity, referential and check constraints and Skill Level: 3 - Applying

Conceptual, logical models, and physical models; Transform a conceptual model to a logical model and a logical model to a physical model and Skill Level: 6 - Creating