question archive Create database back-end functionality for an application, for example and e-commerce solution, an insurance quotation calculator, etc
Create database back-end functionality for an application, for example and e-commerce solution, an insurance quotation calculator, etc
Subject:Computer SciencePrice: Bought3
Create database back-end functionality for an application, for example and e-commerce solution, an insurance quotation calculator, etc.
1. Deliverables
Script file (.sql file) which should contains all the commands to create the above tables, sequences, indexes, triggers, procedures and functions when it is executed.
2. Contents of your Database: (to be included in the script file)
- Tables (data, lookup, audit/log tables)
- Minimum - 5 and Maximum 10. You can think and build these tables according to web application project (COMP229) or as an independent database project if you are not taking course - COMP229 in this term.
3 marks
- Sequences: at least one sequence and use it especially for those tables that are updated
2 marks
- Indexes
- Search is common functionality performed on tables. You need to create few indexes
for those tables where search is performed heavily.
2 marks
- Triggers
- For behind the scenes table entry/updating, at least 2 triggers
2 marks
- Procedures
-- You need to define at least two procedures so carrying out common operations on database.
More info about them can be discussed in the class.
4 marks
- Functions
-- You need to define at least one function so carrying out common operations on database.
2 marks
More info about them can be discussed in the class.
You may also include a copy of your project on oracle1 with the group schema if doing with COMP229.
Note: There should be minimum ten records (10 insert statements for data tables) and five records (for reference/lookup type tables). You should be populating your tables with meaningful data.
