/oracledatabase

📦Oracle Database Design

Primary LanguagePLSQLMIT LicenseMIT

Oracle Database


This Database Design is done on Oracle with APEX as a GUI for easier implementaion of table, views and triggers. Altogether, there are 11 tables created

  • Volunteer
  • Skill
  • Vol_Skill
  • Project
  • Task
  • Skill_Task
  • Task_Activity
  • Project_Contact
  • Travel_Booking
  • Travel_Option
  • Project_Location
    After the table 3 views and 2 triggers were created. Using APEX, I was able to create individual forms and pages for all the tables where data can be edited easily and simply. Using APEX bar graphs, pie charts and calendar were also created to visualize the graph much more easily.
    A Real Production Application can be made with this codebase if contributors are there to help. Everybody is welcome!!

Status


GitHub license

Download and Installation


To begin using this project, follow the following options to get started:

Usage


  • Run this project on Oracle Database 11g

Features


  • Made with Oracle and APEX
  • View and Triggers
  • Individual Pages for each table
  • Graphs & Charts

Documentation


  • The Full Documentation is tagged alongside the Readme.md File

Contribute


Support


If you are having issues, please let us know. I have a mailing list located at: sulabh4@hotmail.com

Copyright and License


Copyright 2018 Codexponent. Code released under the [MIT]license.