4 Replies Latest reply on Jun 15, 2013 11:32 AM by schamblee

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

    skineedog

      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?