Question
Relational Algebra Find the titles of the movies along with their directors that have been shown in all theaters in New York City. Assume that
Relational Algebra
Find the titles of the movies along with their directors that have been shown in all theaters in New York City. Assume that all movies in all theaters were booked at least once.
Schemas:
- Theaters(tID, name, location)
- Auditoriums(tID, aID, number of seats: integer)
- Movies(mID, title, running time: integer, genre, director, release date:integer)
- Booking(tID, aID, cID, mID, bID, seat number, date:integer, year:integer, time:integer)
- Customers(cID, name, street, city)
I know that the following will give me all info on movies booked and the theaters the movies were booked in for New York City,
but I just can't figure out how to express the question fully in relational algebra. Please help!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started