Create database back-end functionality and front-end for an application of your choice using Oracle Database. For example an e-commerce solution,air line's official website,an insurance quotation calculator, etc.(Scope accordingly.) Tasks will include: Interface Design, database design and implementation, data creation, testing and presentation.

1. Deliverables

a. Functional Front End Interface for your projectand presentation.............................................[3%]

b. Script file(s) (.txt or .sql code) which should contains all the commands to create the above tables, sequences, indexes, triggers, and functions when it is executed (this will create the same objects that exist for your project on the server )................................................................... ................[10%]

c. Ms Word or Pdf file with group members, problem domain description, ER diagram and print screens of execution of front end with tables content (using programming units)

2.Contents of your Database: (to be included in the script file(s))

2 marks- Tables (data, lookup, audit/log tables) , constraints.

- Minimum - 5 and Maximum 10. You can think and build these tables according to web application project (COMP229) or as an independent database project. (Scope accordingly.)

1 marks - Sequences

a. Create one sequence

b. Use it to insert sample data

c. Use it to update table(s)

0.5 marks - Indexes

a. Search is one of common functionalities, index plays a critical role in search

b. create few (min 2) indexes for those tables where search is performed frequently

2 marks - Triggers

For behind the scenes table entry/updating, you need to create 2 triggers.

2 marks - Procedures

You need to define at least two procedures so carrying out common operations on database.Include exception section, using cursors.

1 marks - Functions

You need to define at least two functions so carrying out common operations on database.Include exception section.

1.5 marks - Packages

a. Use at least two procedures (could be previously created ones)

b. Use at least two functions (could be previously created ones)

c. Include global and private variables / constructs.

d. Use TYPE attribute and/or ROWTYPE attribute whenever it is appropriate

WE HAVE CREATED THE TABLES, PROCEDURES, FUNCTIONS , AND SEQUENCE INITIALLY AND WE NEED HELP IN CREATING TRIGGERS & PACKAGES

I CAN SEND THE TABLES, PROCEDURES, FUNCTIONS AND SEQUENCE ON THE COMMENT SECTION .