Can you explain the concept of normalization and denormalization?
Use the provided related tables to demonstrate the concept by producing a denormalized order summary. Include orders without line items so the result preserves the complete order list.
order_id, customer_name, order_date, status, item_count, and order_totalorder_date ascending, then order_id ascending| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| VARCHAR(255) | Customer email address |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_id | INT | Customer who placed the order |
| order_date | DATE | Date the order was placed |
| status | VARCHAR(30) | Current order status |
| Column | Type | Description |
|---|---|---|
| order_item_idPK | INT | Unique order line identifier |
| order_id | INT | Order containing the line item |
| item_name | VARCHAR(100) | Name of the ordered item |
| quantity | INT | Number of units ordered |
| unit_price | NUMERIC(10,2) | Price per unit |