What's new
05/22/02 added Announcement about letter grade basis 05/20/02 added Announcement about final grade posting 05/15/02 added Announcement about Final exam grade distribution 05/12/02 fixed two obvious typos in Handout H5 05/09/02 added Announcement about all grades 05/09/02 added Announcement about Homework 5 results 05/09/02 added Announcement about Project 4 grade distribution 05/08/02 added Handout H5S for solution to Homework 5 05/03/02 added final exam room and requirements and Annoucement for this 05/03/02 added Slides for Chapter 14 under Handouts 05/03/02 added Lecture 27 summary and Reading 05/03/02 added Announcement about demo data preparation 04/30/02 added planned topics for Lecture 27 04/30/02 added Slides for Chapter 13 under Handouts 04/30/02 added Lecture 26 summary and Reading 04/27/02 added Handout H5 on more SQL, data storage, query processing 04/26/02 added Announcement about Project 4 due date and final review 04/25/02 added Announcement about demo sign-up 04/25/02 added planned topics for Lecture 26 04/25/02 added Slides for Chapter 11 (Part 3) under Handouts 04/25/02 added Lecture 25 summary and Reading 04/21/02 added Final exam date and time 04/23/02 added planned topics for Lecture 25 04/23/02 added Slides for Chapter 11 (Part 2) under Handouts 04/23/02 added Lecture 24 summary and Reading 04/18/02 added Announcement about Projct 3 grade distribution 04/18/02 added planned topics for Lecture 24 04/18/02 added Slides for Chapter 11 (Part 1) under Handouts 04/18/02 added Lecture 23 summary and Reading 04/16/02 added Announcement about Midterm 2 grade distribution 04/16/02 updated plans for the last couple of lectures to add reviews 04/16/02 added planned topics for Lecture 23 04/16/02 added Slides for Chapter 10 (Part 2) under Handouts 04/16/02 added Lecture 22 summary and Reading 04/15/02 added Handout P4 for part 4 of course project 04/15/02 promoted links to Sybase, JDBC, JBuilder next to link to Trans Labs 04/12/02 added planned topics for Lecture 22 04/12/02 added Slides for Chapter 10 (Part 1) under Handouts 04/12/02 added Lecture 21 summary and Reading 04/11/02 added output from execution to Handout P3S 04/11/02 added candidate key constraints in addresses in Handout P2S 04/11/02 fixed attributes and usage about preference in Handouts P3S and P2S 04/05/02 added the part about tiggers and more SQL in Course Outline 04/04/02 added Midterm 2 requirements (open handwritten notes) 04/08/02 added Handout P3S for solution to part 3 of course project 04/04/02 added Slides for Chapter 9 under Handouts 04/04/02 added Lecture 19 summary and Reading 04/04/02 added Handout H4S for solution to Homework 4 04/03/02 added Announcement about Project 2 grade information 04/03/02 added Announcement about small changes/clarifications to Handout P3 04/03/02 added order of increasing for sorting in Handout P3 04/02/02 changed 4:30am to 4:30pm for trip1 in Handout P3 (thanks to Delia) 04/02/02 added planned topics for Lecture 19 04/02/02 added Slides for Chapter 8 (Part 4) under Handouts 04/02/02 added Lecture 18 summary and Reading 03/27/02 added pointers to a little DB tutorial under miscellaneous pointers 03/26/02 added pointer to a little SQL tutorial under miscellaneous pointers 03/25/02 added Handout P2S for solution to part 2 of course project 03/25/02 added clarification for matching in queries 9 and 10 in Handout P3 03/22/02 added Handout H4 on relational algebra, SQL qeuries, normal forms 03/22/02 added planned topics for Lecture 18 03/22/02 added Slides for Chapter 8 (Part 3) under Handouts 03/22/02 added Lecture 17 summary and Reading 03/19/02 added Handout P3 for part 3 of course project 03/19/02 added planned topics for Lecture 17 03/19/02 added Slides for Chapter 8 (Part 2) under Handouts 03/19/02 added Lecture 16 summary and Reading 03/18/02 added Announcements about Project 2 handin and SQL assertions 03/18/02 added planned topics for Lecture 16 03/15/02 added Slides for Chapter 8 (Part 1) under Handouts 03/18/02 added Lecture 15 summary and Reading 03/13/02 changed birthDate to birthyear in P2 data (thanks go Valerie) 03/13/02 added handing in also a printout of SQL code in Handout P2 03/13/02 added two Announcements about working in teams 03/13/02 added Announcement about Project 1 grade information 03/13/02 added planned topics for Lecture 15 03/13/02 added Slides for Chapter 6 (Part 4) under Handouts 03/13/02 added Lecture 14 summary and Reading 03/10/02 added Announcement about Midterm 1 grade distribution 03/10/02 added data and help in Handout P2 03/08/02 added planned topics for Lecture 14 03/08/02 added Slides for Chapter 6 (Part 3) under Handouts 03/08/02 added Lecture 13 summary and Reading 03/07/02 added Announcement about new due date for project 2 03/04/02 added Announcement about TA responsibilities for grading, etc. 03/04/02 added planned topics for Lecture 13 03/04/02 added Slides for Chapter 6 (Part 2) under Handouts 03/04/02 added Lecture 12 summary (self study) and Reading 03/02/02 added Handout P2 for part 2 of course project 03/02/02 added Handout P1S for solution to part 1 of course project 02/28/02 added Slides for Chapter 6 (Part 1) under Handouts 02/28/02 added planned topics for Lecture 12 (self study) 02/28/02 added Lecture 11 summary and Reading 02/26/02 added pointer to Transact-SQL User's Guide in the Trans Lab, and deleted link to Sybase's SQL Server Ref Manual (it's an older version) 02/26/02 added link to Sybase's SQL Server Ref Manual (thanks to Li-Jen Pan) 02/25/02 added Announcement about an alternative solution to prob 3d in H3 02/21/02 added links to Sybase's Transact-SQL User's Guide and other ASE 12.0 Product Documentation (thanks to Prof. Bernstein) 02/21/02 added Midterm 1 requirements 02/21/02 added Slides for Chapter 4 (Part 4) under Handouts 02/21/02 added Lecture 9 summary and Reading 02/21/02 fixed two typos in problem numbers in Handout H3S 02/21/02 added Handout H3S for solution to Homework 3 02/19/02 added Slides for Chapter 4 (Part 3) under Handouts 02/19/02 added planned topics for Lecture 9 02/19/02 added Lecture 8 summary and Reading 02/19/02 added Handout H3 on ER model, relational data model, SQL DDL 02/17/02 added TAs Dipti and Wenxin's office hours 02/14/02 added Slides for Chapter 4 (Part 2) under Handouts 02/14/02 added planned topics for Lecture 8 02/14/02 added Lecture 7 summary and Reading 02/12/02 added Slides for Chapter 4 (Part 1) under Handouts 02/12/02 added planned topics for Lecture 7 02/12/02 added Lecture 6 summary and Reading 02/11/02 changed TAs Lujin and Zhe's office hours 02/08/02 added Slides for Chapter 5 (Part 3) under Handouts 02/08/02 added planned topics for Lecture 6 02/08/02 added Lecture 5 summary and Reading 02/08/02 added Slides for Chapter 5 (Part 2) under Handouts 02/07/02 added Handout P1 for part 1 of course project 02/05/02 added planned topics for Lecture 5 02/05/02 added Lecture 4 summary and Reading 02/04/02 updated TA information and added TA Zhe's office hours 02/03/02 added pointer to gzip 02/03/02 added planned topics for Lecture 4 02/03/02 added Slides for Chapter 5 (Part 1) under Handouts 02/03/02 added Lecture 3 summary and Reading 01/31/02 added TA Lujin's office hours 01/29/02 added pointer to Ghostscript and Ghostview and announced it 01/29/02 added Slides for Chapter 2 under Handouts 01/29/02 added Lecture 2 summary and Reading 01/29/02 added Handout H2 for describing a database application 01/28/02 added Announcement about slides and notes for lectures 01/28/02 added Slides for Chapter 1 under Handouts 01/28/02 added Lecture 1 summary and Reading 01/24/02 added Handout H1 for Questionnaire 01/23/02 added pointer to Transaction Processing Labs 01/23/02 homepage created with General Information, Course Outline, Lectures and course work scheduled, and Requirements