Question: CREATE VIEW Statements. o Produce a view that returns the sessions in the future and rejects any attempt to insert or update sessions in the

CREATE VIEW Statements. o Produce a view that returns the sessions in the future and rejects any attempt to insert or update sessions in the past. o Write a simple statement to test rejection. 3. CREATE PROCEDURE Statements. o Produce a procedure that assigns a new schedule for a given course. The procedure should accept a course code & start date as arguments then schedule each of the given courses modules on consecutive (working / week) days. The start date must be at least a month in the future otherwise, a suitable error should be raised. o Tips .. CURSOR, LOOP, SIGNAL 4. CREATE TRIGGER Statements. o Produce an audit trail (in a separate table) that records the current username, system date & grade change when someone attempts to update a delegates grade.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!