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

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

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.

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

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

select title, price
from book 
where bookcode in (select bookcode 
                   from wrote 
                   where sequence >= 2
                   group by bookcode)

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 

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

title	price	authorfirst	authorlast
Treasure Chests	24.46	Lon	Schleining
Treasure Chests	24.46	Randy	O'Rourke
Van Gogh and Gaugain	21.00	Bradley	Collins, Jr.
Van Gogh and Gaugain	21.00	Bradley	Collins
Black House	18.81	Stephen	King
Black House	18.81	Peter	Straub

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

A nice, clean report?

OnCourse contains new information about grades.

More data to be used in class today.

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