Solved

Hierarchical Data Structure Issue

Posted on 1998-03-11
11
182 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
  • 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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format vertical text in Access 2016 3 31
Open CSV, modify and save as xls from Access 12 19
Set focus on next field when character count = 5 9 12
access 7 21
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now