J
Janis
I have a really simple structure regarding a db for an ISP. I need get weekly
utilization figures which I get from Excel but would like to do in Access.
I'm cross posting this from the design section since
no one answered it.
area-->router-->transmistter-->nodeID-->statistics
areaID
area
transmitterID
AREAID
transmitter ports
nodeID
transmitterId
nodes
statisticsID
weekending
internet traffic
t.v. traffic
A tricky part is they split the node if the utilization is over 50% and
move it to a new router. The node is the pedestal that is connected to the
subscribers.
Each node has groupings of 4 letter names, for example
ABCD,EFGH. The related transmitter ports sometimes have the exact same name
ABCD,EFGH. To split the transmitter ,they take one port, for example, ABCD
and call it A, ABCD-A and
ABCD-B to show the split on the transmitter. They take the first node ABCD
corresponds to transmitter ABCD-A and the 2nd EFGH and it corresponds to
transmitter ABCD-B to split it if the utilization is over 50%. Sometimes
there are more nodes than transmitter ports the ports and nodes aren't
always matching in number or names.
there is a one to one relationship from the transmitter to the nodes. The
nodes are all one group and the ports are all one group hence one to one.
When it gets over 50% it gets split. Some of the nodes get attached to a new
transmiter as mentioned above. It is still unique one to one relationship
for each area -- router--transmitter to nodes. Its just the transmitter has
an A or B extension name showing it was split.
I could do a one to many from each port to each node but that wouldn't be
worth all the data input and it doesn't seem to be needed since there still
is maintained a one to one relationship from the ports to the nodes even if
the groupings are moved.
QUESTION:
Is this better to do in Excel? I get the Excel report from a nAccess db
that gets the data from SQL. If I can get to the SQL db then I could do the
queries and get the data. The problem with Excel is a new column is added
weekly for the nodes over 50% for both tv and internet. Then they have to
find which nodes on the tv side are also on the internet side so they can be
advised and try to do the work together. The user has to do all these
vlookups to find out which nodes are still over 50%. It would be easier in a
database at least . They also have to clean the data each week. It seems to
be a real mess but I want to be sure my relationships are right before I try
it.
any advice would be appreciated.
utilization figures which I get from Excel but would like to do in Access.
I'm cross posting this from the design section since
no one answered it.
area-->router-->transmistter-->nodeID-->statistics
areaID
area
transmitterID
AREAID
transmitter ports
nodeID
transmitterId
nodes
statisticsID
weekending
internet traffic
t.v. traffic
A tricky part is they split the node if the utilization is over 50% and
move it to a new router. The node is the pedestal that is connected to the
subscribers.
Each node has groupings of 4 letter names, for example
ABCD,EFGH. The related transmitter ports sometimes have the exact same name
ABCD,EFGH. To split the transmitter ,they take one port, for example, ABCD
and call it A, ABCD-A and
ABCD-B to show the split on the transmitter. They take the first node ABCD
corresponds to transmitter ABCD-A and the 2nd EFGH and it corresponds to
transmitter ABCD-B to split it if the utilization is over 50%. Sometimes
there are more nodes than transmitter ports the ports and nodes aren't
always matching in number or names.
there is a one to one relationship from the transmitter to the nodes. The
nodes are all one group and the ports are all one group hence one to one.
When it gets over 50% it gets split. Some of the nodes get attached to a new
transmiter as mentioned above. It is still unique one to one relationship
for each area -- router--transmitter to nodes. Its just the transmitter has
an A or B extension name showing it was split.
I could do a one to many from each port to each node but that wouldn't be
worth all the data input and it doesn't seem to be needed since there still
is maintained a one to one relationship from the ports to the nodes even if
the groupings are moved.
QUESTION:
Is this better to do in Excel? I get the Excel report from a nAccess db
that gets the data from SQL. If I can get to the SQL db then I could do the
queries and get the data. The problem with Excel is a new column is added
weekly for the nodes over 50% for both tv and internet. Then they have to
find which nodes on the tv side are also on the internet side so they can be
advised and try to do the work together. The user has to do all these
vlookups to find out which nodes are still over 50%. It would be easier in a
database at least . They also have to clean the data each week. It seems to
be a real mess but I want to be sure my relationships are right before I try
it.
any advice would be appreciated.