Database Design

This element consists of an OO Database development to showcase the use of Oracle’s object relational features. At the start of the module you will be introduced to the various OO features supported by Oracle which should be incorporated into your development. For the case study provided you are required to: 1. Produce a class diagram for the scenario provided. 2. Implement enough of your design to ensure it incorporates OO features (UDTs, collection types, inheritance, methods, etc); insert some sample data into the tables you have set up; provide data entry scripts for each table; provide 6 outputs that meet some stated requirement of the case study. Your outputs should also be chosen to best demonstrate your OO features. 3. Provide a reflective report (max 700 words) explaining the rationale for your proposed design, any alternative options you considered, and an overall assessment of the efficacy of your database. You must submit the a) A notepad file containing your table creation SQL scripts, suitably annotated. b) A Word file containing: Your Class Diagram; evidence of the successful implementation of your database (screenshots with annotations); your report.