Here's how you do it:

1. Go to the following website: http://www.indiana.edu/~best/
2. Under "QuizSite", choose STUDENTS
3. From the drop-down box, choose/instructor to be evaluated (example: CSCI-A123-InstructorName)
4. Click PROCEED
5. Check "DO A CURRENT ACTIVITY" (Should say "Evaluation")
6. Click PROCEED
7. Evaluation for requested instructor should be displayed
8. Answer Questions
9. To submit completed evaluation, click PROCEED at bottom of page
10. Wait. If student has multiple CS courses or course instructors, they will be enabled at that time to click SELECT ANOTHER COURSE button

NOTE - Students are allowed a max 5 attempts to complete each evaluation. (They will be enabled to open each individual evaluation 5 times, whether or not they make any additions or changes.)

Date: Mon, 20 Oct 2003 11:09:48 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Last Week of Classes


Dear A114/I111 Friends,

The class is coming to an end this week.

There is no reading assignment for tomorrow.

Homework Five is due this week, when you have it ready (hopefully
in lab on Wednesday). The Semester Project is also due this week. As
discussed in class, you are to complete an information-level design for
Holt Distributors (problem 2, page 351, at the end of appendix A in your
text). Feel free to use any of the already posted materials.

The Final Exam is on Thursday in class.

Project Nine is due on Wednesday.

Friday in lab we will administer an (optional) Make-up Practical Exam.

Let us know if you have any questions/concerns.

... Adrian

Question is: is this it? Is this for real? Do you also need this?

Also, lecture notes for Oct 14 contain:

1. a summary of Chapter Six,
2. but also a solution to the Semester Project

Please check them out!

Date: Tue, 14 Oct 2003 10:49:11 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: Winding down A114/I111. 


Dear A114/I111 Friends,

Many thanks to those that came to the help session last night. The
class is slowly coming to an end. We discuss Chapter 6 this week and
Appendix A next week. Homework Four is due today in class. Homework
Five is posted and due next week. Your semester project is not more
complex than Homework Four and Five together. You need to describe a
solution (possibly one that I will post, if not posted it already).

Last night we came up with a nice example re: the power of assumptions.

Take this table: (ISBN, AuthorSSN, AuthorName).

  1) If we assume that a book can only have one author (that's pretty
  restrictive, but think about semester projects where group work is not
  allowed) then the above table is in 2NF already (ISBN is the key) but
  not in 3NF because of AuthorSSN being a non-key determinant (of whom?)

  2) If we relax the requirement, and allow co-authors, then the table
  is no longer in 2NF. (That's because we need to include the AuthorSSN
  column in the key and the functional dependency (AuthorSSN->AuthorName)
  becomes a partial dependency; it was about a the existence of non-key
  determinants in the other context).

So: same table, different assumptions, different outcomes.

What's left of this class:

  a) Homework Four, Five, and Semester Project
  b) Lab Projects Eight and Nine
  c) Final Exam (multiple choice, closed-book)
  d) Practical Makeup.

When you go to labs tomorrow please check your grades to be sure nothing
is missing and arrange an appointment with your AI if you need to work out
anything (makeups and any clarifications you may need). Thanks a lot for
your interest and hard work this semester.

Please let us know if you need any help or have any questions.

... Adrian

Help session tonight:

Date: Fri, 10 Oct 2003 14:27:44 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Help Sessions


Dear A114/I111 Friends,

There will be a help session on Monday Oct 13 7:15-8:15pm
in Lindley Hall 102 (LH102). We can help you with anything
but especially with Homework Four (and Five and even with
the semester Project).

Also, Nathan (ndeckard@indiana.edu) asked me to let you
know that if you need to make an appointment with him he's
particularly available on weekends, Mondays and Wednesday.
Send him an e-mail message now, to set up a time.

Finally, please stay current with the What's Due? and the
lecture/lab notes: project seven is due today, eight is due
next Wednesday, and Nine the Wednesday after. If you need any
help please let us know.

... Adrian

Please let me know if you have any questions or need help.

The set of solutions to the queries in the exam is posted here.

Here is more help (sample answers) to homework three, due tomorrow, in lab.

Date: Mon, 6 Oct 2003 17:04:21 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Update


Dear A114/I111 Friends,

The reading assignment for tomorrow Tue Oct 7 is Chapter 5 in the Pratt
and Adamski book. Homework Three is due Wednesday in lab (nothing else is
due in lab on Wednesday this week, so we should be able to catch up with
all lab grades) and Homework Four is due a week from tomorrow.

Grades for the midterm exam and the practical exam will be up by the end
of today (Mon Oct 6). There will be a make-up practical exam (for whoever
may need it) in the last lab. Meanwhile if you have any questions or
concerns please let us know.

... Adrian

The Practice Practical can still be uploaded to the A114 Oncourse Dropbox today.

Notice that due dates have just changed on the web site.

Date: Wed, 1 Oct 2003 08:25:55 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: Labs today (A114/I111 Update)


Today you will be shown how to upload your Practice Practical (due)
to Oncourse. Michael and Nathan and Sriram will simulate the Friday
exam by checking that they can download your work and read it before
you leave the room. The timestamp of your last upload in class will
also be recorded. Thus we will all be sure the exam on Friday won't
have any glitches.

Midterm exams will be posted today. Some of you notes that one of the
questions on the exams was incorrectly coded in the practice quizzes.
My only remark to you is that you should have tried to alert me of it
a bit earlier. It's part of being a good citizen. But good for those
that found out that there was an error in the quiz, and provided the
right answer on the exam. The error was more or less obvious.

Homework Three help will also be posted today in a new format: all
queries will be posted but parts of them will be removed so you can
fill in the blanks. That should make it a lot more manageable and
entertaining.

There's no lab assignment due next Wednesday so we'lll be able to
work on new homework assignment four and/or catch up with lab grades
at that time.

... Adrian

Date: Mon, 29 Sep 2003 13:10:16 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Help Session Tonight


Dear A114/I111 Friends,

Don't forget there's a help session tonight (LH102 7:15-8:15pm).

Exam is tomorrow, inclass: closed-book, multiple-choice, questions
are drawn from the quizzes listed under MIDTERM (on the class notes
page in the class web site).

http://www.cs.indiana.edu/classes/a114-dger/fall2003/midterm.html

Let me know if you need help. Let me know if you think you are in
any way behind. For those who think they are: the first step needed
to catch up is to come to the written midterm exam tomorrow. Bring
a pencil (no. 2) and an eraser. We'll provide scantrons.

Help session tonight is in LH102 7:15-8:15pm. Hope to see you then.

... Adrian

Date: Fri, 26 Sep 2003 15:22:59 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 midterm and practical 


Dear A114/I111 Friends,

There will be a help session on Monday September 29, 7:15-8:15pm, in
Lindley 102. Please come if you have questions or concerns about any
of the following:

  a) Midterm Exam (Tue in class Sep 30 2:30-3:20pm TH A201)

     http://www.cs.indiana.edu/classes/a114-dger/fall2003/midterm.html

  b) Sample Practical (due Wed in lab, Oct 1)

     http://www.cs.indiana.edu/classes/a114-dger/fall2001/lectures/nine/

  c) Homework Three (due Thu in class Oct 2)

     http://www.cs.indiana.edu/classes/a114-dger/fall2003/homeworkThree.mdb

     http://www.cs.indiana.edu/classes/a114-dger/fall2003/homeworkThree.html

  d) Practical Exam (Fri Oct 3, in labs)

     http://www.cs.indiana.edu/classes/a114/fall2002/exams/pract.html

     (This and the link posted at (b) are for your practice & exercise.)

Grades have been updated on the web. Try to stay current with all of
the assigned work. The last two labs of the class will have a make-up
component but we need to use that as a last resort, so please do your
best to stay on track. Thanks a let us know if you need any help.

... Adrian

On Thu, 25 Sep 2003, Adrian German wrote:

>
> Today (Thu 9/25) in class we discuss Homework Three. I remind you
> that the minute paper for today is to identify the 5 most difficult
> questions in this assignment and e-mail them to me (today). I will solve
> those on the web site so you have a model of what kind of answers we
> expect. Otherwise the near future schedule looks like this:
>
>    Project Six is due tomorrow (Fri 9/26) in lab.
>    Midterm on Tue (9/30), do the quizzes.
>    Old Sample Practical is due next Wed (10/1) in lab.
>    Thu 10/2 Homework Three is due (in class) and we start Chapter Five.
>    Homework Assignments Four,Five, Sem. Project to be posted tomorrow.
>    (There is no Homework Six and the Project comes with hints).
>    Practical Exam next Fri, like the Sample Practical due in lab next Wed.
>
> Let me know if you need any help or have questions or concerns.
>
> ... Adrian
>

Hope everyone can make it.

Date: Thu, 25 Sep 2003 13:18:21 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Update


Today in class we discuss Homework Three. I remind you the minute paper
for today is to identify the 5 most difficult questions in this assignment
and e-mail them to me (today). I will solve those on the web site so you
have a model of what kind of answers we expect. Otherwise the near future
schedule looks like this:

   Project Six is due tomorrow in lab.
   Midterm on Tue, do the quizzes.
   Old Sample Practical is due next Wed in lab.
   Thu Homework Three is due, and we start Chapter Five.
   Homework Assignments Four,Five, Sem. Project to be posted tomorrow.
   (There is no Homework Six and the Project comes with hints).
   Practical Exam next Fri, like the Sample Practical due in lab next Wed.

Let me know if you need any help or have questions or concerns.

... Adrian

It will be due on Thu Oct 2, in class.

There will be no Homework Six.

Due dates for Homework Four, Five and the Project to be posted tonight.

Date: Wed, 17 Sep 2003 15:28:41 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 update


Dear A114/I111 Friends,

There is no reading assignment for tomorrow but the minute
paper will be: what is the QBE or Relational Algebra or SQL
for the 10th query in Homework One?

Tomorrow we'll finish discussing Homework Two. After that we
will continue to discuss Chapters 2 and 3 (in preparation for
Homework Three, for example). Remember that Homework Two is
asking that you justify your queries in a tutorial fashion.

... Adrian

P.S. I made it late to the Ballantine lab today so I missed all
but 5 students. I am going to come on Fri to return the summaries
and homework assignments or you can pick them up tomorrow during
(or after, or before) the lecture. I'll come to the 4pm lab today.
Homework Two is due on Fri in lab along with Project Four.

Write the QBE/SQL or Relational Algebra for Question 10 in Homework One.

1. the COLUMNS we want displayed
2. the TABLES they're coming from
3. any CONSTRAINTS we impose on the rows to be selected

That's essentially: PROJECTION, JOIN, SELECTION.

Date: Fri, 12 Sep 2003 16:01:17 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Dist. List <dgerman@indiana.edu>
Cc: Nathan James Deckard <ndeckard@cs.indiana.edu>,
     Sriram Raghuraman <sraghura@cs.indiana.edu>,
     Michael Ngantung <mngantun@indiana.edu>
Subject: A114 Weekly Update


Dear A114/I111 Friends,

At the end of week two we should have a rough understanding of
the steps to be taken and the reasoning involved in the process
of designing a relational database. We also know that extracting
information from such a database is done through the use of query
languages (in which we write small programs called queries) such
as QBE or SQL. The theoretical foundation of query languages is
built on relational algebra (almost a query language itself).

Next week we focus exclusively on queries (Chapters 2 and 3 from
Pratt and Adamski). Lab on Wed is a catch-up lab (nothing is due
but please make sure you're up to date with Lab Projects 1, 2, 3
by the end of the lab on Wed). Homework Two is now due on Fri.

I have posted hints under Lab Four to help with Homework Two. We
will discuss it in class on Tue. Homework Three is to be posted on
Mon, and will be due the Fri after next week (Sep 26).

The reading assignment for Tue is Appendix A. Bring a summary of
just the statement of the problem. There is no reading assignment
for Thu since we'll be covering queries until we are in complete
control of Chapter 2 and 3 in Pratt and Adamski.

We hope you have a nice weekend and we'll see you on Tue, in class,
to discuss QBE, relational algebra, Homework Two, and a bit of SQL.

Please let us know if you need any help or have any questions.

... Adrian

Here's the database from yesterday's class.

Adrian	Mon	9:30-10:30am	LH201D
		3:30-4:30pm
	Tue	3:35-4:35pm
	Wed	2-3pm
	Thu	3:35-4:35pm
	Fri	2-3pm
Sriram	Fri	1-3pm	LH016
Michael	Thu	5-6pm	LH016
	Fri	8-9am
Nathan	Fri	3-5pm	LH016

Lab Assignment tomorrow will ask you to:

1. design a simple database,
2. create the tables and populate them with data
3. write at least one query, extract information, and report it.

1. Homework One is due Wednesday, and that
2. Homework Two is similar to it (only uses specific tools).

Date: Fri, 5 Sep 2003 19:49:11 -0500 (EST)
From: Adrian German <dgerman@cs.indiana.edu>
To: A114/I111 Fall 2003 Distr. List <dgerman@indiana.edu>
Subject: A114/I111 Update (Week One)


Dear A114/I111 Friends,

Many thanks for your interest and dedication during this first
week of classes. We've now become familiar with the basic structure
of a (relational) database and with Access (creating a database and
populating it with data and getting ready to extract data/information
out of it). Next week we focus on query languages: Query-By-Example
(QBE), Relational Algebra, and SQL. For Tuesday the reading assignment
is Chapter 2 from Pratt and Vaughn. Homework One can be turned in on
Wednesday in labs, this way we can discuss it more thoroughly in class
on Tuesday. I hope your weekend will be excellent and we'll see you in
class on Tuesday (and then again in labs on Wednesday).

Please let us know if you have questions or concerns. If you feel you
are already behind (in any way) let's use this coming week to catch up,
and bring ourselves completely up to date. Once again please let us know
if you need any kind of help, or if you have any questions or concerns.

Thanks again and I hope you have a great weekend.

... Adrian

Here's the web site from last year.

Syllabus distributed in class is here.