Success

Notes

Error

 
 
 
 
Budget

Small project <800

Posted on

2012-03-05 19:14:57.0

Buyer:

ilo***

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now

Description

 

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.