Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 6.3.6: We have noticed that certain operators of SQL are redun- dant, in the sense that they always can be replaced by other operators.
Exercise 6.3.6: We have noticed that certain operators of SQL are redun- dant, in the sense that they always can be replaced by other operators. For example, we saw that s IN R can be replaced by 8 = ANY R. Show that EXISTS and NOT EXISTS are redundant by explaining how to replace any expression of the form EXISTS R or NOT EXISTS R by an expression that does not involve EXISTS (except perhaps in the expression R itself). Hint: Remember that it is permissible to have a constant in the SELECT clause. Exercise 6.3.7: For these relations from our running movie database schema StarsIn(movieTitle, movieYear, starName) MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) Studio(name, address, presC#) describe the tuples that would appear in the following SQL expressions: a) Studio CROSS JOIN MovieExec; b) Stars In NATURAL FULL OUTER JOIN MovieStar; c) Stars In FULL OUTER JOIN MovieStar ON name = starName
Step 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