3. List the name of a star that has also directed a movie (was a director on a movie).
4. For each star, find the average profit of the movies he/she has appeared in and display it only if the sum of profits of the movies he/she has appeared in is more than 2M.
5. Find the names of stars who acted in at least one movie for each genre (have participated in movies for all genres).

Problem 3.

Emp(eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, pct time: integer)
Dept(did: integer, dname: string, budget: real, managerid: integer)

 

Problem 4.
Find all the candidate keys of the relation R.
(A,B) ;(B,C,H) ; (B,C,F)
Decompose the relation in the following normal forms (if it is not there already):
a) 3NF,
b)BCNF