Unanswered: Data base design for data base of telco companies
I am developing a software for an exchange. The basic purpose of the software is to calculate call rates for the call made from diffirent telco lines to land line and mobile. Currently there are outgoing lines of five telcom companies.
My job is to develop such a system that can accomodate/calcualte the call rate from any line of any telecom comapny. For example
1. a Call made from a company A line to a compay B line
2. a call made from company B line to foreign country.
Not sure what you are looking for with this post? I have worked for both for mobile telecoms company as well as VOIP solution provider. In the case of your problem above, you will need to determine the source phone number, the route (in cases where you may have one or more) and the destination and of course the duration of the call. With this you should be able to calculate the cost per phone call.