I'm a newbie in database design but I need to design one. I need to have a record of the devices connected to a network in which certain device could be connected to many devices or any.
In the device's table I've got the following columns:
Device ID(char 25), IP address (char 25), SN (PRIMARY KEY char 20)
All that information is taken from two CISCO commands (CDP show neighbors detail and show inventory) the info is placed in two text files.
The first file has the information of the device I'm connecting to via telnet and looks like this:
SN: FDO1129Z9ZJ Device ID: Barragan_3750 IP: 188.8.131.52
The second file contains information about devices connected to this device, something like this:
Device ID: BIOTERIO IP address: 184.108.40.206 Interface: GigabitEthernet1/0/6 Port ID (outgoing port): GigabitEthernet0/1 SN: P7K08UQ Device ID: LAB_PESADO IP address: 220.127.116.11 Interface: GigabitEthernet1/0/11 Port ID (outgoing port): GigabitEthernet0/1 SN: FNS174202FT Device ID: Arquitectura_Salones IP address: 148.228.1420.11 Interface: GigabitEthernet1/0/9 Port ID (outgoing port): GigabitEthernet0/49 SN: FNS14420420
I'm not sure how to represent the relationship because
Interface (char 25) and
Port ID (char 25) should be relationship's attributes.
Could you help me?