EXERCISE, DBT introductory lecture ---------------------------------- Suppose you are a DBMS, and that all the relations queried below are very large (residing on external memory). They are stored as a sequence of tuples. How would you process each one of the queries? 1. SELECT * FROM Movie WHERE studioName = 'Disney' AND year = 1990; 2. SELECT * FROM (SELECT * FROM Movie WHERE studioName = 'Disney') WHERE year = 1990; 3. SELECT * FROM Movie, MovieExec WHERE Movie.title = 'Star Wars' AND Movie.producerC = MovieExec.cert; 4. SELECT * FROM Ships, Classes, Outcomes WHERE (Outcomes.ship = Ships.name) AND (Classes.class = Ships.class); 5. SELECT * FROM Movie WHERE studioName LIKE 'D%' AND year>1980 AND year<1990; 6. SELECT * FROM Movie WHERE NOT EXISTS (SELECT * FROM Movie M WHERE M.year > Movie.year);