 |
.. (לתיקייה המכילה) | |
In antennaLoadReport , when do you print 'EMPTY'?
| When there is no record in 'PhoneAntenna' that relate to the specified aid. |
I cellReport, in case we encounter a relevant call with NULL end_time,
should we print a line with an empty time and an empty price for this call, or
should we just print no line for this call?
| Do not print a line for this case |
Social Report
|
Few clarifications: 1. The base of the induction is for distance of zero - in which the return value should the customer himself. For every distance > 0 (induction step) - the output should be all the customers that retrieved or called a customer in distance i-1 AND the customers in distance i-1. 2. Therefore - the output of the query will never by EMPTY (this is a mistake in the definition). 3. We see no apparent reason to use view. You can use view only if it is used for multiple queries - either of the same kind or different kinds. Remember that in order to get all the points - you should use one query for the data retrieval (other the inputs checks). 4. Valid values for the query are [0, 7] (zero to seven). |
In setCell, what happens when the phone does not belong to any antenna?
(there is no null end time)
| only add a new line to phoneAntenna (you do not need to update a previous record). |
Can someone call himself?
| Yes |
When performing any query regarding the time - do we need to include start-time and end-time?
| You should include start-time and end-time. We will not test this case, but for conformity - please do so. |
I get an error:
"./wet: error while loading shared libraries: libpq.so.5: cannot open shared object file:
No such file or directory"
How can I solve this?
|
Look at PostgreSQL.ppt on the course site. The path /usr/local/pgsql/lib should be added |
In startCall, should we that the calling phone is busy?
| No |
In cellReport, can we assume a client phone always has a rate?
| yes |
In the antennaLoadReport query , what are the phones we need to count for
certain time T?
|
phones that were connected to the antenna before time T (join time <= T) <br>
and were disconnected after time T (leave time > T) or they were never disconnected |
Should we sort quesries 4 and 5?
| No |
In setCell and antennaLoadReport:
Can number of phones that belong to one antenna be more than antenna's quota
(so that the load will be more then 100%)? Should we check that in setCall
function?
| Assume it can. You do not need to check for it. |
In antennaLeadReport, if a phone has left the antenna in time T and
other phone has been connected to this antenna in the same time T,
what should we print?
|
You should print 2 lines |
What do we need to submit?
| A single c file (including main() ) through the web-site |
When do we print '\n'?
| When ever you need to pring an error report: ILL_PARAMS, PHONE_BUSY... |