Do I need an additional field in the database table?

Question

MySQL

The database has tables Orders and an associated table Orders_Products . Also shops . The Orders
table stores information on the order and the identifier of the person who made the order ( User ). I ran into a problem when I need to display all orders for a given store. Currently, this can only be done through the Orders_Products table , because the Orders table does not store the store identifier. Should I add such a shop_id field to the Orders table ? Does this violate the principles of normalization?

Answer 1

you didn’t even cover the subject area with relations, but you are already thinking about normalization) yes. add