(MYSQL DB Triggers)

CREATE TABLE `customer` (

`Customer_ID` int NOT NULL AUTO_INCREMENT,

`Customer_Name` varchar(50) NOT NULL,

`Customer_Surname` varchar(45) NOT NULL,

`Customer_Gender` varchar(6) DEFAULT NULL,

`Customer_CardNo` bigint DEFAULT NULL,

`Customer_PhoneNumber` bigint NOT NULL,

`Customer_Address` varchar(50) DEFAULT NULL,

PRIMARY KEY (`Customer_ID`)

)

CREATE TABLE `gym_manager` (

`Manager_ID` int NOT NULL AUTO_INCREMENT,

`Manager_Name` varchar(50) NOT NULL,

`Manager_Surname` varchar(45) NOT NULL,

`Manager_Salary($)` varchar(9) DEFAULT NULL,

`Manager_StartingDate` date DEFAULT NULL,

`Manager_PhoneNumber` bigint DEFAULT NULL,

PRIMARY KEY (`Manager_ID`)

)

Can you write 2 simple triggers examples in accordance with the above tables