I磎 about to start designing a database for a webshop, but I磎 not sure if my solution is the best.
The company sells products, of course. Each product has a name and a short description and comes in different sizes and different colors. Each size in a given color has a unique price. Which tables and columns would you set up? Where should the price column be, for example?
The company sells products, of course. Each product has a name and a short description and comes in different sizes and different colors. Each size in a given color has a unique price. Which tables and columns would you set up? Where should the price column be, for example?