Results 1 to 3 of 3
  1. #1
    rosh41 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    10

    Relationships?

    Hi,
    I have an employee table with three other tables containing:
    1. tblEmployee


    2. tblDepartment
    3. tblArea
    4. tblSection

    a. Is it normal to have a many-to-many relationship between tblEmployee and each of the other tables(with junction tables)? or
    b. Can I just have a one-to-many relationship setup between tblEmployee and each of the other tables?

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    It depends:

    - can an employee belong to more than one Department, Area or Section?
    - Do relationships already exist between Department, Area and/or Section? If so, what are they?

    Cheers,

  3. #3
    rosh41 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    10
    An employee ussually only belongs to one department + one Area + one section.(Maybe this is the obvious answer to my question: one-to-many)

    I'm busy developing a training database spanning over a whole company with many departments, area's and sections.
    I want to find a way to link certain courses exclusively to certain departments.(Like Eng, HR, Finance)
    Would you achieve this by running queries on one big courses_table, or by using different courses_tables for each department?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database relationships
    By radex7 in forum Database Design
    Replies: 10
    Last Post: 03-07-2011, 05:07 PM
  2. question about relationships
    By grad2009 in forum Access
    Replies: 3
    Last Post: 02-16-2010, 06:12 PM
  3. Relationships - GroupID
    By Dega in forum Database Design
    Replies: 7
    Last Post: 01-28-2010, 10:41 PM
  4. 8 Tables with Relationships
    By bigdogxv in forum Access
    Replies: 1
    Last Post: 12-09-2009, 09:37 PM
  5. Tables Vs Relationships
    By Bruzer in forum Database Design
    Replies: 8
    Last Post: 09-06-2009, 04:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums