[ Home | Lab | New Students | Courses | Research | Publications | Activities ]

Back to Courses and Activities of Local Interest

Back to CSC 691D Home

Homework 2 for CSC691D: Advanced Database Management

  1. (20 points) Consider a university student records and registration system. Describe a simple workflow in this setting, which involves about 5 main steps.
  2. (10 points) Describe some integrity constraint that might be violated because of some exception conditions, and your contingency strategies to restore consistency.
  3. (10 points) Describe the above workflow as a ConTract with the key steps and dependencies among them.
  4. (10 points) Express two of the dependencies in the event algebra, and give a sample run of executing them.
singh@ncsu.edu