Description
Write a trigger that increase (10%) salary of your employees in your company and show salary difference of employees after the salary increment. The employee table details are given as follows:
Employee (name, payment, empid)
2- (12.5 points)
Write a trigger that maintains referential integrity for on delete cascade. Using the trigger, when a department is deleted, the employees on that department also have to delete. The details of the tables are given below:
Employee (Name, Age, Address, Depid)
Department (Depid, Depname)
3- (25 points)
What are the advantages and disadvantages of using NoSQL databases? Explain each of them.
4- (25 points)
Give characteristics of blockchain databases. Explain each of the characteristic.
What are the differences between blockchain databases and traditional databases?
5- (25 points)
What are the advantages and disadvantages of using a graph database?
What are the characteristics of Neo4j graph database?
