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!!
To begin using this project, follow the following options to get started:
- Clone the repo:
git clone https://github.com/codexponent/oracledatabase.git
- Fork, or Download on GitHub
- Run this project on Oracle Database 11g
- Made with Oracle and APEX
- View and Triggers
- Individual Pages for each table
- Graphs & Charts
- The Full Documentation is tagged alongside the Readme.md File
- Issue Tracker: https://github.com/codexponent/oracledatabase/issues
- Source Code: https://github.com/codexponent/oracledatabase
- Contributors: https://github.com/codexponent/oracledatabase/contributors.txt
If you are having issues, please let us know. I have a mailing list located at: sulabh4@hotmail.com
Copyright 2018 Codexponent. Code released under the [MIT]license.