New items on the course web page

(1) Test #1 reading list

(2) Solutions to homework #1 problems

--jc

HW1 problem1.2 correction

Regarding the problem 1.2, this problem should select the students who have taken both cse531 and cse562 and get better grade in 562 and the students who have taken one of these two courses or who have taken none of them. My previous understanding is wrong. Sorry about this.

Update to homework #1

Please see the course web page for an update to homework #1 (Problem 5).

--jc

About tora

Regarding tora, try follow the instructions on the link Prof. Chomocki provided. When you open the tora, try to create a new connection at  first. The connection provider is Oracle(TNS), user name is your ubit name, password is cse562r1, and choose the databse AOS.buffalo.edu. After you create a connection, use the sql editor to edit your sql, and you can access the tables via zhouhany.student, zhouhany.prereq, zhouhany.course, zhouhany.enroll.
Zhouhan

TOra

During today's lecture I mentioned TOra, a GUI for Oracle. The URL is:
https://wiki.cse.buffalo.edu/services/content/tora

New handouts: Indexing

Copies of slides and handouts on Indexing are available on the course web page.
--jc

Dataset for homework 1

We have set up a small database that you can test question 1 and 2 of homework on. You can get to the tables using the names zhouhany.student, zhouhany.enroll, zhouhany.course and zhouhany.prereq. If you cannot get to these tables, please contact any TA and we will re-grant you the privilege.

office hour

We will hold office hours at Davis 302 at following time slots:

Mon 2pm-3pm

Thur 12pm-2pm

Fri 2pm-3pm