Database Systems 2008-2009

Important News

• 27/01/2009 - 15:30

  I have added 2 tests from previous years :) Take a look at the assignment page

• 18/11/2008 - 17:00

  So i would like to point out some of things i thought was not clear enough at today's lecture (based on the questions i got afterwards):

  • If you are trying to download today's slides with IE, you get a "zip" file instead of the "pptx" file. I am not sure exactly why this happens, but anyway you can just rename the file extension to ".pptx" afterwards. Powerpoint 2007 viewer can be download here.

    Also, i added a pdf version of the slides (at the slides page)..

  • Oracle XE database can be downloaded from oracle's site (there's a link at the connection guide page).

  • When you connect to TAU's database with the "hr_readonly" user, you won't see the corresponding tables listed on SQLDeveloper.

    You can see them by going to "Other Users"-->"HR"-->Tables.

    Note that the "hr_readonly" use has the "HR" namespace - i.e. when writing a query is enough to write "SELECT * FROM jobs" (instead of "SELECT * FROM hr.jobs").