CSE 344 Final: CSE 344 UW 13 Spring Final
Document Summary
The exam lasts 110 min. Please budget your time so you get to all questions. Please wait to turn the page until everyone has their exam and you are told to begin. You are here to learn. Question 1. (28 points) sql. The following database contains information about actors, plays, and roles performed. Where: actor is a table of actors, their names, and the year they were born. Attributes actor_id and play_id are foreign keys to actor and play respectively. Assume that actor_id, play_id, year_born, and year_written are all integers, and that name, title, author, and character_name are strings. Be sure to define appropriate keys and foreign key constraints. The list should not contain duplicates but does not need to be ordered. From actor a, play p, role r. Where a. name = p. author and a. actor_id = r. actor_id and p. play_id = r. play_id. Give a relational algebra query plan drawn as a tree that correctly computes this query.
