The Suppliers_Products table is generated, and this is immersed as attributes the supplier code and the product code plus the date of shipment, the question is, the product table no longer needs the provider code for data redundancy or I'm wrong, I hope for your contributions
effectively is not necessary - The supplier code is not a specific field of the product entity and the relationship between supplier and product (n x x) is reflected in the supplier-product table. - The felling supplier-product contains the necessary and sufficient information to determine what product, what quantity and who was the supplier. - If you place the supplier code within the product, would you have to create a product for each supplier and if you have 5 suppliers that provide you with the same product? you would have to create 5 records of the same product but with a different supplier.