I suggest that you work through the Tutorials in the help, then perhaps some of the other training materials Wil suggested.

Also, you the Studio wizards! They will magically do the right thing (once your tables use relationships and you have created DDs for them).