I'm confused in my database
<p>I want to really decide what the proper way of creating a database in the field of inventory is. I have this table <code>Product</code>, my product has <code>id</code>, <code>supplier</code>, <code>product_name</code>, <code>category</code>, <code>size</code>, <code>color</code>, <code>expiration</code> and <code>selling_price</code>. </p>

<p>So we create a UI that inputs 1 product but having many input sizes. </p>

<p><a href="https://i.stack.imgur.com/55kBQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/55kBQ.png" alt="The Picture here"></a></p>

<p>My first resort to input them in my product table is to loop them based on the sizes (my counter is how many sizes are to be inputted) because in 1 product there is only 1 size right?</p>

<p>For example I have a product named <code>Nike</code> that has sizes 11 12 13 and 14.
Since there are 4 sizes, I will loop them for 4 times in table product there should be 4 rows now, same product name but different sizes. It's not redundant since in 1 product there is only 1 size.</p>

<p>Now, I'm little bit confused. Nike can be or has many sizes but it 1 product can be 1 size in rule right? or brand? or what? so should I normalize and make another table named Product_sizes or just let it be? cause even if I'll make another table, there will always be 4 rows in respect for the sizes.</p>

<p>Help!</p>