Description
Use SQL and please do a writeup on your solution. The writeup is an explanation of your logic and how you understand the problem. They need a thorough write up on how you would have solved the problem.
Below is a list of Cell Phone Towers with their relevant locations in Latitude and Longitude. The Lat/long are such that these cells are quite close to one another. We would like you to write a command line program that would allocate a frequency to each of these cells. The frequency range you can use would be 110 to 115, so essentially 6 unique frequencies. Your program will need to allocate the frequencies in such a way that the same frequency cannot be applied to a cell close to another cell as this would introduce interference.
The idea of this exercise is to allocate frequencies in the most efficient manner such that the cells farthest to another cell can have the same frequency in order to reduce interference. You do not need to represent the below in any UI but a graph with your results is expected. Just a command line utility which when run will produce a frequency allocation plan for each of these cells. The program should be generic such that a new list of cells can be provided, and it will work out what the most efficient frequency allocation for these cells should be.
Below is a list of Cell Phone Towers with their relevant locations in Latitude and Longitude. The
Lat/long are such that these cells are quite close to one another. We would like you to write a
command line program that would allocate a frequency to each of these cells. The frequency range
you can use would be 110 to 115, so essentially 6 unique frequencies. Your program will need to
allocate the frequencies in such a way that the same frequency cannot be applied to a cell close to
another cell as this would introduce interference.
The idea of this exercise is to allocate frequencies in the most efficient manner such that the cells
farthest to another cell can have the same frequency in order to reduce interference. You do not
need to represent the below in any UI but a graph with your results is expected. Just a command line
utility which when run will produce a frequency allocation plan for each of these cells. The program
should be generic such that a new list of cells can be provided, and it will work out what the most
efficient frequency allocation for these cells should be.
Cell ID
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Easting
536660
537032
537109
537110
537206
537248
537250
537267
537269
537270
537356
537380
537458
537604
537720
537905
537910
537953
538050
Northing
183800
184006
183884
184695
184685
185016
185020
184783
183451
184140
184927
184727
184495
184134
184057
184591
184441
184295
184245
Long
-0.03098
-0.02554
-0.02448
-0.02415
-0.02277
-0.02204
-0.02201
-0.02185
-0.02234
-0.02206
-0.02052
-0.02025
-0.01921
-0.01725
-0.01561
-0.01273
-0.01272
-0.01216
-0.01078
Lat
51.53657
51.53833
51.53721
51.5445
51.54439
51.54735
51.54739
51.54525
51.53328
51.53948
51.54653
51.54472
51.54262
51.53934
51.53862
51.54337
51.54202
51.5407
51.54023
Purchase answer to see full
attachment
