Computer Science 120

April 10, 2001

Tasks of the Day

1. The first item on today's agenda is to get caught up with previous work.  Today's lab is an Access exercise, but it is more important that you get caught up than that you begin this one.  Be sure to complete at least Step 2 of today's lab, though, before you leave campus.  (At least do so if you have any intention of working on the lab over Easter break.)



2. Copy the file School.mdb (found on the Pub server in Data/Apps/CS120/LevineAccess) to one of your floppy disks.



3. Study the given data base.  Pay particular attention to the various fields in each table.
   
   
4. Construct queries to answer each of the following questions.  Note that some of the questions may require more than one query, but the final answer should be visible in a single query.  (Name each of these queries in a straightforward manner.  Note that since you won't be printing them, they needn't have your name attached.)
   
   
   • What are the names of the students from NY?
   • Which students have cars?
   • What is the GPA for each student?  (Note that GPA is computed by dividing Quality Points Earned by Credits Attempted.)
   • How many students are on Disciplinary Probation?  (Hint: First make a query that names all of the students, then make a query that counts the number of names in the first one.)
   • Who should be admitted to the honor society?  (Note that the honor society will accept seniors with GPAs above 3 as well as juniors with GPAs above 3.5.)
   • Who is the valedictorian for this May?  (The valedictorian is the graduate with the highest GPA)  (Hint: Begin by using your GPA query from before, combined with the graduation data to create a query that tells you what the valedictorian's GPA is.  THEN build a query looking for the graduate with this GPA.)
   • Security has discovered that the car with sticker 417 has its lights on.  What phone number should they call and with whom should they ask to speak?
   
   
   
5. Construct a report that lists the students in each class in descending order of QualityPointsEarned.  Note that December graduates are considered to be in their own class for purposes of this report.



6. Send an email to dlevine@cs.sbu.edu.  It should contain the file School.mdb (with the queries and the report) as an attachment.