# Homework2 (1).pdf - Exercise 1 (Relational Algebra) [28...

• Homework Help
• 5
• 100% (1) 1 out of 1 people found this document helpful

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 5 pages.

Exercise 1 (Relational Algebra) [28 points]We have three relations to store and maintain data about movies. Primary key attributes areunderlined.Movies(title, year, director, country, rating, genre, cost, sell)ocostis given in million DollarsActors(title, year, character_name, actor)o(title,year) form a foreign key to the Movies relation.Awards(title, year, award, result)o(title,year) form a foreign key to the Movies relation.oThe values forawardcolumn are Academy or Golden Globe; the values for theresultcolumnare Won or Nominated.1.[5 points] List movies which won awards they were nominated for.
2. [6 points] List directors of the movies which won both awards.
3. [5 points] Find actors who only act in movies low budget movies. (costless than \$2 million)πactor(࠵?cost<2(MoviesActors))4. [6 points] Find the movie directed by Seth Rogen which has the lowestrating.)
5. [6 points] Find all pairs of movies (movie1 and movie2) nominated forthe same award, such that movie1 has higher rating than movie2 butmovie2 won the award.˄

Course Hero member to access this document

##### We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 146
Guffey/Seefer
Expert Verified

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Course Hero member to access this document

Term
Spring
Professor
Dr.MarkusSchneider
Tags
Relational model, Candidate key, Tuple, relation
##### We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 146