The University of Iowa

School of Library and Information Science

21:124 - Database Systems

Dept. of Computer Science

22C:144 - Database Management Systems


Syllabus [PostScript , PDF ]


The Midterm Exam will be held on March 27, in class.  It's open book, open notes and will cover E-R modeling, transformations to relational form, and SQL.  Additional details will be discussed in class  on March 13th and 25th.

Lecture & Textbook Material


Some Alternative Material from another Text (Silberschatz, Korth & Sudarshan)

This is provided only as additional, background material...

On-line Reference Material


Exercises

Note:  All homework using SQL can be done (but is not required to be done) by connecting to mingo.info-science.uiowa.edu (the server you are currently talking to) using the id and password provided to you on email-request.  Mingo supports ftp, telnet and ssh connections.  If you're doing ftp, be sure to set passive mode in your ftp configuration.
  1. Exercise #1 , due February 20, in class (Solution)
  2. Exercise #2 , due March 13, by class time. (Solution)  
  3. Exercise #3 , due April 22, in class (Solution)
  4. Exercise #4 , due April 24, May 1, and May 8 by class time
    Part1
    demo executable
    source
    Part 2
    demo executable
    source

    alternate demo
    source
    Part 3
    demo executable
    source


Reference Tools


Last modified: May 6,  2002