brittaink112
New member
- Local time
- Today, 00:45
- Joined
- Sep 19, 2013
- Messages
- 4
Hi all,
I have been tasked with creating a database for our section and am having a little difficulty with planning the relationships between some tables.
We have an internal LAN and I want to create a database to record the configuration. The main things to be recorded are:
IP adresses
Switch Ports
Patching Details
The problem I have is that a computer on the network would record all of the above. It would have an IP address, It would belong to a certain switch port, and it would have a patch number.
A phone would have A patch number but no IP address and wouldnt go into the switch.
A server or UPS for example has a Switch port and an IP address but has no patching detail.
I have played with different designs such as:
sub tables for each of the tables and then a master table where the joins are recorded, but this is not a great solution.
Also I played with having 2 columns in each table recording the relationships if any to the other two, and when the form is updated by the user, a script then makes the same interactions with the other tables, but this gets really complicated when deleting joins etc.
The bonus is that the allocations are fixed. I have
255 IP addresses - FIXED
72 Switch Ports - FIXED
142 Patch Ports - FIXED
If anyone has any suggestions then there is probably a way of doin this that I just havnt thought of but I am really struggling to find the answer lol.
Any help appreciated.
Kind Regards
Keith
I have been tasked with creating a database for our section and am having a little difficulty with planning the relationships between some tables.
We have an internal LAN and I want to create a database to record the configuration. The main things to be recorded are:
IP adresses
Switch Ports
Patching Details
The problem I have is that a computer on the network would record all of the above. It would have an IP address, It would belong to a certain switch port, and it would have a patch number.
A phone would have A patch number but no IP address and wouldnt go into the switch.
A server or UPS for example has a Switch port and an IP address but has no patching detail.
I have played with different designs such as:
sub tables for each of the tables and then a master table where the joins are recorded, but this is not a great solution.
Also I played with having 2 columns in each table recording the relationships if any to the other two, and when the form is updated by the user, a script then makes the same interactions with the other tables, but this gets really complicated when deleting joins etc.
The bonus is that the allocations are fixed. I have
255 IP addresses - FIXED
72 Switch Ports - FIXED
142 Patch Ports - FIXED
If anyone has any suggestions then there is probably a way of doin this that I just havnt thought of but I am really struggling to find the answer lol.
Any help appreciated.
Kind Regards
Keith