What are the primary differences between data normalization and denormalization, and how do they impact pipeline design?
Use the provided normalized and denormalized order-line representations to quantify duplication and consistency differences. Write one SQL query that returns the comparison metrics.
Output
- One row containing the normalized and denormalized line counts, order counts, distinct product counts, repeated attribute rows, and denormalized attribute mismatches.
- Use the exact output column names defined by the solution.
