.. (לתיקייה המכילה) | ||
Should we check whether the input to a function isn't NULL? | |
No. You can assume that NULL values won't be provided as input to any function. However, there could be NULL String fields in a given object. |
What is considered "Java" and what is considered "SQL commands"? | |
Any comparison or any calculation performed on the data out of an SQL command is considered Java. NOTE: The only exception to this rule of thumb is checking the number of results returned from executeUpdate and parsing executeQuery. |
If there is a "bad" input that can result in more than one error (e.g ALREADY_EXISTS and BAD_PARAMS), what should be returned? | |
The return values priorities are as written in the pdf from top to bottom. |
Is it true that we must draw an ERD? | |
No, but I do expect you to draw a scheme of your tables and views, explain what you did and why. In addition, explain the logic behind every function, what queries you used and why. |
In confirmStanding function, is it possible for an athlete to win 2 (or more) medals in the same sport? | |
No, it is not. In case confirmStanding is called again, it should modify the previous call's result. |
Can two different athletes win the same medal at the same sport? | |
Yes, they can. |
When athleteLeftSport is called on an athlete, does it also remove his medals (if active and won) or his payment (if not active)? | |
Yes. |
In "getMostPopularCity" do we need to consider the counter mentioned at each sport ("Athletes counter") or as it is not updated on athlete deletion we should not? | |
It is required to use the counter as defined in the assignment, deletion of an athlete will not effect the number of participants in the sport! |
In "athleteDisqualified", what should I return if the athlete participate in the sport but did not win anything? | |
You should do nothing and return OK. |
In "getMostPopularCity", do we need to consider the "athletes counter" or the actual number of athletes participating? | |
You need to use the athletes counter as defined in the assignment. i.e if an athlete is participating in 2 different sports (both in Haifa), we consider the average of Haifa as 1. |
In "getSportsRecommendation", do we need to order by the amount of "close users" before sports' ID? | |
Yes. |