Fall Semester 2003


Wed Oct 22
In lab today please submit your Course and Instructor Evaluations.

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.)

Tue Oct 21
In class today we'll wrap things up, discuss the project one more time.

Sat-Mon Oct 18-20
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

Fri Oct 17
Promised help with the Semester Project posted.

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

Wed-Thu Oct 15-16
Multiple-choice questions for the Final Exam posted.

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!

Tue Oct 14
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

Mon Oct 13
Here's the message of Friday.

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
Fri-Sun Oct 10-12
Please make sure to stay current with the What's Due? page.

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

Wed-Thu Oct 8-9
Lecture Notes Ten and Eleven should help with Homework Four.

Tue Oct 7
The database used in the practical exam is here.

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.

Mon Oct 6
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

Sat-Sun Oct 4-5
Enjoy your weekend after a relatively demanding week.

Fri Oct 3
Practical Exam in labs today.

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

Thu Oct 2
Here's a new document to help with homework three.

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

Wed Oct 1
Midterm Exam in class today (multiple-choice, closed-book).

Tue Sep 30
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

Mon Sep 29
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

Sat-Sun Sep 27-28
Here's the message sent to the list yesterday:
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
>

Fri Sep 26
There will be a help session on Mon Sep 29 7:15-8:15pm in LH102.

Hope everyone can make it.

Thu Sep 25
Message sent to the list today:
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

Wed Sep 24
Homework Three has been finalized.

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.

Tue Sep 23
Here's the database for homework three (and the questions) in the making.

Mon Sep 22
Homework assignments 3, 4, 5 to be posted today.

Sat-Sun Sep 20-21
Homework Two being graded, Homework Three in the making.

Fri Sep 19
Grades updated today, we're still a tiny bit behind, but closer.

Thu Sep 18
Here's the message posted to the distribution list yesterday:
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.

Wed Sep 17
No new reading assignment tomorrow but the minute paper will be:
Write the QBE/SQL or Relational Algebra for Question 10 in Homework One.

Tue Sep 16
Remember that when writing a query we need to consoider:

  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.

Sat-Mon Sep 13-15
Sent to the distribution list on Friday:
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

Fri Sep 12
We've posted some grades, (A114-1367) we'll update everything after the next lab.

Here's the database from yesterday's class.

Thu Sep 11
Lecture Notes posted for today's class (and tomorrow's lab).

Wed Sep 10
Schedule of Office Hours (to be posted today) looks like this:
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

Tue Sep 9
Reading Assignment for Thu is Chapter 3 in Pratt/Vaughn.

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.

Sat-Mon Sep 6-8
Note that
  1. Homework One is due Wednesday, and that
  2. Homework Two is similar to it (only uses specific tools).

Fri Sep 5
Email distribution list created, first message sent:
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
Thu Sep 4
The Reading Assignment for today was Lecture Manual Chapter One.

Here's the web site from last year.

Wed Sep 3
Labs today start Project One from the Lab Manual.

Tue Sep 2
Fall 2003 semester starts.

Syllabus distributed in class is here.


Updated by Adrian German for A114/I111