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."

Useful?
Writer: Michael Rodrigues
LCC: QA
Where:
Date: Dec 16 2011 7:36 PM


By Gilbert on 2014-March-31

Topic: Primary and foreign key

Hi Sir, i feel this answer is not sufficient for this particular question because you are only defining the parent child relationship but what about the foreign key part?

------------------------------------------


Name:
required
Contact:
(email or url) optional
Topic:
Comment:

This is an anti-spam device. Are you Human?

If so, please click the circle next to 'Yes' to submit your comment