Senior Backend Engineer / Stage 2 · Data

Choose keys, constraints and normal forms

CoreFoundationDraft, not yet reviewed18 min of activities

"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

My notes

Saved on this device, synced when signed in
Esc
↑ ↓ to move↵ to open