MVSFORUMS.com

[coolman]

Can any one please help me on this one.

I have 2 tables.

Say Table Work_To_Be_Completed and Tasks_Involved

Say Work_To_Be_Completed has just 1 column like Work_To_Be_Completed_Name and has values:

CODING
TESTING

Now "Coding" itself has many sub tasks like
1. Choose language
2. Start coding
3. Complete coding

And similar for "Testing" has many subtasks like
1. Prepare Test Bed
2. Test it for positive cases
3. Test it for negative cases


Now, Coding would inturn "automatically" correspond to
1. Choose language
2. Start coding
3. Complete coding

and similarly for Testing

Now Im planning to maintain a cross-ref between these 2 tables, but looks like the dependency is not going to be 1-1(its a 1 - many r'ship). Any suggestions on how to make it normalized.

Thanks,
Coolman
________
iolite reviews