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 table. The result of the student is PASS if he obtains more than $40$ marks in all courses. $(2$ marks$)$

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

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 in the student result 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$ marks

PLEASE DONT GIVE CHATGPT ANSWER

Give the answer within $20$ mins please