Home of real teaching & learning
  • Full support for teachers
  • Focus on critical thinking
  • Engaging classroom activities
  • Integrated student eBook
  • Assessed tasks / qBank
  • Practice exam questions
Find out more Download brochure

The InThinking Guarantee: Our sites are written by expert practitioners and not by AI

See our AI policy

Disclaimer: InThinking subject sites are neither endorsed by nor connected with the International Baccalaureate Organisation.

Don't miss out, find out!

A 3.2.5 Worksheet Normal forms

Part 1: Understanding 1NF 1. Why is atomicity important in database design? 2. Transform the following table into 1NF: 3. Identify and correct all 1NF violations in the following table: Part 2: 2NF and Partial Dependencies 1. Explain what a partial-key dependency is and why it's a problem. 2. Identify the partial dependency (if any) in the following table and explain how to normalize it to 2NF. (Assume the primary...

Help