Relational algebra in Database(Simple)
Only 5$ will be paid : Pdf file
based on the database schema:
Movies(movieTitle, year, length, genre, studioName, producerCertificateNum)
StarsIn(movieTitle, movieYear, starName)
MovieStar(starName, address, gender, birthdate)
MovieExecutive(executiveName, address, certificateNum, netWorth)
Studio(studioName, address, presidentCertificateNum)
1 - Use relational algebra to find the name of the producer of Star Wars. (Hint: a producer is a movie executive).
2 - Use relational algebra to list the names of stars who share an address, each pair of star names should be listed once.
3 - 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.
4 - Use relational algebra to find the stars who played in every movies produced by Gary Kurtz.
10 years ago 3
- statistics
- Performance Reporting
- Financial Markets
- Module 06 Course Project - Website Analysis
- Implications of assisted suicide for society - 3 important points
- i have a lab report from past year need to be paraphrased
- Determine whether the following is a private good, club good, common resource or a public good a- French Fries b- Airport screening c-...
- The_Ideas
- why does urine smell?
- explain how we got the solutions