Foreign key location



  • This is a question from a Master's degree.

    What is the correct response to the question depicted in the image, and why?

    Or do you believe there could be multiple correct answers?

    Question



  • In the relational data model it is a good idea to avoid as much as possible nullable foreign keys.

    Assuming that each license has a holder, while a person can have a license or not, this means that the foreign key should go into the table representing licenses, so that it is a not null attribute.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2