A 3.2.5 Worksheet 2 - Answers
Topic: A3.2.5 Normal Forms (Global Robotics Competition Scenario) Goal: Every cell must be atomic (no lists). Goal: Every non-key attribute must depend on the whole composite key. 1. Analysis: 2. Resulting Tables: Teacher Note: This is where the Many-to-Many relationship is resolved. Table Orders is the "Linking Table" that students often struggle to visualise without SQL knowledge. Goal: Remove "Transitive...