cs1520: lab 8
=============


In this lab we will use MySQL to create tables, populate them with data,
and issue queries over the tables.

You should have been given a MySQL account, and your username should be the
same as your pittID. Also, a database should have been created for you with the
following format: cs1520_pittID

For example, if your pitt username is ygl2, your database would be called:
cs1520_ygl2


1. Getting started
------------------
First, take a look at setup.php. This script will create a table called "Users"
with the following columns (id,name,email,gender,age). Then it will populate
the table with data from users.csv. A second table called "Followers" will be
created. This table keeps track of the users that each person follows. The
table only contains 2 columns (follower_id, target_id), and it will be
populated from a file called "followers.csv". So, if the table contains (7,31),
then this means that user 7 is following user 31.

You should modify setup.php by adding your user name, database name, etc into
the appropriate variables. Then make sure that the script runs without any problems.

2. Viewing the data
-------------------
For the next part of the lab, we will be performing queries over the data that
has been inserted. You write one or more scripts that issues the following queries:

a) show all data in the the Users table.
b) show all users under the age of 25.
c) print the total number of females in the table.
d) show all of the people following Noah.
f) determine if Alexander is following Maddison.