Answer
See explanation
Work Step by Step
a. Which branches offer IT665?
TEMP → SELECT from Branch relation where ID = “IT655”;
RESULT → PROJECT BName from TEMP.
b. List all the branches present in Branch relation.
RESULT → PROJECT BName from Branch relation
c. Which branches offer 4-credit courses?
TEMP → SELECT from Branch relation where Credits=’4’
RESULT → PROJECT BName from TEMP.
