Fundamentals of Database Systems, Winter 2008

Instructor:

Prof. Amr El Abbadi

Lecture Time/Place: Tuesday/Thursday - 9:30am to 10:45am (Phelps 1401)

Discussion Section Time/Place: Friday - 12 noon to 12:50pm (Trailer 387 104)

Teaching Assistant

Sudipto Das

Updates

Please check this section regularly for Updates

A Sample Solution for Assignment 4 Can be found here
Assignment 4 is out. Due on 03/10/08 at 4:00 p.m. Look below for details.
A Sign up sheet for the project demos has been linked from the Project Section of this page. Please see the details and Sign-up for the slots by Friday 02/22.
A Sample Solution for Midterm Can be found here
A synopsis of your project is due on Friday (02/15). This will be a group assignment and each group needs to turn in one write-up. If your groups plan to meet me in my Office Hours tomorrow, then you might not send the report.
Important course and project related information is declared in the lectures/discussion. If you cannot attend, it is your responsibility to find out if you had missed out on some important information.
The final Demos for the projects will be on Monday (03/17) in CSIL. I will soon send out a sign-up sheet for the demos. Each group SHOULD sign up for a slot for the demo. The demo will last 15-20 minutes and plan your time accordingly so that all the features of the project is demonstrated.
A detailed write-up for the projects is due on Monday(03/17) by 4:00 p.m. to be submitted in the HW boxes in HFH 2108. This is part of the project and the project will be treated as incomplete without this. NO LATE TURNINs will be accepted.
Tutorial(s) on PHP added to the Resources Section.
A Sample Solution for Assignment 3 Can be found here
A Sample Solution for Assignment 2 Can be found here
A Sample Solution for Assignment 1 Can be found here
Instructions for accessing the Database Server can be found here
A MySQL Reference has been added to the resources section.

Course Outline

An Overview of the Course can be found here

Week 1: Introduction and Basics of ER Diagrams
Week 2: Details of ER Diagrams and Relation Model
Week 3: Relation Model Continued and Relational Algebra (Assigment 1 due on 01/22)
Week 4: Relational Algebra Continued and Introduction to SQL Queries (Assigment 2 due on 01/29)
Week 5: SQL Queries(Assigment 3 due on 02/05, Midterm on 02/07 in class.)

Homework Assigments

Homework Assignments for the Quarter.

Homework Assignment 4(Due Mon 03/10, 4:00 pm.)
Sample Solution
Homework Assignment 3(Due Tue 02/05, 4:00 pm. No Late TURNINS.)
Sample Solution

Course Project

A Detailed Outline of the project has been provided.

Sign up Sheet for the project demos has been provided. Please check this page for availability of slots and then email me 2-3 preferred slots. Signup Closes Friday 02/22. Any group which has not signed up by that day will be allotted a slot and will have to show up in the allotted slot.

Regularly check this webpage to see any updates/changes related to the projects.

Project Related Information:

Assignment 2: Convert the ER diagrams from Assignment 1 to Relations / Tables in SQL and submit the SQL Create Table statements for those relations. Note that your statements should follow the MySQL syntax and should execute without any errors in MySQL. You have to turn in the create table statements only. Due on Tuesday 01/29/08 by 4 p.m. Please note that this is an individual assignment. This assignment should be turned in at the HW Submission boxes located in the Copy Room located opposite to Rm 2107 Harold Frank Hall.
Sample Solution
Assignment 1: ER Diagrams for the project is due on Tuesday 01/22/08 by 5 p.m. Please note that this is an individual assignment. This assignment should be turned in at the HW Submission boxes located in the Copy Room located opposite to Rm 2107 Harold Frank Hall.
Sample Solution