•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 423,882 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,191 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 3746 | Replies: 1
 |
•
•
Join Date: Apr 2006
Location: Australia
Posts: 10
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
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:
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!
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!
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
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)
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)
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
apple avatar backup blog breach companies creative daniweb database defcon design hacker hackers hate hoax howto illustrator iphone jbennet kevin rose leopard mac macs medicine microsoft news normalization os os x osx pc photoshop print pro research secret security serunson server sql survey tiger toread tutorials unix vista vulnerabilities web wifi windows
- Get MAC Address (C#)
- Looking for an Asset Tracking system (PHP)
- changing mac address (Networking Hardware Configuration)
- MAC Address (*nix Software)
Other Threads in the Database Design Forum
- Previous Thread: help with normalization of Book and order details
- Next Thread: Data Flow Diagram
