Please solve this assignment human written with in$-$text citations and as well as Harvard referencing not AI written. Database $622$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$.$

QUESTION $3$

$(30$ MARKS$)$

real$-$world examples of data mining applications.

$(30)$