Unformatted text preview: yees in this database who do not work for ‘PeopleSoft’ Exercise 4 (SQL Queries) [30pts] Consider the following schema of a movie database used by reel.com: Theatres(name,city,state,zip,phone) Movies(title,rating,length) ShownAt(Theatres.name,movies.title) Provide SQL statements to answer the following questions based on the schema provided. a) List all theatres playi...
View Full Document
- Spring '08
- Algebra, Relational model, relation, Relational calculus