Due: Thursday, August 24

Please upload your solutions using CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

[Reading]

• Chapter 4 of the textbook.
• Chapter 2 of Oracle Database Application Developer's Guide - Object-Relational Features
• Section 3.6 of the JDBC Tutorial

[Object-Oriented DB Design and Implementation]

This is an extra credit assignment.

For this assignment, design and implement the Surveys Database described in Homework 1 using an object-oriented approach with Oracle object and collection types. Your work will be graded in the following aspects:

• (40pt) Overall design and implementation, which include proper use of object and collection types, references, inheritance, and polymorphism.
• (20pt) Primary key, not null, default, and foreign key constraints in object tables.