How to normalize the database to 3NF?

Question

Database design

Good afternoon!
Tell me, please, what exactly needs to be done: what additional tables to create, how to convert existing ones, what attributes to pull out into separate tables to normalize this database to 3rd normal form?

Answer 1

The connection between the product and the order through the link table is not entirely correct, because in the future (present) there may not be goods ordered earlier. Therefore, the goods for the order are stored in a separate table purchases, and such a "data entity" can be more denormalized than the goods.
Your product has specifications. But it may be that their number will increase greatly (and very likely), they are usually put in a table featuresand linked. products_features
I didn’t see your offers / offers / product options - specific price offers for goods. For example, the sizes of one product or different ones of the same color, these "data entities" will have a price and a balance. In your case, StorageID and SupplierID
Everything else is normal and is split up as the system develops and becomes more complex/growth