Declare some data types that could be used with the data of your PDA.
You need to choose types such that:
There are at least two methods included among these types; not every
type must have methods, however.
At least one type is suitable as a column type (abstract data type).
At least one type is suitable as a row type (type of a relation).
At least one type is a table type, defined from one of the other
types you declared.
Submit files showing your declarations (don't forget type bodies when there are methods)
and the successful compilation of the declarations.
Remember that the slash is needed to cause compilation.
Declare some relations that could hold data associated with your
Choose relations so that:
At least one relation has a column type defined in (1)
for one of its attributes.
At least one relation should
be of a row type that you defined in (1).
At least one relation should have a table type defined in (1) for one of
At least one reference type (REF) must be involved, either in
your relation declarations or in the types from (1) themselves.
Note that it is possible for one relation to satisfy all these
conditions, but it is up to you how many new relations you choose to create.
Write INSERT statements to populate your new relations from the
data in the original relations of your PDA.
Submit files showing the correct compilation of your declaration and
correct execution of your insertion statements.
Write 4 or more queries on your relations from (2).
Among these queries, you should demonstrate the following features at
Use of methods.
Access of data within a column type.
Access of data within a table type.
Use of a table type's value in a FROM clause.
Explicit derefrencing (using the DEREF operator).
Sumbit files giving your queries and their correct execution.