Home works based on the database schema: Movies(Movie Title, year, length, genre

Question

Home works based on the database schema: Movies(Movie Title, year, length, genre, stud¡oName, producerCertificateNum) Starsln(movieTitle movieYear. starName) MovieStar(starName, address, gender, birthdate) MovieExecutive(executiveName address, cerliticateNum. netWorth) Studío(studioName address, presidentCertificateNum) Use relational algebra to find the name of the producer of Star Wars. Use relational algebra to list the names of stars who share an address, each pair of star names should be listed once. Use relational algebra to list the names and addresses of all female movie stars who are also movie executives with a net worth over $10,000,000 Use relational algebra to find the stars who played in every movies produced by Gary Kurtz

Explanation / Answer

executivename movies wv movieexective(movies.movietitle =star wars) starsIn.starname,moviestars.address moviestarwvstarsIn(starname (starsIn)) moviestar.starname,moviestar.address starsInwvmovieswvmovieexecutive(moviestar.gender=Female (moviestar) AND movieexecutive.networth>$10,000,000) starsIn.starname moviewvmovieexecutive(movieexecutive.executivename=’gary kurtz’ (starsIn))

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.