Database Newbie Help

[javalite]

Hi! I am currently making a VB program that would read a databse consisting
of three elements. An (1)Industry elements, (2)Division elements and (3)
Position elements. If anyone can help me in designing this database, I would
greatly appreciate it. The database would look like this:

Industry: Division: Position:
IT--------------------->Software--------->Software Engineer
I '--------------->Software Developer
'---------->Hardware---------->Computer Technician
'-------------->Network Administrator
Banking.....so on

Engineering.....so on

Hope some one can help a student here. Thanks!

 

[Evi]

According to your description I can see at least 3 tables so far
TblPosition
PosID( Primary Key Autonumber)
IPosition (eg Software engineer)
DivID (linked from TblDivision)

TblDivision
DivID(Primary Key)
Division (eg Software)
IndID (linked from TblIndustry)

TblIndustry
IndID (PK)
Industry eg IT


But this depends if ANY of the Positions - even just one - could belong to
more than one Divison or if a Division could belong to more than one
Industry.

If say, your Software Engineer could belong to more than one division, then
TblPosition would not contain DivID and you would need another table

TblPositionDivision
PDID (PK)
PosID (Linked from TblPosition)
DivID (linked from TblDivision)

Similarly, if a Division could belong to more than one Industry then you
would not have IndID in TblDivision, instead, you would have

TblDivisionIndustry
DIID (PK)
DivID (foreign key from TblDivision
IndID (foreign key from TblIndustry

Do you see the concept? Always start with the lowest element in the
foodchain (Position) and see what group that belongs to. Ask if it can
belong to more than one group. If yes, you need another table.

Evi