Oracle assistance in Triggers, Procedure and Cursors

[nkumar7377]

Hi ...

I need some assistance in the following question can anyone assist me ...

a) . Design, create and test trigger(s) to implement the following new ‘business rule’
To allow changes to the Company table only on Weekdays (Mon-Fri) between 8am and 6pm,
and on Saturday morning between 9am and 12.00 noon.

b) Design, create and test a combination of triggers and procedures to implement the following new ‘business rule’ :
Students from companies who employ more than 4000 staff (see no_employees field in Company table) are to be placed on the passport program, (by having the passport_programme field in their record set to ‘y’).

This should affect all existing students from existing companies immediately, and then any new students subsequently. The case of an update of a company’s number of employees should also be considered

This section I would like to use proper use of triggers, procedures and thorough testing.

c) Design, create and test a PL/SQL package with procedures to provide the following functionality :

(i) Update the Student table - for all students when an area code changes : change the area-code part of the fax number (first three digits) from an existing code e.g. 609, to another code e.g. 713, for all students affected.

(ii) Update the Student table – for when a student changes company : change the company id that the student represents from an existing id to another existing company id, for any given student identifier.

I would like proper use of parameters, cursors and exceptions, and thorough testing.

Thanks in advance
Kumar