Graded Homework Problems


Individual Project
Due: Tu., May 2, 1:00p
(Problem1 only)

Problem 1 --- Object-Oriented Databases
a. Take the E/R diagram from Exam0 (the one that deals with University Registration), and generate an "equivalent" ODL-Schema from it that expresses the same application semantics. Add 2-3 methods to your ODL-schema definition.
b. Write 3-4 non trivial OQL queries of your own choice, and indicate what they compute.
c. Compare deloping applications with OQL/Java (or OQL/C++) with developing applications with PL/SQL. What major differences do you see? What are the advantages of each development platform? Which platform do you personally prefer and why? Remark: Limit your answer to question c to 100-150 words.

Problem 2 --- Transaction Management (Ungraded Homework Problem)
Solve problem 18.4 in the textbook!