Building a mini oracle Application using macros

Building a mini oracle Application using macros ? identify a simple database problem that requires two entity tables and a relationship set table for its [login to view URL] a third entity table may be included that has a one- to- many relationship to one of the other tables. ? Draw an E-R diagram for the application. create the relevant tables using appropriate constraints. populate the tables with at least 10 rows of varied data,such s that they can support a range of querries . develop three macros, each of which has interaction with the user, contains at least two sql querries and produces properly formatted output. ? ? The followings are needed :? ? ? ? ? ? - A brief paragraph outlining the database problem? chosen ? ? ? ? ? - an? e-r diagram ? ? ? ? ? - copies of your create table? statements ? ? ? ? ? - listengs of table data ? ? ? ? ? - Macro listings with accompanying outputs? ? ? ? ? credits will be given for demonstrating good grasp and effective deployment of a range of sql language facilities. Using ORACLE PLS ## Deliverables I would love to have: 1. Mini report or docuemntation ? to explain what is done and how is done 2. Instructions on how to install and run the solution 3. other relevant things needed