The tutorials, in particular Tutorial 5 deals explicitly with Dataobject Relationship Management.
It explains very clearly what the correct techniques are for handling "1 to 1", '1 to many" and "many to many" database relationships, how to set these up in the CMS, how to handle them in your pages and provides example code for you to play with.