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. 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
