Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    6

    Normalisation and Relationship Problem

    Hi,
    I am creating a new database to store information on Jobs. The criteria are;
    A Job has a Job # and a Job Name
    When allocating jobs, the job is broken down into Divisions. Each job has many Divisions e.g.
    Job_Number: 101
    Job Name: Remodel the Kitchen
    Divisions: Carpenters, Plumers, Tilers.
    The divisions have numbers e.g.
    Division_ID: 20, Division Name: Carpenters
    Division_ID: 30, Division Name: Plumbers
    Division_ID: 40, Division Name: Tilers
    Each Division has Subdivisions e.g.
    Division_ID: 20, Division Name: Carpenters
    SubDivision_ID: 21, SubDivisionName: Drywall
    SubDivision_ID: 22, SubDivisionName: Cabinet Installers
    Division_ID: 30, Division Name: Plumbers
    SubDivision_ID: 31, SubDivisionName: Pipe Work
    SubDivision_ID: 32, SubDivisionName: Sink/Fixture Installers
    I am having trouble setting up the relationship for these tables. The tables I have are
    tbl Job Info
    Job_Number
    Job_Name
    tbl Division Info
    Division_ID
    Division_Name
    tbl SubDivision Info
    Subdivision_ID
    Subdivision_Name
    I created another table called tbl Job Division Info where I pulled the PK's from tbl Job Info and tbl Division Info. So this table looks like:
    tbl Job Division Info
    Job_Number
    Division_ID
    I did this because one job can have many divisions and one division can be on many jobs. Is this correct?


    My other problem is how do I relate tbl SubDivision Info to tbl Division Info ? I have attached what my relationship table looks like but to me I have Division_ID being related from one table to two other tables. Is this good practice or will totally not work?
    Please can someone help me? I've posted before with no response at all, I hope I have enough information to get something back.
    Thanks.
    Last edited by dromorkid; 11-11-2008 at 09:30 AM.

  2. #2
    Join Date
    Nov 2008
    Posts
    6

    Please Help!

    Is there something wrong with this question? I'm not having any replies!? Can someone assist me please or tell me what to do in order to explain the question better if it is confusing everyone?!?!

  3. #3
    islo is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Posts
    7
    Do you still need help with this, or were you able to get a solution?

  4. #4
    Join Date
    Nov 2008
    Posts
    6
    Hi,
    Thanks, I have the problem sorted. Thank you for the reply though

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

Similar Threads

  1. design using relationship...
    By dsnyder in forum Database Design
    Replies: 2
    Last Post: 10-21-2008, 12:00 PM
  2. Many-to-Many Relationship
    By Carolyn1 in forum Database Design
    Replies: 0
    Last Post: 09-25-2006, 02:04 PM
  3. Many to Many relationship
    By Marlie in forum Database Design
    Replies: 6
    Last Post: 08-18-2006, 01:49 PM
  4. one to many relationship
    By pe_z in forum Database Design
    Replies: 2
    Last Post: 02-17-2006, 10:44 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 AM

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