Fall Semester 2003

Here's the problem discussed in class today:

Consider the following fictitious chess tournament (FFCT 2003)
in which the participants are: Larry Bird, Michael Jordan, Toni
Kukoc, Scottie Pippen, Charles Barkley, Tim Duncan, Chris Mullin,
and Reggie Miller. The tournament is currently under way. Here
are the results thus far (including Round 6):

---------------------------(Round 1)---
Bird - Jordan      0-1
Kukoc - Pippen     1-0
Barkley - Duncan   1-0
Mullin - Miller    tie
---------------------------(Round 2)----
Bird - Pippen      1-0
Kukoc - Jordan     tie
Barkley - Mullin   1-0
Miller - Duncan    0-1
---------------------------(Round 3)---
Bird - Duncan      tie
Kukoc - Mullin     tie
Barkley - Jordan   1-0
Pippen - Miller    tie
---------------------------(Round 4)----
Mullin - Duncan    tie
Bird - Miller      tie
Barkley - Kukoc    tie
Jordan - Pippen    0-1
---------------------------(Round 5)---
Bird - Kukoc       0-1
Pippen - Mullin    0-1
Miller - Barkley   1-0
Jordan - Duncan    0-1
---------------------------(Round 6)----
Bird - Barkley     tie
Kukoc - Miller     tie
Mullin - Jordan    1-0
Pippen - Duncan    0-1
----------------------------------------

What you are to do is this:

a) set up a database to store chess tournaments data such as the example
above. Keep in mind that the number of players (in general) is unknown so
don't create a database that only supports this particular tournament only.
Instead, your database should be able to accomodate any number of players,
whatever their identity might be.

b) enter the data above in your database.

c) write a query that reports the current standings, in descending order
(the player with the highest number of points should come first, and when
two or more players have the same number of points the reporting order is
alphabetical. Run your query and find out who's the sixth in the standings
after Round 6.

What to turn in:

a) the E-R diagram

b) the SQL for the query (you will probably use QBE to design the query,
but the SQL is readily available, and easier to write down)

c) a print-out of the query's output

... Adrian