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