Creating a Unique ID

[sgurusha]

Folks:

I'm trying to put together a requirements database for my team of BAs, in which they can document the requirements as they proceed with interviews/JAD sessions.

Is there a way I can have a ID for each requirement generated, and sorted in the following way as they enter the info into the database:

1 requirement
1a Child requirement of 1
1a1 Child of requirement 1a
2 requirement
3 requirement
.
.
.

Thanks in advance.

Regards,
sgurusha

 

[rdodge]

This looks a lot like how BOMs (Bill of Materials) are setup in a DB environment. To make things a bit more simple from a DB point of view, you may want to create 2 tables, one as the requirement table (Like an Item Table), and the other that contains the various related information of the Child/Parent requirements (Like a BOM Table)

Requirement Table
Requirement ID (Primary Key)
Requirement Name
Requirement Desc
<Other pertinent information specific to the requirement>

Bill of Requirements Table
BOR ID (Primary Key)
Parent Requirement ID
Child Requirement ID
<Other pertinent related information to the BOR>

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.