Question $3$: Consider the relational database whose schema is shown below:

EMPLOYEE $($EMp$-$ID$,$ E$-$name, gender, DOB, disability, Edu$\_$qualif.$)$

COMPANY $($Company$-$name, tax$-$ID$,$ company$-$status$)$

Iives $($Emp$-$IR$,$ street, city$)$

Works $($Emp$-$II Company$-$name, salary$)$

LOCATED$\_$IN $($Cdmpany$-$name, city$)$

The primary key for each relation is denoted by the underlined attribute.

Write the DDL commands to create the above relations.

$(7$ points$)$

Write the following queries in Relational Algebra and DMI queries:

$(8$ points$)$

a$.$ List the names of all female employees, who work for the company Ruston Bank'.

b$.$ List all the companies who are in located$-$in the same city of the company 'Ruston Bank'.

c$.$ List the name of all employees who work for the 'Ruston Bank.

d$.$ List the name, street, and city of all employees who work for the Ruston Bank and earn more than $$100K.$