Senior Backend Engineer / Stage 2 · Data
Choose keys, constraints and normal forms
"Already know" meets prerequisites. "Not relevant" removes the topic from your total but leaves what builds on it waiting.
Self-check
- You model customers, orders and order lines. Choose primary keys, foreign keys and a constraint that rejects negative quantities. Decide where the historical unit price belongs.
- Evidence to include: Show the schema and two invalid inserts that constraints reject. Explain intentional duplication.
Try it without the material first, then compare. Save your answer in your notes below. Report a problem with this self-check
Learning activities
2 activities- Not done12 min
- Not done6 min