The final project assignment has been posted. A sign-up sheet for project presentations has also been placed outside my office door, so please come and sign up for a time slot.
All lecture notes are now up to date.
Homework 4's solution is posted.
Lecture notes are up to date now.
The fourth homework assignment has been posted. Completion of this assignment will require looking at the notes for specific definitions and algorithms.
Lecture notes have been posted for the 22nd, 24th, and 29th of March. The remaining notes necessary to complete the homework will be posted by week's end.
The lecture notes page has been updated with many of the recent classes.
The midterm exam solutions will be typed up and posted tomorrow (22 March 2005).
Accounts and instructions on how to connect to the database servers will be posted this week. I want to wait to do this to make sure your project relations are sound before you start creating the databases. Otherwise you may do alot of work that will have to be scrapped. The project E/R diagrams and decompositions will be examined and returned by Thursday's (24 March 2005) class.
Lousy Smarch weather...
A solution set for homework 3 has been posted.
The lecture nores from 15 February 2005 and 17 February 2005 have been posted.
You can now practice SQL queries online here. The database consists of those three tables that keep appearing in class and in the notes (so look at the notes to see what they are called). Don't make a hardlink to the SQL practice webpage, as it will be jumping around a bit as I find a more stable server to use, so simply use the link here (which will be updated with each move) or the one on the main page.
The lecture notes from 10 February 2005 have been posted. The rest of the SQL querying notes will be posted within the next day.
The database portal for you to practice SQL will be up within a day as well... I'm giving the department one more day to update their PHP module, and if it still isn't done I'll set up my own Apache and PHP server for you to use. Sorry for the delay on this.
Solutions for homeworks 1 and 2 have been posted.
There was a mistake made in the lecture notes for 25 January 2005. The primary key description for multi-valued attributes reduced to relations was incorrect, and it has been updated. The graded homework assignment 2 indicates this as -2 points, but since it was incorrect in the notes, each assignment with such an error will be given +2 points.
Notes from 3 February 2005 and 8 February 2005 have been posted.
The interface I mentioned in class today is not ready to practice SQL. The department's installation of Apache and PHP have database support specifically turned off for my databases. I am working to have this functionality turned on (so that you can house your projects on my database server, and your web interfaces to the projects on your UNIX accounts). Once this support is enabled, the interface page will be up.
Tomorrow I will post all the lecture notes covering tuple relational calculus.
The lecture notes from 1 February 2005 have been posted.
The project page has been updated. Be sure to regularly check it out for continual updates and information.
The second homework assignment has been posted
The lecture notes from 27 January 2005 have been posted. (Division has not been included in these notes at it spanned two lectures and the full description will simply be included in the notes for 1 February 2005.)
The lecture notes from 25 January 2005 have been posted.
The main page has been updated with a revised syllabus. Already covered topics are indicated, as well as the topic being currently discussed. All other items after those on the list are topics to be covered in the future, although not specifically in that order (and possibly with some minor alterations to the text coverage).
The lecture notes from 20 January 2005 have been posted.
When submitting course notes or homeworks electronically, please do not use Microsoft Word format if you have pictures or special symbols. I do not use Word, and although I can open most documents through converters, sometimes the pictures don't show up (because Word does not use an open and published standard). Instead, please use PDF documents (preferred) or postscript files, both of which should be easy to generate:
The lecture notes from 18 January 2005 have been posted.
The lecture notes from 13 January 2005 have been posted.
The first homework assignment has been posted.
The lecture notes from 11 January 2005 have been posted.
The class notes signup sheet has been posted outside Olin 503. Here is a copy of the email sent out to everyone about it:
everyone who was in the first class and signed up on the sheet is receiving this email. if any of you know of friends who weren't there on the first day but are taking this class, please forward this to them. if you have elected to not take this class, or are receiving this in error, please contact me and i will remove your name from the list.the signup sheet for taking class notes is posted outside Olin 503. it provides all the dates of the class (as well as indicating when the midterm and final exam will be), and three slots for each date.
simply sign up for two different dates by entering your name on an available slot. the third slot is only to be used if all of the first two slots are taken up on all dates and your name doesn't appear twice already. that is, the third slot is to be used only as an overflow buffer. put another way, there should be no names in the third slots unless all of the first two slots for every day are already occupied.
the 4 people who have taken the notes for the first two lectures are already entered in those days, so only fill in your name for one additional day.
the signup sheet will remain at its location until shortly before class next tuesday morning, so please make sure you get your name in twice before that (or have a friend fill it in).
murat
Also, if anyone in the course is looking at this page and did not get the email mentioned above, you are not on the class email list. This is not a good thing, so please let me know and I can add you promptly.
The notes from Tuesday's lecture will be posted this weekend.