$4.$ From the COMPANY database discussed in the class, what is the operation type specified in the Relational Algebra to retrieve the names of employees who work on all the projects that $$John Smith$$ works on$.(1$ point$)$

If one relation has M tuples and N attributes and the other has J tuples and K attributes, what are the number of tuples and attributes for the Cartesian product for these two relations? $(2$ points$)$

If one relation has M$1$ attributes and the other has M$2$ attributes with two attributes specified as a join condition on each relation, how many attributes for the EQUIJOIN and how many attributes for the NATURAL JOIN $($assuming M$1>2$ and M$2>2)?(2$ points$)$ Figure $5\mathrm{.}6$

One possible database state for the COMPANY relational database schema.

EMPLOYEE

DEPARTMENT

DEPT$\_$LOCATIONS

PROJECT

DEPENDENT