FACULTY OF INFORMATION TECHNOLOGY DATABASE SYSTEMS $6222$ nd SEMESTER ASSIGNMENT

$1$ REFERENCES According to the Harvard Method $5$ TOTAL $10$ Negative Marking will apply if the assignment is not formatted appropriately TOTAL MARKS FOR ASSIGNMENT $100$

ASSIGNMENT INSTRUCTIONS $1.$ All assignment must be typed, not handwritten.

$2.$ Every assignment should include the cover page, table of contents and a reference list or bibliography at the end of the document.

$3.$ A minimum of five current sources $($references$)$ should be used in all assignments and these should reflect in both in$-$text citations as well as the reference list or bibliography.

$4.$ In$-$text citations and a reference list or bibliography must be provided. Use the Harvard Style for both in$-$text citations and the reference list or bibliography.

$5.$ Assignments submitted without citations and accompanying reference lists will be penalized.

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{I}\text{D}}>2v$ Age $=21($Student$)$

$1\mathrm{.}2\mathrm{.}2$ Student $\{$:$)$

$1\mathrm{.}2\mathrm{.}3{}_{\text{n}\text{a}\text{m}\text{e}}((({}_{\text{b}\text{i}\text{d}}{}_{\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$.$

$3\mathrm{.}1$ Use the following image on data warehouse architecture to answer the questions that follow.

Figure $1$: Data warehouse architecture. Image source: ProjectPro

a$)$ Fully discuss the components in each of the sections labelled $A,B$ and $C$ in relation to Data Mining

and Business Intelligence.

b$)$ In your discussion, explain what each section and components are responsible for, lastly, give

real$-$world examples of data mining applications.