File: hw3.txt

Name: 

Collaborators:

Due date: Sept 4, 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: 2 points for each query, 10 points total.



* Problem 1 *
ID, name of all students who are Computer Science majors.
Results columns: ID, name
* Comments *
* Answer *


* Problem 2 *
ID, name of all students enrolled in a Computer Science course the Fall 
2009 semester.
Results columns: ID, name
* Comments *
* Answer *


* Problem 3 * 
All courses (course_id, sec_id, semester, year) ever taught by the instructor named Katz.
Results columns: course_id, sec_id, semester, year
* Comments *
* Answer *


* Problem 4 *
dept_name, max salary in that department, for all departments.
Results columns: dept_name, salary
* Comments *
* Answer *


* Problem 5 *
Salary and department with smallest maximum salary.
Results columns: dept_name, salary
* Comments *
* Answer *


* Extra Credit - 1 point max *
Come up with your own question.  It should be something that would 
be natural to try and find in the university database, the correct 
answer should not be too easy (it is a "difficult" one to figure out), but
you give the correct query for it nonetheless.  Feel free to search online
to get ideas, just cite where you got it from if you use something from 
online.
* Comments *
* Answer *