Why are the warehouse, manufacturer, and supplier stored in separate tables rather than in the Table table?

The warehouse, manufacturer, and supplier are stored in separate tables for data normalization and to avoid redundancy. If all these entities were in one table (for example, Table), then with repeating values (the same warehouse or supplier for different products), the data would be duplicated, which complicates updates and increases storage volume.

Separate tables allow:

• Storing unique records for each warehouse, manufacturer, and supplier.
• Establishing relationships through foreign keys, which enhances data integrity.
• Simplifying information updates (for example, changing the warehouse address in one place).
• Improving the readability and structure of the database.

This is a classic approach of relational modeling — data normalization.