In Problem 1, some of those things are not ``updates,'' especially part (c).
Answer: Sorry-- the proper term is ``modifications,'' which include inserts, deletes, and true updates. Also, part (c) involves a table creation, but then requires some modification.
What does 15 pts. have to do with part 1 of the PDA?
Answer: Sorry again. That was an artifact of the old grading system. We'll grade this PDA on a 1-10 scale as always.
I'm having trouble interpreting ... (some question, usually #5)
Answer: The questions look meaningful to the instructor, and in each case the proper interpretation is simpler than the various interpretations that have appeared in messages to cs145-help. If you really can't come up with a simple, sensible interpretation, you are welcome to discuss the matter in office hours.
Do we have to come up with the most efficient solution to an SQL problem.
Answer: No. In fact, the running time of your query is the responsibility of the DBMS, and a good DBMS will run all equivalent queries in the same way. The purpose of using a very high-level language like SQL as the query language is to save programmers the trouble of doing their own optimization. Rather, you should write queries in the manner that is most convenient for you.
I created indexes and they only slow down the query.
Answer: That could happen for several reasons.