Fall 2014 CSCI 343 Homework 4

The two files required for this assignment must be completed and uploaded to the HW4 moodle page by 11:00 PM on Monday, 17 February.

Getting ready

It takes some time to come up with a good database example, so let’s just borrow one 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 follow tasks.