Advice on Data Model

[pyrodie18]

Hopefully you guys can help me out. I am in the process of modeling a database that tracks router configurations. One of the many parts it tracks is the configuration of the policy-maps that can be applied to an interface. I'll describe the rules that apply and I'm hoping of you can help me turn that into a data model of some sort that I can create in access.

- An interface CAN have 1 or 0 policy-maps on the interface (that part is easy enough).

- Each policy-map is 1 or more classes of traffic and an associated action to perform on that class. (still easy)

- Each class consists of multiple rules (for lack of a better word). A rule can reference another class, an access-list (consisting of one or more network IDs), a protocol, or an object-group (consisting of one or port numbers).

My problem is how do I model a class and the associated components? My ultimate end product for this part would be the ability to produce a cascading report that shows each of the sub-parts of the policy-map on an interface. I appreciate any help you guys can offer.

Troy

 

[Rx_]

This is not an advertisement or suggestion to buy. It is a tool to help you understand the terms needed for your question. Back in the day, we use to spend an entire day on this for Access training. That was dropped as the course got shorter.
http://www.datanamic.com/dezign/erdiagramtool.html
and then
http://databases.about.com/cs/specificproducts/g/er.htm
ERD Entity Relationship Diagram (or Design)

Look this over then search the web for a short power-point presentation.
The other key term is Referential Integrity (RI).

You are on the right track asking questions. Get some of these terms and concepts down and then use Access to prototype with its tool. Take a screen shot if that helps show the questions.

You are on the right track. This part of the design can shorten your total development by factors.