I am trying to model a cable mapping for devices. Each device has multiple cards, and each of those cards has multiple ports. Since both the number of cards and ports vary, I am confused on how to establish the correct normalized form and relationships that would address one device record having an arbitrary number of cards and those cards having an arbitrary number of ports. Any thoughts?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This sounds like a really simply one-to-many relationship.
For SQL Server, I would write this like:
This allows a
The 3 tables can be
If you use
you get these results:
This is an image showing the table relationships: