Question: SELECT m . mov, m . mov _ title, mc . role, a . act _ fname, a . act _ lname FROM movie m

SELECT m.mov, m.mov_title, mc.role, a.act_fname, a.act_lname FROM movie m, movie_cast mc, actor a, movie_genres mg, genres g WHERE m.mov_id = mc.mov_id
AND mc.act_id = a.act_id AND m.mov_id = mg.mov_id AND mg.gen_id = g.gen_id AND g.genres_title = "Sci-Fi" AND m.lang = "English" AND m.year >='1900'
AND m.year <'2000';
Construct the query tree in canonical form. A canonical query tree corresponds to a standard relational algebra expression of an SQL query directly (i.e. a pre-heuristic-optimization query tree). Your response must NOT be hand-drawn.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

movie cast actor act id mov id role integer integer char (30) Y act id act fname act Iname act gender integer char (20) char (20) char (1) genres gen_id gen_title integer char (20) director dir id...

Q:

1. W e SOL Queries for the following terms, considering the SOLO Retrieve and guage of the English movies which wer e 2. W T SOL for the following terms, conseghe SOLO u died classes the actors who...

Q:

1. A movie may have many actors, and an actor can act in many movies. An actor can play more than one role in the same movie. Suppose we try to represent this in our database using an Actor table, a...

Q:

Use this SQL database for the question: this questions listed as "computer science" doesnt have to be only on operating systems actor 18 18 act id mov_id role integer integer char (30) genres 7 act...

Q:

Use this SQL database for the question: actor 18 18 act id mov_id role integer integer char (30) genres 7 act id act fname actiname act gender integer char (20) char (20) char (1) 9 gen id gen title...

Q:

movie_cast act id mov_id role actor Integer Integer char (30) act id act fname act Iname act gender integer char (20) char (20) char (1) genres gen_id gen title Integer char (20) movie director dir d...

Q:

Hi I need help with question 2b please 18 18 movie_cast act id mov id role integer integer char (30) actor Y act id act frame act Iname act_gender integer char (20) char (20) char(1) genres ygen_id...

Q:

c. Consider the following four queries specified on Movie database: SELECT A.act_lname FROM actor A, movie_cast C, movie M WHERE M.mov_title = Titanic AND M.mov_id = C.mov_id AND A.act_id = C.act_id...

Q:

Consider the following Movie database for Question 1-2: actor act_id act_fname act_Iname act_gender director dir_id dir_fname dir_Iname movie_direction dir_id mov_id integer char (20) char (20) char...

Q:

Which assembly instruction changes the memory as shown in the table? Please explain in details. Registers Memory eax ebx 100 120 140 160 Before 140 120 120 120 120 100 120 After 140 120 120 120 120...

Q:

Refer to exercise 7, where an estimated regression equation relating years of experience and annual sales was developed. a. Compute the residuals and construct a residual plot for this problem. b. Do...

Q:

It is possible to express the magnetic susceptibility ?m in several different units. For the discussion of this chapter, ?m was used to designate the volume susceptibility in SI units, that is, the...

Q:

If long - term debt payments are not made, lenders can force the company into receivership. Group of answer choices True False

Q:

A vector u has initial point (3, 4) and terminal point (5, 1).Write u in the form u = ai+bj.u=