Computer Science 455

Remaining Exercises

Due: Various

Exercise A (20 pts.)

Due: Friday, April 20

Return to the order-invoice exercise for this exercise.

  1. Create a data entry form for a new customer. Print the form (the print command works if you have the form canvas open and selected).
  2. Create a menu (either using menus or buttons) which will give the user the option of
    1. Going to the data entry form
    2. Printing the report (done in an earlier exercise - use the same report)
    3. Exiting the application

    Forms should have some additional trim beyond what is provided by default - i.e., make the forms attractive. You should turn in

  3. Printed copy of both the data entry and menu forms
  4. Printed PL/SQL code to implement the menu options (the print command works with the PL/SQL editor highlighted).

Exercise B (10 pts.)

Due:  Monday, April 23

Work the following four problems using the full relational algebra. Please follow the guidelines given for the first algebra assignment (first assignment of the term):

  1. Find the names of parts that are either blue or red.
  2. Find the names of parts used on London projects (i.e., on some London projects).
  3. Find the names of parts used on no London projects.
  4. Find the names of parts used on all London projects (for all).

Please place your solution to this problem in the home directory of your VAX account under the name algebra.com.

Exercise C (10 pts.)

Due Tuesday, April 24.

Please note:  This is the date of our third hour exam. This exercise will not be picked up until Thursday (at the earliest), but you need to work these problems in advance of the exam (there will be questions of this sort on the exam).

Work the problems given in Exercise B in the relational calculus using the Lisp relational calculus interpreter. Place the solution (with appropriate documentation) in your handins folder under the name relcalc.cl.

Any questions? Please let me know. Many thanks!