CS101b - Introduction to Relational Databases

Assignments

Here are the assignments that have been given so far.

• Homework 1: The Relational Model and Relational Algebra
      Due: Friday, January 12, 2007, at the start of class

• Homework 2: The Structured Query Language
      Due: Friday, January 19, 2007 (electronic submission)

• Homework 3: SQL Joins and Views
      Due: Monday, January 29, 2007 (electronic submission)

• Homework 4: Advanced SQL DDL and DML
      Due: Monday, February 5, 2007 (electronic submission)

• Midterm (link goes to cover sheet)
      Due: Friday, February 9, 2007

• Homework 5: The Entity-Relationship Model
      Due: Tuesday, February 20, 2007

• Homework 6: Normal Forms and Functional Dependencies
      Due: Monday, March 5, 2007

• Final Exam (link goes to cover sheet)
      Due: Friday, March 16, 2007

• Homework 7: Online Analytic Processing (EXTRA CREDIT)

Assignments Using SQL

The SQL assignments use the widely available MySQL server. The latest GA release of version 5.0 (currently 5.0.27) is what you should use.

• If you want to set up your own MySQL server to use for assignments, click here for some instructions.
• If you don't have access to a computer running MySQL 5.0, you can use a server that we will provide. (Instructions for connecting to this server and using it will be forthcoming.)

Back to main page.