subject
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).

ansver
Answers: 3

Other questions on the subject: Engineering

image
Engineering, 04.07.2019 18:10, ashleybaber4966
If a particle moves along a path such that r : (3 sin t) m and ? : 2t rad, where t is in seconds. what is the particle's acceleration in m/s in 4 seconds? a)- 16.43 b)- 16.29 c)- 15.21 d)- 13.79
Answers: 1
image
Engineering, 04.07.2019 18:10, koolgurl2003
Apump is used to circulate hot water in a home heating system. water enters the well-insulated pump operating at steady state at a rate of 0.42 gal/min. the inlet pressure and temperature are 14.7 lbf/in.2, and 180°f, respectively; at the exit the pressure is 60 lbf/in.2 the pump requires 1/15 hp of power input. water can be modeled as an incompressible substance with constant density of 60.58 lb/ft3 and constant specific heat of 1 btu/lb or. neglecting kinetic and potential energy effects, determine the temperature change, in °r, as the water flows through the pump.
Answers: 1
image
Engineering, 04.07.2019 18:10, lillygrl100
For the closed feedwater heater below, feedwater enters state 3 at a pressure of 2000 psia and temperature of 420 °f at a rate of ix10 ibhr. the feedwat extracted steam enters state 1 at a pressure of 1000 psia and enthalpy of 1500 btu/lbm. the extracted er leaves at an enthalpy of 528.7 btu/lbm steam leaves as a saturated liquid. (16) a) determine the mass flow rate of the extraction steam used to heat the feedwater (10) b) determine the terminal temperature difference of the closed feedwater heater
Answers: 3
image
Engineering, 04.07.2019 18:20, CelesteN64
Most leaks in reciprocating air compressors can be detected and minimized by: (clo4) a)-detecting leakage areas using ultrasonic acoustic detector. b)-tightening joints and connections c)-replacing faulty equipment d)-all of the given options
Answers: 2
You know the right answer?
Consider the following moviestars database schema: moviestar(sno, sname, gender), director(dno, dna...

Questions in other subjects: