(i)Select:

• The select operator is used to select the rows from a table which satisfy particular selection condition given in selection operation.

• Select operator selects a set of tuples that satisfy a selection condition.

• Output of query is exactly same as input schema of table.

• This …