Assignment Instructions

$```$

Create table Student

$($

ssn numeric primary key,

name char$(50),$

address varchar$(100),$

major char$(10)$

$)$;

create view CS$\_$Student as

select ssn$,$ name, address from student where major $=\text{'}$CS$\text{'}$;

$```$

create triggers on this view. If a tuple is inserted into the view, then insert it into the base table. If a tuple is deleted from the view, then delete it from the base table.