It gives all values of name, ID, and branch from both the relations only if all those attributes are present in both

It gives the values of name, ID, and branch from their respective relations, where the values in the branch attribute are the same

It gives the values of name, ID, and branch from their respective relations, where all the values match with each other

It gives all values of name, ID, and branch from their respective relations

Constraints

Decomposition

Normalization

Relational algebra

Triggers

 select <attribute> from <relation>

 select <tuple> from <relation>

select <tuple> from <attribute>

select <relation> from <attribute>

Select * from students where name like ‘%S’ and last_name like ‘s%

Select * from students where name like ‘S%’ and last_name like ‘%s'

Select * from students where name = ‘S%’ and last_name = ‘%s

Select * from students where name like ‘S%’ and last_name like ‘S%

Select * from students where name = ‘%S’ and last_name = ‘%s

Select * from students where name like ‘S%’ and last_name like ‘%S

ORDER BY

GROUP BY

HAVING

SELECT

IN

Third Normal Form

Boyce-Codd Normal Form

Second Normal Form

First Normal Form

Left inner join

Full outer join

Left outer join

Inner join

Right outer join

Right inner join

Outer join