LBSC 690 Sample midterm answers - Fall 97 - Section 0201.

These are fairly concise answers.  More could be said, but more points
couldn't be earned :-)  In many cases there are several possible
answers and I have given only one.

1.  a) A web browser
    b) Web pages
    c) Interpreted

2)      1        |    2       
   A   Question  |   Score       
   B      1a     |   10       
   C      1b     |   10
   D      1c     |    5
   E      2      |   25
   F      3a     |    6
   G      3b     |   -2
   H      3c     |    6
   I      3d     |    6
   J      4a     |    6
   K      4b     |   20
   L    Total    | @sum(B2..K2)

   Column 1 contains lablels.  Column 2 contains values (samples are 
   shown) except A2 (a label) and L2 (a formula).

3) a) B
   b) A
   c) C
   d) D

4) a) Each tuple (line) in the table must contain an entry in that
      field, and no two tuples may have the same value for that field.
      In the case of a multiple field key, the second condition is
      relaxed to require only that no two tuples have the same combination
      of values in the fields that comprise the key. 
    b) Join tables 1 and 3 onEmployeeNumber.  Project the result of
       the join to
       include only LastName, FirstName, PhoneNumber and
       ProfileSpecification, and then restrict the result of the projection
       to retain only those tuples with N35 in the OfficeCode field.