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, 03.07.2019 14:10
Line joining liquid phase with liquid and solid phase mixture is known as: a) liquidus b) solidus c) tie line d) none of the mentioned
Answers: 2
question
Engineering, 03.07.2019 15:10
If you were designing a bumper for a car, would you prefer it to exhibit elastic or plastic deformation? why? consider the functions of a bumper in both a minor "fender-bender" and a major collision.
Answers: 1
question
Engineering, 03.07.2019 19:30
When using the ohmmeter function of a digital multimeter, the leads are placed in what position relative to the component being tested? a. parallel b. control c. series d. line
Answers: 3
question
Engineering, 04.07.2019 18:10
During a steady flow process, the change of energy with respect to time is zero. a)- true b)- false
Answers: 2
You know the right answer?
Consider the following moviestars database schema: moviestar(sno, sname, gender), director(dno, dna...
Questions
question
Chemistry, 20.03.2021 16:20
question
Biology, 20.03.2021 16:20
question
Social Studies, 20.03.2021 16:20
question
Mathematics, 20.03.2021 16:20
question
Chemistry, 20.03.2021 16:20
question
Mathematics, 20.03.2021 16:20
Questions on the website: 13722362