Please kindly go through the questions and answer . i need you to provide answer for Task 2 . i will need the screenshot as well .

Triggers

Task 2

For Accounts table, balance should not be less than 500.

Please kindly go through the questions and answer. i need you to provide answer for Task 2. i will need the screenshot as well. Triggers Task 1 . Create Table Emp (Eid, Ename, Salary, Dno) (Salary, Dno allow nulls} Solution. Create table empc Eid integer primary key not null Ename char(20) not null, Salary integer Dno varchar integer ) 2. Create Table Deptsal (Dno, totalsalary, Depcount). Dno varchar integer primary key total salary integer de count integer )) I 3. Create Trigger to update totsalary if New employee is added, deleted or slary of an employee is updated. on deptsal for each row begin declare totalsalary integer set totsalary salary + increment B Task 1. Create Table Emp (Eid. Ename, Salary. Dno) (Salary, Dno allow nulls) Solution Create table empc Eid integer primary key not null, Ename char(20) not null, Salary integer. Dno varchar integer )) 2. Create Table Deptsal (Dno, totalsalary. Depcount). Dno varchar integer primary key total salary integer, de count integer 3 I 3. Create Trigger to update totsalary if New employee is added, deleted or stary of an employee is updated. on deptsal for each row begin declare totalsalary integer. set totsalary = salary + increment Task 2 For Accounts table, balance should not be less than 500. Please kindly go through the questions and answer. i need you to provide answer for Task 2. i will need the screenshot as well. Triggers Task 1 . Create Table Emp (Eid, Ename, Salary, Dno) (Salary, Dno allow nulls} Solution. Create table empc Eid integer primary key not null Ename char(20) not null, Salary integer Dno varchar integer ) 2. Create Table Deptsal (Dno, totalsalary, Depcount). Dno varchar integer primary key total salary integer de count integer )) I 3. Create Trigger to update totsalary if New employee is added, deleted or slary of an employee is updated. on deptsal for each row begin declare totalsalary integer set totsalary salary + increment B Task 1. Create Table Emp (Eid. Ename, Salary. Dno) (Salary, Dno allow nulls) Solution Create table empc Eid integer primary key not null, Ename char(20) not null, Salary integer. Dno varchar integer )) 2. Create Table Deptsal (Dno, totalsalary. Depcount). Dno varchar integer primary key total salary integer, de count integer 3 I 3. Create Trigger to update totsalary if New employee is added, deleted or stary of an employee is updated. on deptsal for each row begin declare totalsalary integer. set totsalary = salary + increment Task 2 For Accounts table, balance should not be less than 500