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

Another question on Engineering

question
Engineering, 04.07.2019 18:10
The drive force for diffusion is 7 fick's first law can be used to solve the non-steady state diffusion. a)-true b)-false
Answers: 1
question
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
question
Engineering, 04.07.2019 18:20
Athin walled concentric tube exchanger is used to cool engine oil from 160°c to 60°c with water that is available at 25°c acting as a coolant. the oil and water flow rates are each at 2 kg/s, and the diameter of the inner tube is 0.5 m and the corresponding value of the overall heat transfer coefficient is 250 w/m2. oc. how long must the heat exchanger be to accomplish the desired cooling? cpwater=4.187 kj/kg-candcpengine el=2.035 kj/kg·°c, oil . 120]
Answers: 1
question
Engineering, 04.07.2019 19:10
In general, how do thermosetting plastics compare to thermoplastics in mechanical and physical properties?
Answers: 3
You know the right answer?
Consider the following moviestars database schema: moviestar(sno, sname, gender), director(dno, dna...
Questions
question
History, 21.03.2021 22:40
question
Mathematics, 21.03.2021 22:40
question
Biology, 21.03.2021 22:40
question
Mathematics, 21.03.2021 22:40
question
Mathematics, 21.03.2021 22:40
question
Mathematics, 21.03.2021 22:40
Questions on the website: 13722363