Junior — Middle
Can you give an example of a dataset that did not pass normalization?
sobes.tech AI
Answer from AI
Example of a dataset that did not undergo normalization:
| ID | Customer Name | Customer Address | Order ID | Product | Quantity |
|---|---|---|---|---|---|
| 1 | Ivan Ivanov | Moscow, Lenina St., 5 | 101 | Keyboard | 2 |
| 1 | Ivan Ivanov | Moscow, Lenina St., 5 | 102 | Mouse | 1 |
In this example, customer data is repeated for each order, leading to redundancy and anomalies during updates. Normalization would split the data into Customer and Orders tables, eliminating duplication.