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

Aloaded platform of total mass 500 kg is supported by a dashpot and by a set of springs of effective stiffness 72 kn/m. it is observed that when the platform is depressed through a distance x = 12.5 cm below its equilibrium position and then released without any initial velocity; it reaches its equilibrium position in the shortest possible time without overshoot. find the position and velocity of the loaded platform 0.10 sec. after its release. if a further load of 400 kg is added to the platform, find, i) the frequency of damped vibrations, and i) the amplitude of vibration after 2 complete oscillations, given that the initial amplitude is 15 cm.

Answers: 1

Answer

Engineering, 04.07.2019 18:10

Compute the pressure drop of 30°c air flowing with a mean velocity of 8 m/s in a circular sheet-metal duct 300 mm in diameter and 15 m long. use a friction factor, f 0.02, and pair = 1.1644 kg/m a. 37.26 pa b. 25.27 pa n c. 29.34 pa d. 30.52 pa

Answers: 1

Answer

Engineering, 04.07.2019 18:10

Awall of 0.5m thickness is to be constructed from a material which has average thermal conductivity of 1.4 w/mk. the wall is to be insulated with a material having an average thermal conductivity of 0.35 w/mk so that heat loss per square meter shall not exceed 1450 w. assume inner wall surface temperature of 1200°c and outer surface temperature of the insulation to be 15°c. calculate the thickness of insulation required.

Answers: 3

Answer

Engineering, 04.07.2019 18:20

Air flows over a heated plate àt a velocity of 50m/s. the local skin factor coefficient at a point on a plate is 0.004. estimate the local heat transfer coefficient at this point.the following property data for air are given: density = 0.88kg/m3 , viscosity 2.286 x 10 ^-5 kgm/s , k = 0.035w/mk ,cp = 1.001kj/kgk. use colburn reynolds analogy.

Answers: 1

Answer

You know the right answer?

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

Questions