Com theatresnamecitystatezipphone

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: r[address_street] p[address_city] r[address_city] t[emp_name] p[emp_name])} DRC: { p | d, s, m ( p, s, d EMPLOYEE p, m MANAGES p, s, d EMPLOYEE )} 4. Find the names of all employees in this database who do not work for ‘PeopleSoft’ TRC: {t | s WORKS_ON(s [industry_name] ' PeopleSoft' t[emp_name] s[emp_name])} DRC: { p | d, s( p, d, s WORKS_ON c ' 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 playing the movie “Cabin Fever”. SELECT name FROM ShownAt WHERE title=’Cabin Fever’; b) List all the movies playing in theatres in Champaign city. SELECT title FROM Theatres, ShownAt WHERE Theatres.city=’Champaign’ AND Theatres.name=ShownAt.name; c) Find the number of theatr...
View Full Document

This note was uploaded on 01/27/2014 for the course COP 5725 taught by Professor Staff during the Spring '08 term at University of Florida.

Ask a homework question - tutors are online