problems figuring out this table design

[wargod1999]

ok i'll try to explain what i'm trying to do the best i can.

Im trying to make a database of the server room's cabling; which port
are connected to which switches and computers, servers, routers, etc.

there are two types of patch panels. lets just say P1 and P2.

P1 goes in syntax of 001-D1, 001-D2...001-D8, 002-D1...
P2 goes in syntax of S1 B1 P01, S1 B1 P02...S1 B2 P01, S1 B1 P02...

now some routers, servers, PCs, etc plug into P1 and some plug into P2
some even go from one port of P1 to another in P1 and the same wit
P2.

I hope I'm making this clear.

How can I arrange the tables to be able to organize this all together?

I already have the data, but i think I'm either organizing the table
wrong, setting up the primary keys wrong, and/or setting up th
relationships wrong. I plan to display this information on a web pag
via ASP.NET VB.

Any Help is much appreciated. Thanks

 

[Chris Howarth]

ok i'll try to explain what i'm trying to do the best i can.

Im trying to make a database of the server room's cabling; which ports
are connected to which switches and computers, servers, routers, etc.

there are two types of patch panels. lets just say P1 and P2.

P1 goes in syntax of 001-D1, 001-D2...001-D8, 002-D1...
P2 goes in syntax of S1 B1 P01, S1 B1 P02...S1 B2 P01, S1 B1 P02...

now some routers, servers, PCs, etc plug into P1 and some plug into P2.
some even go from one port of P1 to another in P1 and the same with
P2.

I hope I'm making this clear.

How can I arrange the tables to be able to organize this all together?

I already have the data, but i think I'm either organizing the tables
wrong, setting up the primary keys wrong, and/or setting up the
relationships wrong. I plan to display this information on a web page
via ASP.NET VB.

Any Help is much appreciated. Thanks.

I have placed a sample file here which contains what I consider to be the
basic table structure for this application:

http://www.howarthcd.plus.com/codeexamples/patch.zip

Hope this is of use. Please reply if you have any questions.

Chris

 

[Chris Howarth]

ok i'll try to explain what i'm trying to do the best i can.

Im trying to make a database of the server room's cabling; which ports
are connected to which switches and computers, servers, routers, etc.

there are two types of patch panels. lets just say P1 and P2.

P1 goes in syntax of 001-D1, 001-D2...001-D8, 002-D1...
P2 goes in syntax of S1 B1 P01, S1 B1 P02...S1 B2 P01, S1 B1 P02...

now some routers, servers, PCs, etc plug into P1 and some plug into P2.
some even go from one port of P1 to another in P1 and the same with
P2.

I hope I'm making this clear.

How can I arrange the tables to be able to organize this all together?

I already have the data, but i think I'm either organizing the tables
wrong, setting up the primary keys wrong, and/or setting up the
relationships wrong. I plan to display this information on a web page
via ASP.NET VB.

Any Help is much appreciated. Thanks.

I have placed a sample file here which contains what I consider to be the
basic table structure for this application:

http://www.howarthcd.plus.com/codeexamples/patch.zip

Hope this is of use. Please reply if you have any questions.

Chris

 

[wargod1999]

the link doesnt work. do you have an alternate way of sending it