Design and implement an object relational database in Oracle based on a case study. The design should include user defined types, object tables, object types, sample methods and queries. You are also required to produce a report (max 1000 words) giving a critique of your design and a review of the effectiveness of using the object relational approach for this application.
The assignment should include:
a) A class diagram for the case study application.
b) Documented set of objects, including attributes and methods (objects must include collection types), and tables.
c) At least one basic method and one complex method developed in PL/SQL.
d) Relevant sample data with insert statements for all tables implemented, to illustrate how the database meets the requirements.
e) Relevant sample queries to illustrate how the database meets the case study requirements
f) Your report (max 1000 words) outlining:
· your rationale for the design, explaining how object-relational concepts and types
were incorporated into the design, and
· a critique of this design and review of the effectiveness of using the object-relational approach for this application.
· any technical difficulties you have experienced in implementing the design.