Engineering, 24.10.2019 01:50 LexyClaire

Consider the following moviestars database schema: moviestar(sno, sname, gender), director(dno, dname, ddob, dcity) movie(mno, dno, title, genre, year, length, stno, budget) studio(stno, sname) starsin(sno, mno, wage, rstrole) the moviestar relation stores information about movie stars. the director relation stores information about directors and the (dno) is the primary key. the movie relation contains a list of movies. for each movie we store a movie number (mno), director number (dn), title, genre, year of production, length in minutes, the studio number where the movie was filmed and the budget. each movie has a single genre (category). the studio relation stores information about studios and the starsın relation stores information about who played in which movie. we store the star number (sno), the movie number (mno), the wages of the actor/actress for this movie and if he/she had a rst role in the movie. write the following queries in sql: 1. find the names of stars who have appeared in at least one movie where the budget was greater than 100m. 2. find the names of stars who have appeared in at least two movies where the budget was greater than 100m. 3. list the name of leading actor/actress that has also directed a movie (was a director on a movie). 4. for each star, display the average budget of the movies he/she has appeared in and display it only if the sum of the budget of the movies he/she has appeared in is more than 2m. 5. find the names of leading actors, who acted in at least one movie for each genre (have participated in movies for all genres).

Answers: 3

Show answers

Another question on Engineering

Engineering, 04.07.2019 18:10

The thermal expansion or contraction of a given metal is a function of the f a)-density b)-initial temperature c)- temperature difference d)- linear coefficient of thermal expansion e)- final temperature f)- original length

Answers: 2

Answer

Engineering, 04.07.2019 18:10

Water at the rate of 1 kg/s is forced through a tube with a 2.5 cm inner diameter. the inlet water temperature is 15°c, and the outlet water temperature is 50°c. the tube wall temperature is 14°c higher than the local water temperature all along the length of the tube. what is the length of the tube?

Answers: 3

Answer

Engineering, 04.07.2019 18:10

Machinery that is a key part of the process and without which the plant or process cannot function is classifed as: (clo4) a)-critical machinery b)-essential machinery c)-general purpose machinery d)-none of the specified options.

Answers: 1

Answer

Engineering, 04.07.2019 18:20

A3-mm-thick panel of aluminum alloy (k 177 w/m-k, c 875 j/kg-k and ? = 2770 kg/m) is finished on both sides with an epoxy coating that must be cured at or above t,-150°c for at least 5 min. the production line for the curing operation involves two steps: (1) heating in a large oven with air at ts,0-175°c and a convection coefficient of h, 40 w/m2. k, and (2) cooling in a large chamber with air at 25°c and a con- vection coefficient of he 10 w/m2.k. the heating portion of the process is conducted over a time interval te which exceeds the ime required to reach 150°c by 5 min (h = r + 300 s). the coating has an emissivity of ? = 0.8, and the temperatures of the oven and chamber walls are 175 and 25°c, respectively. if the panel is placed in the oven at an initial temperature of 25°c and removed from the chamber at a safe-to-touch tempera ture of 37°c, what is the total elapsed time for the two-step curing operation?

Answers: 3

Answer

You know the right answer?

Consider the following moviestars database schema: moviestar(sno, sname, gender), director(dno, dna...

Questions