Fall 2014 CSCI 343 Homework 5

The files required for this assignment must be completed and uploaded to the HW5 moodle page by 11:00 PM on Sunday, 2 March.

Getting ready

Again, we are borrowing the database for CS 145 at Stanford. This particular database, representing the social network of a high school, can be accessed in a few different ways. In this database, the Friend relation is symmetric. If x is a Friend of y, then y is a Friend of x. However the Likes is not.

If you want to use the database from a GUI, here are links to three we tried out in class.

The task

You are to write five SQL queries to solve the following tasks.

Midterm 1

Doing these problems will be good practice for the first exam.