Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
How would you create a database that sells products of the same cost for each size range.
Current Products Table:
Does it make sense to store it as mentioned above?
Or would you you store it as:
Each sale line will mention the exact size sold.
Typically one would do something like the second option you mentioned, with a dedicated dimension field for the Size and another field for the UnitOfMeasure (or UM for short). Or possibly refactoring those fields into a separate ProductDimensions table (though this is more optional / use case dependent).
This provides the most flexibility, and makes the most sense logically for the purpose of a Products table, as one would assume the table would store unique Products. Otherwise, seeing Product1 (etc) multiple times in the Products table could be confusing and / or complicate application logic.
