Primary And Foreign Keys Are Like A Parent - Child

a: Primary and foreign key ~
b: a Parent - Child relationship

What: "The basic rule of thumb is that Primary and Foreign keys are like a Parent - Child relationship. The Child stores the Parent's id. This way each Parent can have multiple Children. It can get a WHOLE lot more complicated, but this will give you a very good starting approach to most of your database solutions."

Writer: Michael Rodrigues
Date: Dec 16 2011 7:36 PM

Send a comment/complaint about this entry to


Please provide any other details you think
will be useful to us in the text area below.