Finding a linking table for a DB UML?

Discussion in 'Website Development & Design' started by Fergal, Feb 24, 2012.

  1. Fergal

    Fergal
    uix_expand uix_collapse
    Premium Member
    Premium Member

    Joined:
    Nov 18, 2007
    Messages:
    10,575
    Likes Received:
    1,165
    I'm working on a small college DB project which requires creating a UML type diagram for a DB. My project will be on a forum DB and have tables and attributes as follows (simplified version);

    Member (table)

    Username (attribute)
    Password (attribute)
    Registration IP Address (attribute)
    ID (attribute)
    ...

    Usergroup (table)
    Name (attribute)
    ID (attribute)
    ...​


    Because there is a many to many relationship between these tables (each member can be in more than one usergroup and each usergroup can have more than one member), I need to insert a "linking table" between them.

    I'm considering using "Display Usergroup" as the linking table (with name and ID as attributes), on the basis that each member can only have one Display Usergroup and each Display Usergroup can only have one Usergroup.

    Does that sound logically correct, or am I on the wrong track re the linking table?

    Thanks!
     

Share This Page