Some General Comments on Homework #2, CSCI 5931A, Fall 1998
 
    Unlike Homework #2, most of you seem to have no difficulty.  It also takes much less time for me to grade than Homework #1.

    The most critical problem is the creation of a table before the creation of the tables it refers to.  For example, if we have R(A, B, C) and T(C, D, E) so that C is a foreign key in A of T(C), then table T must be created before table R.  I think there were three or four students who have created the table H1_Choices before H1_VotingProblem (or something similar).  They should get an error the very first time as H1_VotingProblem may not exist.

    The second problem is forgetting to enforce constraints, especially for the IsCurrent attribute in H1_VotingProblem.  Some also did not turn in table listings.

    All in all, a much higher average than that of Homework #1.  Good Work!

    Since nearly everyone gets it right, I am not posting the solution.