Category: DBMCS

DBMCS

Databases – lab 4 (Mathematics Computer Science)

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.…