|.. (לתיקייה המכילה) .. (parent folder) .. (родительский каталог) .. (المجلد المحتوي)|
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)?
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?