CIS 671, Winter 2002, Exams and Assignments

Homework Assignments and Solutions

• Homework 0: Partial Map, Binary Search Tree and Hash Table Review
  Due: In class, Friday, January 11 (CORRECTED).
  • Solutions:

• Homework 1: SQL Review
  Due: Midnight, Friday, January 18 (CORRECTED).
  • Solutions:
    Foreign Keys and Relational Integrity
    
    SQL Solutions .

    Postscript
    PDF

• Homework 2: MS Access Reports and Forms
  Due: In class, Wednesday, January 30.

• Homework 3: Review - Entity-Relationship Design and Functional Dependencies
  Due: In class, Monday, January 28.

• Homework 4: Object Definition Language (ODL)
  Due: Wednesday, February 6, start of class.
  Due: Extended to Friday, February 8, start of class. Postscript PDF

• Object Query Language (OQL)
  • To discuss in class Wednesday, 2/6. Not to be handed in. Write OQL queries for the problems in 7.18, p. 235. These queries refer to the COMPANY database used in the text. A UML schema is shown in Fig. 4.11, p. 94. The ER schema is shown in Fig. 3.15, p. 65. The relational schema and sample data are shown in Figs. 7.5 and 7.6, pp. 204-205. An ODL schema is shown here. Postscript PDF
  • Homework 5: To be turned in. Postscript PDF
    Due: Start of class, Monday, February 11.
    • Question 1: Schema diagram       Postscript       PDF
    • Solutions question 2

• Homework 6: Object-Relational Database Systems - Abstract Data Types (ADT's) in SQL:1999 (SQL3)
  Due: Start of class, Friday, February 22.
  • Solutions

  Homework 7 : OLAP
  Due: Start of class, Friday, March 8.

  • Solutions       Postscript       PDF

  Homework 8: Data Mining and Active Databases
  Due: Start of class, Monday, March 11.

  • Solutions       Postscript       PDF

  Homework 9: Disks, Files and B-trees
  Skip B-tree problems, problems 3 and 4       Postscript       PDF
  Due: Start of class, Friday, March 15.

  • Solutions       Solutions from problems 3-5. Problems 1 and 2 will follow. Postscript       PDF