Create and populate object tables to contain instances


Problem

Using as many Oracle object-relational features as possible, model the objects Person, SalesPerson, Applicant, Appointment and Property. You should represent the relationships makes, attends and relatesTo. Foreign keys should not be used! Include at least one member function.

Create and populate object tables to contain instances of the object types. All SQL queries and their outputs should be shown.

Formulate a set of retrieval queries that fully explore the likely functionality of the application area. All SQL queries and their outputs should be shown.

For retrieval queries, each query should be explained in plain English so that I can tell what you were trying to achieve.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Create and populate object tables to contain instances
Reference No:- TGS03302708

Expected delivery within 24 Hours