Almost weekly labs will be posted here once they are available.

• Lab A (April 1/3): Work on your project, or work on Security, Views and Constraints
  
  
• Lab 9 (March 25/27): Go through Midterm if there is demand; or work on your project; or work on FD and Reasoning
  
  
• Lab 8 (March 18/20): Another Database application program
  And its sample solution using recursion, sample solution using Queue, and sample solution using Stack
  
  
• Lab 7 (March 11/13): Database application program
  And its sample solution
  A sample program using prepared statements
  and a sample program using unprepared statements
  and their Makefile for the compilation (Note that g++-4.9 is the compiler that works with our version of Oracle, and it is only installed on otter but not on cubs.)
  You must use your sqlplus password to connect to Oracle when executing the database application programs.
  
  
• Lab 6 (March 4/6): Retrieve data to answer questions
  
  
• Lab 5 (February 25/27): SQL Aggregation queries
  And its sample solution
  
  
• Lab 4 (February 11/13): SQL, Algebra and Datalog queries
  And its sample solution
  
  
• Lab 3 (February 6/11): SQL, Algebra and Datalog query with projection, selection and join
  And its sample solution
  Feburary 4th is a snow day. The lab on this day will be delayed one week.
  
  
• Lab 2 (January 27/29): Getting familiar with Oracle
  and Oracle command line commands
  or through the web interface of Oracle
  
  
• Lab 1 (January 21/23): Database Design
  
  
• Lab 0 (January 14/16): SQLite and SQL