Design question: Is this a one to many or many to many
I need to track an employee's driver's license. I'd like to keep track of the type of license he or she has like a standard license or a commercial license and when that license expires.
What I am not clear on is whether this is a many-to-one or a many-to-many relationship?
I think most would think of this as a one-to-one but if the license type changes does this constitue a new record? Same with the expiration dates. When a license expires, should the renewal be a new record? I would say yes if one needs to keep record of the license history.
Fields would be:
License Type (Commercial, Standard, Other)
License Class (A, B, C, etc)
Any one of these fields could change which would be a new record. If this is a many-to-many relationship, how should the tables & fields be setup?