CS 157B - Data Base Management System

Spring 2008

---

Green Sheet

Course Schedule

Midterms and Final

Ø Ø Midterm 1 Thursday, February 21, 2008. Do not come late !!!

Ø Ø Midterm 2 Thursday, March 20, 2008. Do not come late !!!

Ø Ø Midterm 3 Thursday, April 24, 2008. Do not come late!!!

Ø Ø Final Exam Review/Study Guide Tuesday, May 13, 2008. Do not come late!!!

Homework and Program Assignments

Ø Ø Program Assignment 1 Due Thursday, February 28, 2008.

Ø Ø Program Assignment 2 Due Tuesday, April 1, 2008

Ø Ø Program Assignment 3 Due Thursday May 1, 2008

Ø Ø Earthquake example 1 ProjectReport example 1 (run the batch file inside the example zip file)

Ø Ø Earthquake example 2 ProjectReport example 2 (run the batch file inside the example zip file)

Ø Ø Earthquake example 3 ProjectReport example 3 (run the batch file inside the example zip file)

Lecture Notes:

Ø Ø Lecture 1 (1/24)

Ø Ø Obtaining LaTeX: http://www.latex-project.org/ftp.html

Ø Ø LaTeX Documentation: http://www.latex-project.org/guides/

Ø Ø Using PowerPoint [Spring 08]

Ø Ø How to Draw Entity Relationship Diagrams using PowerPoint [Spring 08]

Ø Ø Lecture 2 (1/29)

Ø Ø Lecture 3 (1/31)

Ø Ø Neural Networks (Robert Correll)

Ø Ø Lecture 4 (2/5)

Practice assignment 1 (2/5)

Ø Ø Lecture 5 (2/8)

Practice assignment 2 (2/7)

Ø Ø Lecture 6 (2/12)

Ø Ø Introduce to MySQL (Jianshi Chen)

Ø Ø SQL

Ø Ø Lecture 7 (2/19)

Ø Ø Functional Dependency Theory (Kat Powell)

Ø Ø Entity Relation Diagrams (Kelvin Nishikawa)

Ø Ø Decision Tree (Ray Hopper)

Ø Ø Lecture 8 (2/22)

Ø Ø 1NF, 2NF, 3NF, and Normalization(Rajhdeep Jandir)

Ø Ø BCNF(Mabel Thong)

Ø Ø Lecture 9 (2/26)

Ø Ø Lecture 10 (2/28)

Ø Ø Lecture 11 (3/4)

Ø Ø Lecture 12 (3/6)

Ø Ø Lecture 13 (3/11)

Ø Ø Lecture 14 (3/13)

Ø Ø Data Mining (Sangeeta Devadiga)

Ø Ø Online Analytical Processing (Hweichao Lu)

Ø Ø Lecture 15 Mid 3 Rev Association Rule 2 (3/18)

Ø Ø Lecture 16 (4/1)

Ø Ø Object-Oriented Database Management System (Nguyen, Yen P)

Ø Ø Data Mining Association rule (Nathanael Chow)

Ø Ø Lecture 17 (4/8)

Ø Ø Data Warehousing (Alex Ostrovsky)

Ø Ø Lecture 18 (4/10)

Ø Ø Clustering in Data Mining ( Phuong Tran)

Ø Ø Lecture 19 (4/15)

Ø Ø Lecture 20 (4/17)

Ø Ø Data Mining with Clustering (Rajgopal)

Ø Ø Lecture 21 (4/22)

Ø Ø Data Mining and Clustering (Benjamin Lam)

Ø Ø Lecture 22 (4/29)

Ø Ø ID3 Algorithm (Medha, Pradhan)

Ø Ø Lecture 23 (5/1)

Ø Ø Hashing (Gogoi, Trideep)

Ø Ø Lecture 24 (5/6)

Earthquake Prediction Methods (Jason Long)

Clustering (Timofey Shulepov)

Ø Ø Lecture 25 (5/8)

Ø Ø Iterative Dichotomiser (ID3) Algorithm (Phuong H. Nguyen)

Ø Ø ID3 Algorithm (Allan Neymark)

Ø Ø Indexing (Vu Phan)

Ø Ø Lecture 26 (5/10)

Ø Ø Clustering revision (Falguni Negandhi)

Ø Ø Apriori Algorithm Review for Finals (Gaurang Negandhi)

Ø Ø ID3 Algorithm (Phoung H. Nguyen)

Ø Ø Predict Earthquakes (Lois Desplat)

Ø Ø Transaction concept

Ø Ø Concurrent Control

Ø Ø Query Processing

Ø Ø Two Phase Locking

Ø Ø Distributive Database 1

Ø Ø Distributive Database 2

Ø Ø Object Oriented Database

Ø Ø Data Warehouse

Ø Ø Data Mining Knowledge (Posted 12/2/2003)

Ø Ø Normalization

§ § Normalization

§ § Lossless Decomposition

§ § Normalization Forms

§ § Fourth Normal Form

§ § Dependency Preservation

§ § Fourth Normal Form Continued

Ø Ø Distributed Database

§ § Distributed Database 1

§ § Distributed Database 2

§ § Distributed Database 3

Ø Ø Fundamentals and Basic SQL

Ø Ø B-Trees and B+ Trees

§ § B-trees

§ § B-Trees Continued

§ § B+ and B-Trees

§ § Animation of B+ Tree

Ø Ø Midterm 2 - Revision

Ø Ø Midterm 3 - Revision (Updated 11/6/2003)

Ø Ø Object Oriented Database

§ § Object Oriented Database

§ § Object Oriented Database Cont.

Ø Ø Transaction Concepts