Please, I need some help to design a database (as better as posible). I have a set of products made with diferent sizes and customers can create Orders asking for many products and variables quantities of each of their available sizes.
My doubt es which of the following schemas is better?:
1.- Create a table of Products, create a table of Product Sizes, create a table of Orders and create a table for each quantity requiered. For example see the following draft tables (only main fields are shown)
2.- Create a table of products with multiple fields to define all available product sizes, create a table of Orders with multiple fields to store all quantities required for product size. For example see the following draft tables (only main fields are shown):
Hi Ned, thanks for your comment. In terms of design I agree that option 2 breaks the relational rules, but my concern is in terms of the volume because the data stored is to big at the detail level and the resources are too limited for the database and the application that manages that information.