שאלות ותשובות - HW - wet Frequently Asked Questions - HW - wet Вопросы и Ответы - HW - wet أسئلة وأجوبة - HW - wet

		.. (לתיקייה המכילה)

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...