$($b$)$ Use the Data Definition Language $($DDL$)$ declarations and table data, describe

a relational model for the film industry in APPENDIX A to answer part $($i$)$ to

$($v$).$

For each of the following queries, give an expression in relational algebra.

$($i$)$ Retrieve details of all films that were released in $2010.$

$(2$ marks$)$

$($ii$)$ Retrieve the names of all American directors.

$(3$ marks$)$

$($iii$)$ Find out the names of all actors that have played the character of Bruce

Wayne.

$(4$ marks$)$

$($iv$)$ Find out the names of all actors that have performed in a film directed

by Christopher Nolan.

$(5$ marks$)$

$($v$)$ Retrieve the titles of all films in which Leonardo Di Caprio and Kate

Winslet have co$-$acted.

$(6$ marks$)$