Okay this is very complicated (for me), but i need some help on this please.
I am creating a Network Diagram in Visio, along with this I have collected all the Information for every Network Device in my companys organization for each location across the country. I have placed this all in a a Excel spreadsheet, and exported to Access. I will then Export from Access to SQL Server. (I am doing this becuase I understand access better than SQL.) From the SQL Server I will link the data to Visio. The end result, when the user is viewing the Viso HTML they can see the data for each device,(example Device name, IP Address, etc)
Yesterday I approached a DB tech in my company to take a look at my Access database to make sure it was correct and etc. He sggested that I utilize a "Vertical Growing/Dynamic Growth Table." I have never heard of this and he tried to explain it to me but it was way over my head.
Does anybody know about this, and/or know of any sites that I might be able to learn more about it?
Below I have listed my table structure and then the table he created:
tblAddress
LocationID (PK)
Address1
Address2
Address3
City
State
ZipCode
tblContacts
ContactID (PK)
LocationID (FK)
POC1FirstName
{etc}
tblManufacturer
MFGID (PK)
Manufacturer
tblDevice
LocationID (FK)
DeviceName (PK)
Manufacturer
Model
IPAddress
SerialNUmber
SoftwareVersion
NumberOfPorts
SubnetMask
EndOfSubnet
Gateway
Description
Type
Addressing
Capacity
UniqueID
SWServer
VendorID
CPELOC
Channels
PartNumber
MFGID (FK)
In the above table, every location has certain types of devices, but not every device has data for every one of the fileds listed above. Example: a Cisco router contains data in only 5 of the fileds, but a IP DSL MODEM has data in 7 of the fileds. Every device has data in the LocationID, DeviceName, Manufacturer.
Below is the table my database friend created to show me the vertical growth technique that I do not understand:
tblDeviceAttributes
DeviceName (PK)
AttributeName(PK)
AttributeValue
It looks something like this in the datasheet view:
Device Name AttributeName AttributeValue
AZ01Client01 EndOfSubnet ###.###.###.###
AZ01Client01 Type IEE 802.3
CA24Client01 Description Client Lan
CA24Client01 EndOfSubnet ###.###.###.###
CA24Client01 SubnetMask 255.128
Hope this helps, any help would be greatky apprecitaed!
I am creating a Network Diagram in Visio, along with this I have collected all the Information for every Network Device in my companys organization for each location across the country. I have placed this all in a a Excel spreadsheet, and exported to Access. I will then Export from Access to SQL Server. (I am doing this becuase I understand access better than SQL.) From the SQL Server I will link the data to Visio. The end result, when the user is viewing the Viso HTML they can see the data for each device,(example Device name, IP Address, etc)
Yesterday I approached a DB tech in my company to take a look at my Access database to make sure it was correct and etc. He sggested that I utilize a "Vertical Growing/Dynamic Growth Table." I have never heard of this and he tried to explain it to me but it was way over my head.
Does anybody know about this, and/or know of any sites that I might be able to learn more about it?
Below I have listed my table structure and then the table he created:
tblAddress
LocationID (PK)
Address1
Address2
Address3
City
State
ZipCode
tblContacts
ContactID (PK)
LocationID (FK)
POC1FirstName
{etc}
tblManufacturer
MFGID (PK)
Manufacturer
tblDevice
LocationID (FK)
DeviceName (PK)
Manufacturer
Model
IPAddress
SerialNUmber
SoftwareVersion
NumberOfPorts
SubnetMask
EndOfSubnet
Gateway
Description
Type
Addressing
Capacity
UniqueID
SWServer
VendorID
CPELOC
Channels
PartNumber
MFGID (FK)
In the above table, every location has certain types of devices, but not every device has data for every one of the fileds listed above. Example: a Cisco router contains data in only 5 of the fileds, but a IP DSL MODEM has data in 7 of the fileds. Every device has data in the LocationID, DeviceName, Manufacturer.
Below is the table my database friend created to show me the vertical growth technique that I do not understand:
tblDeviceAttributes
DeviceName (PK)
AttributeName(PK)
AttributeValue
It looks something like this in the datasheet view:
Device Name AttributeName AttributeValue
AZ01Client01 EndOfSubnet ###.###.###.###
AZ01Client01 Type IEE 802.3
CA24Client01 Description Client Lan
CA24Client01 EndOfSubnet ###.###.###.###
CA24Client01 SubnetMask 255.128
Hope this helps, any help would be greatky apprecitaed!
