SQL TRIGGERS AND PROCEDURES
There is a sample database which needs to be installed on Workbench. From there enhancements and modifications need to made to the database using triggers and stored procedures. 4 advanced triggers and 4 advanced proceduresThere is a sample database which needs to be installed on Workbench. From there enhancements and modifications need to made to the database using triggers and stored procedures. 4 advanced triggers and 4 advanced procedures need to added. Screen shots of triggers and procedures need to be present showing coding and executed and working. After that an evaluation of around 500 words need to be carried out justifying the choice of procedures and triggers and how they have improved the database.
need to added. Screen shots of triggers and procedures need to be present showing coding and executed and working. After that an evaluation of around 500 words need to be carried out justifying the choice of procedures and triggers and how they have improved the database.
need to added. Screen shots of triggers and procedures need to be present showing coding and executed and working. After that an evaluation of around 500 words need to be carried out justifying the choice of procedures and triggers and how they have improved the database.
