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

• April 9/11: No new lab this week. Work on your project.
  
  
• Lab A (April 2/4): Work on your project, or work on Security, Views and Constraints
  
  
• Lab 9 (March 26/28): Work on your project, or work on FD and Reasoning
  
  
• Lab 8 (March 19/21): Another Database application program
  And its sample solution using recursion, sample solution using Queue, and sample solution using Stack
  
  
• Lab 7 (March 12/14): 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-2 (March 5/7): Retrieve data to answer questions
  
  
• Lab 6 (February 27/29): SQL Aggregation queries
  And its sample solution
  
  
• Lab 5 (February 13/15): SQL, Algebra and Datalog queries
  And its sample solution
  
  
• Lab 4 (February 6/8): SQL, Algebra and Datalog query with projection, selection and join
  And its sample solution
  
  
• Lab 3 (January 30/February 1): SQL DDL and update queries
  And its sample solution
  
  
• Lab 2 (January 23/25): ER Modelling, SQL query with projection and selection
  And its sample query solution
  
  
• Lab 1 (January 16/18): Getting familiar with Oracle
  and Oracle command line commands
  or through the web interface of Oracle