AnsweredAssumed Answered

Design question: Is this a one to many or many to many

Question asked by skineedog on Jun 15, 2013
Latest reply on Jun 15, 2013 by schamblee

Title

Design question: Is this a one to many or many to many

Post

     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 Number
     License Type (Commercial, Standard, Other)
     License Class (A, B, C, etc)
     Expiration

     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?

      

Outcomes