Competency 2: Design relational databases
Key Dispositions: Self-Directed, Purpose-driven, Meticulous
Knowledge-Skill Pairs:
| Knowledge Element | Skill Level (Bloom cognitive level) |
| Integrity, entity, referential and check constraints | 3 – Apply |
| Anomalies, functional dependencies, normalization normal forms and convert to BCNF |
5 – Evaluate |
| Conceptual, logical models, and physical models
Transform a conceptual model to a logical model and a logical model to a physical model |
6 – Create
|
Suggestions Accepted for consideration for the next Edition:
Please provide your suggestions about this knowledge unit. All submitted comments will be reviewed at the end of the month. Comments accepted for inclusion will be listed above.