eview chapter 8 section 8.1 Recall the following base tables of the Movies-Studios-Actors running example of the textbook: Moviestar(name, address, gender, birthdate) MovieExec(name, address studio(name, address, presc*) , cert#, networth) Construct the following views: A view RichExec giving the name, address, certificate number and net worth of all executives with a net worth of at least $10,000,000. a) b) A view studioPres giving the name, address, and certificate number of all executives who are studio presidents A view Executivestar giving the name, address, gender, birth date, certificate number, and net worth of all individuals who are both executives and stars. c) Write each of the following two queries using one or more of the above three views from and no base tables. 1) Find the names of females who are both stars and executives. 2) Find the names of those executives who are both studio presidents and worth at least $10,000,000