Fall Semester 2004

Script for individual appointments next week.


Mon-Tue Oct 18-19
The FINAL EXAM is on Thu, in SB221, 2:30-3:20pm.

Jason will be proctoring the exam, closed-book, individual work.

Wed Oct 13
Prep quizzes for the final posted (under individual lecture entries).

Sat-Tue Oct 9-12
Help with Homework Five has been posted.

Fri Oct 8
Here's the message of yesterday:
Date: Thu, 7 Oct 2004 11:05:31 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114 Fall 2004 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Update 

Dear A114/I111 friends,

Just a reminder that next week we will have individual appointments. The
gradebook will be updated before class today. Please make an appointment
for next week by using the link posted on the What's New? page under Wed
-Thu Oct 6-7 entry or directly at:

http://burrowww.cs.indiana.edu:9760/cgi-bin/fall2004/schedule

Thanks and please let me know if you have questions or need any help.

... Adrian

Wed-Thu Oct 6-7
Here's a problem you need to work in class today:

Assume a chess tournament with 6 players.

Four rounds have been played thus far. Here are the results:

Round one: Jordan - Barkley 1 - 0
Miller - Bird 0 - 1
Kukoc - Duncan 1/2 - 1/2
Round two: Duncan - Barkley 1/2 - 1/2
Kukoc - Bird 0 - 1
Miller - Jordan 1/2 - 1/2
Round three: Bird - Jordan 1 - 0
Kukoc - Barkley 1 - 0
Duncan - Miller 1/2 - 1/2
Round four: Miller -Barkley 1/2 - 1/2
Duncan - Bird 0 - 1
Jordan - Kukoc 1 - 0

Write a query that shows you the current standings in the tournament.

Turn it into OnCourse by the end of the lecture instead of minute paper.

Also be ready to review this old(er) practical exam into account (and practice with it).

Script for individual appointments next week.

Sun-Tue Oct 3-5
Here's some additional help with Homework Four.

Fri-Sat Oct 1-2
Additional help with Homework Four: one, two (from the past).

Wed-Thu Sep 29-30
Here's some help with Homework Four.

Tue Sep 28
Here's the database we worked on today in class.

Fri-Mon Sep 24-27
Grades have been posted, more to come soon.

Wed-Thu Sep 22-23
Here's the midterm exam and the solutions.

Midterm exam in SB221 this Thu at 2:30pm.

Sat-Tue Sep 18-21
Here's the database we will be working on in class on Tue.

Fri Sep 17
Please take this old(er) practical exam into account (and practice with it).

Wed-Thu Sep 15-16
Here is the promised discussion of question 10 from the first assignment.

Let's do the problem in stages.

First, can we identify the books with co-authors?

The answer is: yes.

select bookcode
from wrote
where sequence >= 2
group by bookcode
That was good practice. Let's use this ability:

select title, price
from book 
where bookcode in (select bookcode 
                   from wrote 
                   where sequence >= 2
                   group by bookcode)
That was the list of all titles and prices of books like the ones we want.

Could we print the authors, in order?

select title, price, authorfirst, authorlast
from book, wrote, author
where book.bookcode = wrote.bookcode and 
      wrote.authornum = author.authornum 
order by book.bookcode, sequence 
Great! Then we're almost done.

select title, price, authorfirst, authorlast
from book, wrote, author
where book.bookcode = wrote.bookcode and 
      wrote.authornum = author.authornum and
      book.bookcode in (select bookcode 
                        from wrote
                        where sequence >= 2
                        group by bookcode)
order by book.bookcode, sequence
This produces the following answer:
titlepriceauthorfirstauthorlast
Treasure Chests24.46LonSchleining
Treasure Chests24.46RandyO'Rourke
Van Gogh and Gaugain21.00BradleyCollins, Jr.
Van Gogh and Gaugain21.00BradleyCollins
Black House18.81StephenKing
Black House18.81PeterStraub
(Well, OK, perhaps it's exactly backwards - use DESC).

Now my question to you is this: can you make a report out of it?

A nice, clean report?

Mon-Tue Sep 13-14
Quizzes have been posted to help you out with the reading assignments.

OnCourse contains new information about grades.

Sat-Sun Sep 11-12
Additional information on first three homework assignments posted.

Thu-Fri Sep 9-10
In class on Thu we discussed Chapter 2 (and especially the Relational Algebra part of it).

Wed Sep 8
Grading information, office hours posted.

Tue Sep 7
Data to be used in class today.

More data to be used in class today.

Lecture meets in SB221 (Student Building) from now on.

Mon-Fri Aug 31-Sep 3
First week of classes, syllabus handed out in class.


Updated by Adrian German for A114/I111