Member Avatar for Exaktor

Hi,
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.

  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for JorgeM

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).

Member Avatar for pritaeas

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.

Edited by pritaeas
Be a part of the DaniWeb community

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