Member Avatar for jiruiz78

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!

  • 2 Contributors
  • 1 Reply
  • 141 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by campkev
Member Avatar for campkev

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)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.