CS125 Project, Part 6

NOTE NON-STANDARD DUE DATE: Monday, Nov. 24, 2002

Part 6 of Your Project

This part of your project involves one of the object-relational features of PostgreSQL. You should refer to documentation as needed. Please submit a tar or zip file as before, but with "p6" instead of "p5".  

  1. Create a new table in your project schema that inherits from one or more of your pre-existing relations.  Show the table creation SQL statement.

  2. Write several queries to exercise the functionality of the new table.  You should provide the query and result for at least one instance of each of the following:

  Most of the material for the project descriptions and assignments has been taken from Professor Ullman's website.