Course Hero Logo

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

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.˄

Upload your study docs or become a

Course Hero member to access this document

We have textbook solutions for you!
/Business-English-13th-Edition-9780357033784-278/
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 146
Business English
Guffey/Seefer
Expert Verified

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

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.
Business English
The document you are viewing contains questions related to this textbook.
Chapter 4 / Exercise 146
Business English
Guffey/Seefer
Expert Verified

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture