Relational algebra in Database(Simple)

Dr.Nitesh Goyal

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
    Answer(0)
    Bids(0)