QUESTION $1$

$1\mathrm{.}1$ Convert the following SQL Statements into Relational Algebra

$1\mathrm{.}1\mathrm{.}1$ Select ProductId From Product Where ProductColour $=$ 'Red'

$1\mathrm{.}1\mathrm{.}2$ Select StudentName From Student Where Age $>23$

$1\mathrm{.}1\mathrm{.}3$ Select StudentName, StudentGender From Student JOIN Campus Where

StudentCampus $=$ 'Musgrave'

$1\mathrm{.}2$ Convert the following Relational Algebra Statements into SQL Statements

$1\mathrm{.}2\mathrm{.}1{}_{\text{u}\text{s}\text{e}\text{r}\text{l}\text{D}}>2$ vage $=21($ Student $)$

$1\mathrm{.}2\mathrm{.}2{}_{\text{c}\text{l}\text{a}\text{s}\text{s}}({}_{\text{a}\text{g}\text{e}}<mn>2</mn><mn>3</mn><mtext></mtext><mi>(</mi>$ Student $))$

$1\mathrm{.}2\mathrm{.}3{}_{\text{n}\text{a}\text{m}\text{e}}((({}_{bld}{}_{\text{c}\text{o}\text{l}\text{o}\text{u}\text{r}}^{\text{'}}$ red

QUESTION $2$

$(30$ MARKS$)$

$2\mathrm{.}1$ We use APIs $($Application Programming Interfaces$)$ to connect databases to different

applications in different programming languages. Discuss three different database APIs. In your

discussion, reference API calls, advantages, and disadvantages of APIs. Give examples of how

you would use each API. Finally, comment on whether these APIs are better than SQL

Embedding or not and why you think so$.$