The Scenario
The sales team has been tracking customer orders in a single Excel spreadsheet with columns: OrderID, CustomerName, CustomerEmail, CustomerPhone, ProductName, ProductCategory, Quantity, Price, OrderDate, SalesRepName, SalesRepRegion. There are 5,000 rows with massive duplication.
The Brief
Normalise this flat structure to Third Normal Form (3NF). Show each normalisation step with the reasoning for each decomposition.
Deliverables
- The original flat structure with sample data (5 rows) showing the duplication problem
- Step-by-step normalisation: 1NF → 2NF → 3NF with explanation of what violation each step removes
- The final normalised schema with tables, columns, primary keys, and foreign keys
Submission Guidance
1NF removes repeating groups. 2NF removes partial dependencies. 3NF removes transitive dependencies. Show each violation before fixing it.
Submit Your Work
Your submission is graded against the rubric on the right. If you pass, you get a public Badge URL you can share on LinkedIn. There is no draft save, so work offline first and paste your finished response here.