CS387 - Database design

New lecture notes are posted. (Posted Tu Dec 11 1:05:01 EDT 2001).

Look in blackboard for the solutions of one exercise we did together on transformation of an ERD to relations (Posted Sat Dec 1 11:55:01 EDT 2001).

Check your grades in blackboard. Everybody has 0 for the blackboard discussion, it will be updated later on. If there is a mistake you MUST bring your assignment next week and then I will be able to update.(Posted Sat Dec 1 11:55:01 EDT 2001).

Solutions of the hw 3 are posted in the hw section. (Posted Sat Dec 1 11:55:01 EDT 2001).

The test will be a 1 hour test and will be composed of a definition, a transformation of an ERD to relations, relational algebra and CREATE table of SQL (every options we saw except foreign key). In the definition look at what are a primary key, a foreign key, a relational schema, the operators of relational algebra, equi-join, natural join. You will have one of these definitions. (Posted Sat Dec 1 11:55:01 EDT 2001).

hw 4 is posted in the HW section. (Posted Wed Nov 28 19:36:15 EDT 2001).

The last hw is posted in the HW section. (Posted Wed Nov 28 19:36:15 EDT 2001).

New lecture notes are posted. (Posted Mon Nov 26 19:36:15 EDT 2001).

The next test is on Tuesday December 4. (Posted Sun Nov 18 00:00:15 EDT 2001).

Practice exercises are posted in the hw section. (Posted Sun Nov 18 00:00:15 EDT 2001).

HW 3 is posted in the hw section (Posted Wed Nov 14 00:50:15 EDT 2001).

Install Interbase (See the references section). We will use Interbase as a DBMS to test SQL queries. (Posted Wed Nov 13 00:20:15 EDT 2001).

Errata in the lecture notes - Relational model: I wanted to summarize the mistakes we found during the lectures. Slide Select Example: The selection is Id>3000 AND Hobby = 'hiking'. Slide Expression: In the first relation the name of the Person of Id 5678 is Mary. Slide Theta Join: The result is Mary cs386 and Bill cs385. I am sorry for the mistakes. (Posted Wed Nov 13 00:20:15 EDT 2001).

Exercises are posted in the references section. (Posted Wed Oct 31 23:20:15 EDT 2001).

New lecture notes are posted. (Posted Wed Oct 31 23:20:15 EDT 2001).

HW 2 is posted in the homework section. It is due Tuesday November 13th during the 10 first minutes of the lecture. (Posted Wed Oct 31 14:20:15 EDT 2001).

HW 1 - The diagram concerning the edition company is due Tuesday November 9th during the 10 first minutes of the lecture. (Posted Wed Oct 31 14:20:15 EDT 2001).

I will not be able to attend my office hours on Thursday 25 October in the morning because of President Caputo's visit in the CSIS department. (Posted Wed Oct 24 19:26:50 EDT 2001).

If you cannot open the PDF files I post, try to open the PS files. To open the PS files download AFPL Ghostscript 7.00 (gs700w32.exe) and the graphical interface Gsview (gsv40w32.exe) and install them. They are available at the address here. If you still have problems email me and I will send you the files. (Posted Sun Oct 21 18:26:50 EDT 2001).

I will have office hours on Monday October 22 from 10 am to 12 am. I will have regular office hours on Tuesday October 23. I will not have office hours on Tuesday October 30 in the afternoon(but I will have office hours in the morning) (Posted Sun Oct 21 18:26:50 EDT 2001).

Hw 1 solutions are posted in the homeworks section. No more homeworks accepted. (Posted Sun Oct 21 18:26:50 EDT 2001).

I posted the airline exercise in the references section. (Posted Sun Oct 21 18:26:50 EDT 2001).

HW: Part 1 and 2 are due on Thursday October 18 and part 3 is due on Thursday October 23. (Posted Wed Oct 17 12:13:13 EDT 2001)

The test will be next Thursday October 25rd. What we will do until next Tuesday October 23th is on the test. This is a speed quizz. There are definitions problems, matching problems, multiple-choices problems, true-false questions and quick questions (answers in 2 lines or you have to draw!). (Posted Wed Oct 17 12:13:13 EDT 2001)

You can use the discussion forum in blackboard at (Click here). The link is also in the left menu. To log into blackboard: You username is your Pace student e-mail code (example: cw94975n...) and your password is all the characters of your social security number (no spaces or dashes), which is also called your Pace ID number (example: 154880962). If you have problems contacts: doit@pace.edu or Doit Help desk 914 773 3648. (Posted Tue Oct 16 09:05:42 EDT 2001)

hw1: There is a text version of hw1 to help you in typing the hw. Exercise 1.8 page 24 is the same as
exercise 1.8 page 20 (it depends on the version of your book). (Posted Sun Oct 14 13:04:29 EDT 2001)

Part 3 of hw1 posted. (Posted Wed Oct 10 21:15:41 EDT 2001)

New lecture notes are posted in the References section. (Posted Wed Oct 10 19:42:41 EDT 2001)

References have been posted in the References section. Check the References section regularly for lecture notes. (Posted Sun Oct 7 23:10:11 EDT 2001)

Homework 1 is posted in the Homework section. (Posted Sun Oct 7 23:10:11 EDT 2001)

Quizz on Tuesday October 23 - 30 minutes at the beginning of the class (2:30 pm - 3:00 pm) (Posted Wed Oct 3 03:45:59 EDT 2001).

Change in office hours: Tuesday: 10:30 am to 11:00 am and 3:30 pm to 6:00 pm hursday: 10 am to 11 am and 4:40 pm to 5:40 pm (Posted Wed Oct 3 03:45:59 EDT 2001).

We will resume class this Tuesday. Welcome back! (Mon Sep 24 22:09:38 EDT 2001)

The bookstore has only the 3rd version of the book Database system concepts, Silberschatz, Korth, Sudarshan. We will use the version 3rd. If you have the 4th version it is fine also. I will refer to both versions during the semester. I am sorry for the inconvenience.

Welcome in cs 387!

CS 387

Database design

Announcements