Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following Relational Algebra / SQL statements, specify the output of each query. (do not explain how each query will be executed, but specify
For the following Relational Algebra / SQL statements, specify the output of each query. (do not explain how each query will be executed, but specify the output to be obtained when the query is executed).
(a) R1: ACTORS WHERE YearOfBirth > 1948
C: R1 [ LName ]
(b) SELECT FilmTitle
FROM FILMS
WHERE (LengthInMins BETWEEN 100 AND 200) AND
FilmTitle LIKE '[^ATO]%'
ORDER BY FilmTitle
(c) R1: ACTORS WHERE YearOfBirth
R2(SSNo, FName, LName): R1 [ SSNo, FName, LName ]
R3: R2 NATURAL-JOIN ACTEDIN OVER SSNo
C: R3 [ LName, Character ]
Number OfPrices Lengthin Mins 32 107 2005 31 124 Clint 9 126 40 131 22 138 Consider the following ACTORS, FILMS and ACTEDIN relations for this problem. ACTORS FILMS SSNO FName LName YearOfBirth Gender Film FilmTitle Year of No Production 1 Bruce Willis 1955 male The Sixth Sense 1999 2 Milla Jovovich 1975 female 2 Sin City 3 Eastwood 1930 male 3 The Fifth Element 1997 4 Turkan Soray 1945 female 4 Unforgiven 1992 5 Kevin Costner 1955 male 5 A Perfect World 1993 6 Robert De Niro 1943 male 6 A Bronx Tale 1993 7 Yilmaz Guney 1937 male 7 The Godfather 11 1974 AI Pacino 1940 male 8 Once Upon a Time in America 1984 9 Danny Devito 1944 male 9 One Flew Over the Cuckoo's Nest 1975 10 Jack Nicholson 1937 male 10 The Departed 2006 11 Tarik Akan 1949 male 11 The Shining 1980 12 Kadir Inanir 1949 male 12 Titanic 1997 13 Selvi Boylum Al Yazmalim 1977 ACTEDIN 14 Yol 1982 SSNO FilmNo Character 15 Inception 2010 1 177 16 202 8 13 229 35 131 94 151 3 146 121 194 2 90 6 114 148 148 1 1 1 2 3 1 2 3 4 3 3 5 4 13 5 5 6 6 Dr. Malcolm Crowe Hartigan Korben Dallas Leeloo Bill Munny Chief Red Garnett Asya Robert 'Butch' Haynes Lorenzo Vito Corleone David 'Noodles' Aaronson Michael Corleone Martini R.P. McMuphy Frank Costello Jack Torrance Seyit Ali Ilyas 6 7 6 8 8 7 9 9 10 9 10 10 10 11 11 14 12 13Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started