(a) What is a DBMS? Explain the advantages and disadvantages of DBMS. (b) Why do we use a trigger? Write a trigger that inserts the timestamp in…

(a) What is a DBMS? Explain the advantages and disadvantages of DBMS.

(b) Why do we use a trigger? Write a trigger that inserts the timestamp in another table as soon as an insert or update is done in a table.

(c) Consider the schema -

employee (id, name, salary),
equipment (id, name, price),
hire (employee-id, equipment-id),

(i) Draw the ER diagram for the above.

(ii) Write the SQL query to show the name of the employee who hired the maximum number of equipment.

(d) Compare and contrast among the following normalization: 2NF, 3NF and BCNF.