MySQL

Database Systems

Downloaded query here(https://file.io/XyolbpVi0dYb)

- Explain the Concept of a View object Updateability and give an example of using a View Updateability for the case below

- Explain the concept of database triggers in RDBMS

- Add a CCLIMIT Column on Customers with type number and create a trigger database send message as follows:

values ('R0001', 'B5414DZG', 'B001', '1122334455', '2022-10-26', '2022-10-27', '2022-10- 31 ', '3000000'), ('R0002', 'B1554WZG', 'B001', '2211442244', '2022-10-13', '2022-10-16', '2022-10-21', '5000000' select*from Rental_Reservation; insert into Car values ('B1554WZG', 'S', 'Toyota', '', '8'), ('B5414DZG', 'C', 'Daihatsu', ', '8'), ('B11440KB', 'P', 'Ferrari', ', '4') select*from Car