medium10 pts · first answer countsdata-modellingnormalisation
Product name in order items
The table below has primary key (order_id, product_id). product_name depends only on product_id. Which normal form does it break?
Discussion 0
Join free to post in the discussion.
Related questions
- Goal of normalisationData Engineer
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer