>To all
>
> where can i learn how to create relationship and decide one to many or one to one realtionship??? any example or aticle that i can view?

Coann,

that's not an easy issue to learn from an article you need also a lot of experience.
Have a look at "Relational Database Design Clearly Explained" by Jan L. Harrington.