Assignments

  1. All hand-ins consist of ONE, repeat ONE compressed zip/jar/tgz-archive.
  2. An archive consists of one or more text files and/or code files.
  3. Text processed files must be pdf-files.
  4. Code files must be have their native filename extension, eg. x.java, y.html, etc.
  5. Put your academy login-id into the filename, and an "_7" to number the file individually, eg: EAANILA1_7.zip
  6. Put the token dbxml somewhere in the subject, eg: Assignments dbxml
  7. Mail it to nml@acm.org

  1. Make the (slight) changes to the above diagram that are sufficient to do the two selects shown in #3, and #4. Submit the diagram as a png file (b.png).
  2. Create and populate a database with testdata sufficient to do the two selects shown below. Submit the sql declarations as an sql text file (b.sql).
  3. Retrieve a list of the colors that exists in both paper and plastic. Add the necessary declaration(s) to b.sql.
  4. A list of the colors that only exists in paper. Add the necessary declaration(s) to b.sql.