Marking scheme for Assignment 1
-------------------------------

Hello all,

Below are some guide lines for marking Assignment 1.

Question 1 (40 points)
----------

  - For each missing aggegation take off 3 points.
  - For each missing weak entity (both the entity set and the 
                         identifying relationahip) take off 3 points.
  - For each missing key constraint take off 2 points.
  - For each missing total participation take off 2 points.
  - For each missing entity set take off 1 point.
  - For each missing relationaship set take off 1 points.
  - For each missing indication of key attribute take off 1 point.
  - For each missing indication of partial key attribute 
                         take off 1 point.
  - For each missing ISA hierarchy between ACCOUNT on one side and 
               SAVINGS and CHECKING on the other take off 3 points.
  - For each missing table, take off 1 point. 
  - For each missing primary or foreign key constraint take off 
               0.5 point.
 
 Remark: 1) Don't take off any mark for missing the ISA hierarchy 
            between EMPLOYEE on one side and PER-BANKER and LOAN_OFFICER
            on the other.   
         2) Don't take off any mark for missing attributes of entities.
         3) Be aware of the fact that the students may have different, but 
            correct diagrams or tables, in which case you should give them 
            full marks. 


Question 2 (30 points)
----------

  The relational agebra and calculus have each 2 points 
  (1 for the calculus part and one for the algebra part).

  The SQL constraints have each 2 points, except the last one (the 
trigger) 
  that has 3 points.      

  The SQL queries have each 2 points, except the frst one that has 3 
points.

In general, do the following:
   
    - Give 3/4 of the marks if at half of the solution is there. 
    - Whenever you see that the student has the right idea but the syntax 
      is slightly wrong, give full marks.
    - Be leniant on the syntax (particularly on the trigger). 
    


Question 3
----------

See guide lines for Question 1.