Which normal form does this table violate first?
order_items(order_id, product_id, qty, product_name) -- key: (order_id, product_id) -- product_name depends only on product_id
- First normal form (1NF)
- Boyce-Codd normal form (BCNF)
- Second normal form (2NF)
- Third normal form (3NF)
product_name depends on only part of the composite key, a partial dependency that 2NF forbids.