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

Given the boys and girls names tables you have to do the following:

  1. Select the 5 most common boys names.
  2. Select the 5 least common girls names.
  3. Select a union of the 5 most common boys name and the 5 most common girls names.
  4. Select a union all of the 5 least common boys name and the 5 most common girls names.
  5. Find the unisex names ie the names that are boys names and also girls names. I want at least 5 different ways of doing it ;-)
  6. Find all the boys names that are not also girls names. Give me two solutions. Try to argue the plausibility of your results.