I am working on creating a sports card database. I am trying to figure out the best way to layout the tables. Here is the data I am working with.
Each card belongs to a set of cards and a sport Each set of cards belongs to a brand of cards Each brand of cards belongs to a manufacturer
That part I thought I had all worked out, until I thought about years. Not all manufacturers existed throughout all the years, not all brands were produced by the manufacturers during all of the years, and not every set was produced under its brand every year.
So how should I include the year into the database while reducing redundancy? Any design strategies would greatly be appreciated.