2 Replies Latest reply on Aug 27, 2013 3:09 PM by ThomasM_1

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

    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