As a Database Engineer, you've been given the freedom to choose between using triggers and procedures. Provide an explanation of what triggers are and when it would be best to use them.
As a
Introduction
A DBMS typically includes several components, including a data dictionary, a database engine, a query processor, and a security manager. The data dictionary stores metadata about the database, such as the names of tables, columns, and relationships between tables. The database engine is responsible for storing and retrieving data from the database, while the query processor allows users to retrieve and manipulate data using SQL (Structured Query Language) or another query language. The security manager controls access to the database, allowing users to only access data that they are authorized to view or modify.
Step by step
Solved in 3 steps
