CSE 344 Final: CSE 344 UW 14 Winter Final

21 views17 pages
31 Jan 2019
School
Course
Professor

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. (21 points, 7 each) sql. We have a small database with information about people and events. Where: person contains information about all people in the database. Each person has a unique integer id (pid), which is the key: event is a list of all events. Each event has a unique integer event id (eid), which is the key. The attribute going has the value 1 if the person will attend the event and is 0 if not. Attributes pid and eid are foreign keys referencing person and event respectively. Two events overlap if one starts while the other is in progress. Persons should be included in the result regardless of whether or not they plan to attend either or both events.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents

Related Questions