Relationship between Asset, Mac Address and IP address
 

Hello there,

I really need help in defining the relationship between Asset, Mac Address and IP address.

Some background info: I need to develop an IT Asset tracking system for work. This system has to take into consideration all the PCs, printers, external devices and other IT devices as well.

Our assumptions are the following:

• An asset might not have an MAC address
• An asset may have multiple MAC addresses
• A Mac Address may have none or multiple IP addresses

Need some help in this, please let me know how you went around on defining the relationships without having a very complicated database design

Thanks!

Re: Relationship between Asset, Mac Address and IP address
 

tblAsset
AssetID int indentity
other info (type, modelnumber, asset tag number, etc)

tblMAC
MACAddress int unique
AssetID int (Foreign Key)

tblIP
IPAddress int unique
MACAddress int (Foreign key)