Which normal form is broken?
choice15 pts
A colleague proposed a single table orders_flat for all orders. Sample rows:
| order_id | order_date | customer_id | customer_name | customer_email | product_id | product_name | unit_price | qty |
|---|---|---|---|---|---|---|---|---|
| 10 | 2026-03-01 | 1 | Anna | anna@example.com | 1 | Monitor | 180 | 1 |
| 10 | 2026-03-01 | 1 | Anna | anna@example.com | 3 | Router | 60 | 1 |
| 11 | 2026-03-15 | 1 | Anna | anna@example.com | 2 | Tablet | 250 | 1 |
| 12 | 2026-03-02 | 2 | Boris | boris@example.com | 3 | Router | 60 | 2 |
One row is one line of an order; the primary key is the pair (order_id, product_id). What is true about this table?