AnsweredAssumed Answered

Is it necessary to fill IDs when relationships are established? (database design)

Question asked by ThomasM_1 on Aug 24, 2013
Latest reply on Aug 27, 2013 by ThomasM_1

Title

Is it necessary to fill IDs when relationships are established? (database design)

Post

      

     Hi,
      
     I'd like to track events. These have a date and a description and they are always associated with an instructor. Additionally, they can be associated with a client. The design looks like this:
      
     Events >--- Instructors
                  >--- Clients
      
     Instructors: pkInstructorID = Events: fkInstructorID
     Clients: pkClientID = Events: fkClientID
      
     Considering these relationships is it okay to simply leave fkClientID empty for those events where no client is involved? Or is it necessary to fill IDs when relationships are established?
      
     Thanks,
     Thomas

Outcomes