ASSIGNMENT #2

                                Due Monday, April 17, 2000


      1.   Do Exercise 3.4.5 in the text.

      2.   Do Exercise 3.4.6 in the text.

      3.   Consider a database for describing births. At a birth, there is one  baby
           (twins would be written as two births), one mother, any number of nurses,
           and any number of doctors. For every baby, there is a unique mother.  For
           every  combination of a baby, nurse and doctor, there is a unique mother.
           For every combination of a baby and a mother there is a unique doctor.

           a) Design a relational database schema for this database application.

           b) Using the stated assumptions and others that you need  to  make,  list
              all  the  nontrivial  functional  dependencies  that  hold  among  the
              attributes.

           c) Determine the primary key for the relation.

           d) Find a decomposition of the database into  third  normal  form  (3NF),
              having a lossless join and preserving dependencies.

           e) Find a lossless join decomposition of  the  database  into  Boyce-Codd
              Normal Form (BCNF).

           f) List all the nontrivial multivalued dependencies that hold  among  the
              attributes.

           g) Find a lossless join decomposition of the database into Fourth  Normal
              Form (4NF).

      4.   Do Exercise 4.1.3 (a, c, e, g).