I am designing a table for products. The products belong to one of three classes a, b and c. Each class specifies a price (for products).
I need to design the tables such that changing the price of products will only require changing the price in the class table and not for products individually.
So far I have a table for classes and price, and another table for products with a column that specifies the product class. Does this sound right?
This is a simplified version of the real scenario. Can anybody help?
I thank you in advance.