SQL DATABASE -- 6
Budget: $10 – $30 CAD
Contents of your Database: (to be included in the script file):
- Tables with data: Minimum 4 and Maximum 10.
- Sequences: You need to create at least one sequence and use it.
- Triggers: For behind-the-scenes table entry/updating, you need to create at least 2 triggers
- Procedures: You need to define at least two procedures so carrying out common operations on database.
- Functions: You need to define at least one function so carrying out common operations on database.
You must also include a copy of your project on oracle1 with the group schema:
- Tables with data: Minimum 4 and Maximum 10.
- Sequences: You need to create at least one sequence and use it.
- Triggers: For behind-the-scenes table entry/updating, you need to create at least 2 triggers
- Procedures: You need to define at least two procedures so carrying out common operations on database.
- Functions: You need to define at least one function so carrying out common operations on database.
You must also include a copy of your project on oracle1 with the group schema: