I have want to build a database with car parts. The problem is that the car part can fit the car but from year 2000-2004 and not only just one year like 2001.

For example:

Make           Model             Part                Year
Toyota         Camry            Mirror              2000-2004

The thing is that the mirror fits the car from year 2000-2004. But I want in my application to select year maybe 2002 and want the same part to show up.

Maybe create YearBegin column and YearEnd Column, then in the application perform the logic to figure out that 2002 is within 2000 (Begin) and 2004 (end).

In addition to JorgeM: make the from and to a date column, so if needed, you can store day and month too. No car part is built an entire year exactly.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.