sql - Database Table: Quantity or redundancy -

I am creating a database that has a lot of items for the bike shop. Many accessories in this bike store Like 100 wheels in size 4 and color 'red'. My question is this:

It is better to add the 'quantity' field to set up the unit and put all the same objects into one unit (example 1) or it is a unit for each item (e.g. Is better for 2)?

Example 1:

ID | Color | Size | Quantity

1 | Lal 4 | 100

Example 2:

ID | Color | Size

1 | Lal 4

2 | Lal 4

3 | Lal 4

etc.

1st - QFiinity field - unless you have no reason to track the example serial numbers , And still you can go to v1 and use a different column.

Generally: Get a copy of the Data Model Resource Book Volume 1 - There is a ton of discussion about the standard business data problems, one of those list systems will teach you a lot.