Home Forums SQL Server 2005 SQL Server Newbies Relationship between two tables (what is correct?) RE: Relationship between two tables (what is correct?)

  • May 8, 2013 at 8:20 am

    #1613367

    Carl0s_ (5/7/2013)

    Hi, can someone help me with this basic doubt? "tnx in advance"

    I have two tables (groups, rol), I need to know what's the correct way to create a relationship

    my tables definition

    Groups_cat

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

    [b]Pk[/b] Group_iD

    Group_name

    Rol_cat

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

    [b]Pk[/b] Rol_iD

    Rol_name

    Rol_description

    the doubt is here.... What is the correct way to connect this tables?

    As I see it, there is no relationship between those tables.

    Do "roles" belong to "groups"? meaning, groups is parent and roles child?

    Is there a one-to-one, a one-to-many or a many-to-many relationshiip?

    What your ER model tells you?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.