Lab 4. Procedures, functions, views, triggers, indexes
- assigned: weeks 9/10; due: weeks 11/12
On the database created for lab 1:
1. implement a stored procedure for the INSERT operation on a table; the procedure’s parameters should describe the entities / relationships in the table; the procedure should use at least 2 user-defined functions to validate certain parameters;
2.…