CSE 344 Midterm: CSE 344 UW 13 Spring Midterm

24 views8 pages
31 Jan 2019
School
Course
Professor

Document Summary

No computers, electronics devices, phones of the smart or not- so- smart variety, telegraphs, telepathy, smoke signals, or other contraptions permitted. The exam lasts 50 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. (42 points) sql queries and indexes. We have a database that stores information about a simplified twitter application. Each of these is assigned a unique tweet id (tid) and is stored in the tweet table. Finally, a user can follow other users and that information is recorded in the follow table. Follow. uid is a foreign key that references user. uid. Follow. followsuid is a foreign key that references user. uid. The queries you write must be proper sql that would be accepted by sql server and any other sql implementation.

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