Question

1] write the o/p of union ,minus , intersect operation on following schema.

Student_set ( Sid ,Sname , Inst_code )
Teacher_set ( Tid , Tname , Inst_code )

`\\ \\`

Thanks:)​

Answer 1

Union : select Sid, Sname, Inst_code from Student_set

Union

select Tid, Tname, Inst_code from Teacher_set;

Minus : select Sid, Sname, Inst_code from Student_set

Minus

select Tid, Tname, Inst_code from Teacher_set;

Intersect : select Sid, Sname, Inst_code from Student_set

Intersect

select Tid, Tname, Inst_code from Teacher_set;