File: hw4.txt

Name: 

Collaborators:

Due date: Sept 11, 2012, 11:59pm

To handin: Create a folder in your CS account called 
  cs457.  Inside of that directory create a directory called
  handin.  Leave your completed hw2.txt in your handin directory.
  Make sure not to change it after the due date - I will check 
  the "last modified" time on the file.  

File permissions: make sure that your handin directory is not 
  publicly readable.  Use "chmod og-rx handin" and 
  "chomd og-rx handin/*" to make the directory and files
  so they are not readable by others.  I can still read your files
  because I have admin/root access.

Task: Complete the problems below.

Grading: 3 points for each query, 12 points total.  
For the SQL questions, make sure the queries work on your MySQL 
installation.  I will try them too, and if they have errors, you are 
likely to get 0 credit for them.



* Problem 1 *
Install MySQL on your computer.  Create a database called cs457.  Give a 
few short sentences about how you installed it and any difficulties you 
came across.
* Comments *
* Answer *


* Problem 2 *
Design a database for this class.  The information that we want in the
database is: students, instructor, homework assignments (the actual 
assignments, what each student turned in, each students grade and any
comments on the grade from me), exams (similar information as from 
homeworks), in-class examples, notes from class each day, assigned 
reading for each day.

You can include more information if you want.  Give SQL statements to 
create the tables for your database for this class, and put them under
the cs457 database on your MySQL installation.  
* Comments *
* Answer *


* Problem 3 *
Give SQL statements for a week's worth of class (e.g., INSERT statements).
* Comments *
* Answer *


* Problem 4 *
Page through the book some, and pick your one (or more if you cannot 
narrow it down to one) topics you are most excited about seeing in the 
rest of the course.  Explain why, and what you hope we'll do with the 
topic in class.
* Comments *
* Answer *


* Extra Credit, at most 1 point *
Scour the web for hints, tips, opinions, etc. about database practice, and 
give a few of them.  For each, give what the hint/tip/etc. is, a link to 
where you got it from, and a basic description.  This can be about SQL or 
about something else related to databases.


* Extra Credit, at most 1 points *
Make your MySQL database accessible over the internet so we can take a 
look at it during class.  I am not giving any support about how you would
do this.  One way is to have an apache/mysql/php installation on your
system.