Database design — relational schemas, normalisation

What you'll learn

1. 1

   Think of a messy spreadsheet with customer orders — the same customer's name appears 10 times! That's a data nightmare. 😱

2. 2

   Why is it bad to have the same customer name repeated many times in an orders table?

3. 3

   Let's normalise this orders table together: OrderID, CustomerName, CustomerAddress, ProductName, Price

4. 4

   Drag each column name into the correct table: Customer table or Orders table

5. 5

   What is the foreign key in the Orders table that links to the Customer table?

6. 6

   Normalisation also removes partial dependencies — where a column depends on only part of a composite key.

7. 7

   In this table: (OrderID, ProductID, ProductName), which column is partially dependent on ProductID?