Questions $(1,2,3,$ and $4).$ Consider the following tables:

Student enrolledIn subject

id name id code code lecturer

$1234$ joe $1234$ cs$1500$ cs$1500$ curtis

$4000$ hector $1234$ cs$1200$ cs$2001$ dave

$2000$ ling $1234$ cs$2001$ cs$3010$ curtis

$4000$ cs$3010$ cs$2001$ olivier

$4000$ ma$3000$ ma$3000$ roger

Figure out which relational algebra operations were used to obtain each of the following tables.

Name

Joe

Hector

ling

code Lecturer

cs$3010$ curtis

cs$1500$ curtis

id name code lecturer

$4000$ hector cs$3010$ curtis

$4000$ hector ma$3000$ roger

name lecturer

joe curtis

hector curtis

$5.$ Consider the database with the following schema:

Person$($name$,$ age, gender$)$ name is key

Frequents$($name$,$ iceCreamShop$)($name$,$ iceCreamShop$)$ is a key

Eats$($name$,$ flavor$)($name$,$ flavor$)$ is a key

Sells$($iceCreamShop$,$ flavor, price$)($iceCreamShop$,$ flavor$)$ is a key

U