Solved

Hierarchical Data Structure Issue

Posted on 1998-03-11
11
196 Views
Last Modified: 2006-11-17
I'm wondering if there is a better way to set up my data structure.

The nature of the data is this:
I have a set of processes.
Within each process there are several sub-processes.
Each process and sub-process have a set of objectives associated with them.

The way it is currently set up is as follows:
Process Lookup table lists the process names
Subprocess Lookup table lists the subprocess names
Process Subprocess Relationship table has an ID, Process ID and Subprocess ID

This results in a list in which each process ID is repeated for each of its associated subprocesses plus a blank which I use to denote all subprocesses in the process.

Now I want to add objectives.  First I built the lookup table:

Objectives Lookup table lists the objectives

Then I saw two alternatives:
I could add an Objectives ID field to the Process Subprocess table - seems like the wrong thing because I'd be repeating the Process - Subprocess relationship multiple times for no reason.
or
I could create a Process Objectives table with Process Subprocess ID and Objectives ID - seems right because now I can attach all the objectives I want to each process subprocess pair with repeating the pairing.  Problem is it tells me the relationship is indeterminate when I do it.

Am I missing a far better way to do this or am I on the right track?  

Thanks in advance.
0
Comment
Question by:greilly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 70 total points
ID: 1970587
It sounds to me like this could be done more easily; without the relationship table etc.
Can the sub processes be connected to more than one process ? If not you could include the processID as a field in your subproject table. The same is valid for the objectives table(s), you could probably also include the ID of the project/subproject it is linked to.

If you want you could send me a zipped version of your app, including the tables involved and I will look at it. email: kontry@statoil.no

Trygve
0
 

Author Comment

by:greilly
ID: 1970588
You should be able to find a zipper on any shareware site. Try:

http://www.slaughterhouse.com:80/zip.html

0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970589
Did you find the zipper ?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 12

Expert Comment

by:Trygve
ID: 1970590
can you recommend one in particular?  I looked, downloaded one (I don't remember which) and struggled with how to use it.  I think I downloaded a shell which I'm not sure is actually a full program.  What do you use?
0
 

Author Comment

by:greilly
ID: 1970591
I usually use WinZip or Visual Zip. I also use pkZip which is a good old DOS program. I can send you this one on mail if you provide me with your mail address...
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970592
thanks it's greilly@measure.net
0
 

Author Comment

by:greilly
ID: 1970593
Did you get the file I sent you ?
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970594
the file is on the way to you.  let me know if you don't get it in one piece.
0
 

Author Comment

by:greilly
ID: 1970595
I got the file. I will have a look at it later today or tomorrow.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970596
OK, it took more time than I had imagined to get back to you.

I have sent you a mail including some comments and a MDB with suggestions on how the tables could be set up.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970597
Got it.  That structure makes sense.  I'll email you at the end of the week regarding the other issues you brought up.  Thanks again.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question