Computer Science Department at RPI

 
 
Home
   Syllabus  
  Lectures  
Homeworks
     Exams   

Objective

In this course students study the properties and design modern database systems. Topics include but not limited to database design, database system architecture, SQL, normalization techniques, storage structures, query processing, and security. Students gain experience by design and development of a database application system. Basic knowledge of data structures such as trees, B-trees, linear data structure, graphs,..., and a general purpose programming language is required.
 

Announcements

 
  • Class will be held as usual on January 29th.

  • Homework 3 is now available.

  • You can get connected to the PostgreSQL server using the following command from any unix machine when you substitute your own RCS userid instead of both ${user} and ${db}:

    psql  -h   titanium.grid.cs.rpi.edu  -p  4380  -U  ${user}  -d  ${db}

  • Local server access is not required, "psql -h" will work from any unix machine.

  • Graphic psql client: will need to have the server, port and user login configured.

  • For more information about psql you can refer to unix manual for psql using the command:  man psql

  • To learn more about PostgreSQL you can visit:   http://www.postgresql.org

  • Organizing the data into relation(s) in your PostgreSQL assignments (as is the case with any other database servers) can take hard work. You need to study your data files thoroughly and carefully before populating your tables with them. In real world problems, data is often 'dirty', that is the data can be misformatted, contain missing fields, etc. So you need to look at the data and fix(clean) it; keeping the data source as complete as possible. Of course you document the problems and your solutions after all.

  • Please notice that chapters 6, 7, and 12 are excluded from the first exam.

  • Homework 4 is now online.

  • Solution to Exam 1 is now available.

  • Final exam will be given on Tuesday, April 29th, from 2:00 - 4:00pm.

  • Solution to Homework4

  • Homework 5 is now online.

  • There will be an extra office hours today, Thursday April 3rd, in my office AE 208 from 11-12 noon.

  • Solution to Homework5