Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2005

Tip: Looking for answers? Try searching our database.

Numbering scheme

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cactus Jack - 15 Aug 2005 23:36 GMT
I need to create a database structure based on an indentured or indexed "Work
Breakdown Structure" (WBS) numbering scheme (i.e.  2.5.15.2.7).  The
numbering scheme is based on a max of two digits per level with a max of ten
levels (i.e.  99.99.99.99.99.99.99.99.99.99).  I first thought to create my
first initial table with with a 20 digit number colume, and then thought to
build it with ten 2 digit columes, and then thought to use a text colume with
an input mask, and etc.  In that most of the data structure will be based on
this primary number I would like to get it started right so I am looking for
thoughts and ideas.  
KARL DEWEY - 16 Aug 2005 02:06 GMT
I would build it like this--
WBS--
WBSID - Autonumber - Primary Key
WBS - text
WBS Title - text

1- 1. Requirements
2- 1.1 Management Requirements
3- 1.2 Drafting Requirements
4- 1.2.1 Materials
5- 1.2.2 Tools - Hardware
6- 1.2.3 Tools - Software
6- 1.2.6 Personal
44- 3. Systems
45- 3.1 Active Systems
46- 3.1.1 Electrical
47- 3.1.2 Mechanical

> I need to create a database structure based on an indentured or indexed "Work
> Breakdown Structure" (WBS) numbering scheme (i.e.  2.5.15.2.7).  The
[quoted text clipped - 5 lines]
> this primary number I would like to get it started right so I am looking for
> thoughts and ideas.  
Cactus Jack - 16 Aug 2005 17:13 GMT
you idea is a good one but I don't think will work for this application -
elements of the structure will be dictated for each effort.  In other words
the government will supply some of the basic numbering and definitions and we
will expand on that laydown to break the work structure into much finer
detail and add structure where it needs to be added or expanded.  Each effort
will have different primary structure but always based on a maximum 10 place
indenture structure (99.99.99.99.99.99.99...).  For example 1.2 may be
"systems engineering" in one effort  and have five or six levels of breakdown
detail (1.2.1.1.1.15) whereas in the next effort 1.2 may be something like
"config management" with only a couple layers of detail.  Think of it as
trying to index or track the data in 20 different technical manuals all with
different subjects down to the paragraph or sub paragraph level or even
sentence level.  I don't know if that makes any sense but hopefully you get
the idea.  I guess the basic problem is with a 10 level indenture number
system where each layer can be any number between 1 and 99
(99.99.99.99.99.99.99.99.99.99) and each layer establishes a parent child
relationship as you move to the right, what is the best way of tabling it.  
Maybe just a text field where you type in the X.X.X.X.. number is the way to
go but I'm not sure.  Thoughts??

> I would build it like this--
> WBS--
[quoted text clipped - 23 lines]
> > this primary number I would like to get it started right so I am looking for
> > thoughts and ideas.  
KARL DEWEY - 16 Aug 2005 18:30 GMT
Yes you can build many tables or many fields.

But I think you can build a table to show your hieraracy.
WBS-WBS--
WBSID   WBSID
1            2
1            3
3            4
3            5
3            6

> you idea is a good one but I don't think will work for this application -
> elements of the structure will be dictated for each effort.  In other words
[quoted text clipped - 43 lines]
> > > this primary number I would like to get it started right so I am looking for
> > > thoughts and ideas.  
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.