Create the required tables and triggers for the following BITS Database:

a$.$ Create a table Student with name, register number, courses $($SDP$,$ SIA, DD$),$ total and average. $1$ mark

b$.$ Create table Result with attributes register number and result. $1$ mark

c$.$Create a trigger that inserts data into the result

table as soon as data is entered in the student lable. The result of the stud

obtains more than $40$ marks in all courses. $2$ marks

d$.$Insert data into the table Student. $1$ mark

$4522-890$

$+$

e$.$Create table Class with attributes register number and semester. $1$ mark.

f$.$ Create a trigger that updates the attribute semester in the Class table by incrementing the value by one whenever the data se

table is updated and the student has passed in all the subjects. $2$ marks

g$.$ Give the sample input and the contents of the tables to show the effect of the triggers. $2$ mark