CS 157A Database Design

Fall, 2007

---

Green Sheet

Course Schedule

Midterms and Final

Ø Midterm 1 Study Guide Tuesday, September 18, 2007. Do not come late!

Ø Midterm 2 Thursday, October 11, 2007. Do not come late!!

Ø Midterm 3 Tuesday, November 27, 2007. Do not come late!!!

Ø Final Exam Section 1: Tuesday, December 18 2007 07:15am-09:30am Please attend the class on time!!! Please bring 882E Scantron!!!

Homework and Program Assignments

Ø Assignment 1 Due Tuesday, Oct 25, 2007.

Ø Assignment 2 Due Tuesday, Dec 04, 2007.

Ø Assignment 3 Due Tuesday, Oct 4, 2005.

Ø Assignment 4 Due Tuesday, November 8, 2005.

Ø Assignment 5 Due Tuesday, November 22, 2005

Ø Program Assignment 1 Due Tuesday, April 13, 2004.

Ø Answer Key for Program Assignment 1

Ø Program Assignment 2 Due Thursday, May 13, 2004.

Ø Download MySQL

Student Presentation [Fall 2007]

Ø Relational Data Model (Ervi Bongso, Alan Fernando)

Ø Functional Dependencies (Jorge Pombar)

Ø Chapter 6.8 (Bryan Lafferty)

Ø SQL (Terry Wei)

Ø Data Manipulation (Brain Cobarrubia)

Ø Structured query language (JOSEPH ESTRada)

Ø Normal Form (Christopher Archibald)

Ø Normal Forms Based on Functional Dependencies (Deborah Costa)

Ø A Comprehensive Approach to Normalization and Denormalization (Abdul Rashid Ahmad)

Ø Higher Normal Forms (Shantanu Narang)

Ø Higher normal forms (John Nicosia)

Ø XML and The Relational Data Model (Soid Quintero)

Ø Data Mining (Ketaki Borkar)

Ø Data Mining (Archana Ketkar)

Ø Data Mining (Chris Nelson)

Ø Data Indexing (Herbert A. Evans)

Ø Association Rule (Kenneth Leung)

Ø Data Warehouse (Patrick Seto)

Ø Midterm 3 Question #1 (Mark Becker)

Student Presentation [Fall 2006]

Ø Entity Relationship Model (Robert, Correll)

Ø Relation Model (Jung T. Chang)

Ø EER (Hunwardsen, Bryan David)

Ø Functional Dependency (Jandir)

Ø Relational Algebra (Gupta)

Ø SQL (Sangeeta)

Ø Functional Dependencies (Nash Raghavan)

Ø SQL (Neyha Amar)

Ø Functional Dependencies (Usman Saeed)

Ø Normal Forms (Carlos Alvarado)

Ø Boyce Codd Normal Form (Kelvin Nishikawa)

Ø Aggregate Function (Sushma Bandekar)

Ø Multivalued Dependency (Ha Do)

Ø 4N and the Normalization of Multivalue Dependency (Laith Alnagem)

Ø Decomposition (Timothy Chen)

Ø 4 Normal Form (Nathanael Chow)

Ø Latex (Brent Turner)

Ø Introduction to XML (Rashmi Kukanur)

Ø ASSOCIATION RULES (STEFAAN YETIMYAN)

Ø Data Mining (Brent Turner)

Ø DATA MINING (Swathi Rangan)

Ø Data Mining (Thai Hoa Nguyen Pham)

Student Presentations [Fall 2005]

Ø Functional Dependency (Jeff Wei)

Ø SQL (Niki Sardjono)

Ø Lossless Decomposition (Anannua Sengupta)

Ø ER Diagram (Alex Ostrovsky)

Ø ER Diagram (Yen-Chu Pan)

Ø Relational Model (Truc Truong)

Ø SQL (Justin Maksim)

Ø SQL (Weishan Wang)

Ø Nested Subqueries (Kenneth Cheung)

Ø Relational Algebra (Tim Kaddoura)

Ø Domain Relational Calculus QBE (John Eagle)

Ø Boyce-Codd NF (Takahiko Saito)

Ø Boyce Codd Normal Form (Thanh Truong)

Ø Normalization (Ihan Yoo)

Ø Normal Forms (Wen Ying Gao)

Ø Decomposition (Yu Hung Chen)

Ø Decomposition (Albert Lin)

Ø Decomposition (Liang Sheng Deng)

Ø Decomposition (David Stillion)

Ø Data Mining (Aung Oo)

Ø Data Mining (Adrian Tuhtan)

Ø Data Mining (Tri Nguyen)

Ø Date Mining (Guan Hang Su)

Ø Aggregate Functions (Surya Bhagvat)

Ø Multivalued Dependencies (David Worhtam)

Ø Multivalued Dependencies (Tamer Abuelata)

Ø Multivalued Dependencies (Tomasz Kaciak)

Ø Multivalued Dependencies (Asmerom Tekeste)

Ø 4^th Normal Form (Karen McVay)

Ø Object-Orientation in Query Languages (Toan Nguyen)

Ø ORM with Hibernate by Justin Corpron

Ø Introduce of XML (Xiaoling Song)

Ø Data Indexing (Herbert A. Evans)

Previous Student Presentations

Ø SQL (Lois Desplat)

Ø Chapter 3 (Chris Mathenia)

Ø SQL (Toan Nguyen)

Ø SQL (Jia Huang)

Ø Normalization (Jason Park)

Ø SQL, Chapter 3 (Alina Vikutan)

Ø Functional Dependency (Koichiro Hongo)

Ø Relational Algebra (Chi Zhang)

Ø SQL Section 4.8-4.15 (Sherly Rao)

Ø Basic SQL 4.1 - 4.7 (Rahul Mehta)

Ø Basic SQL 4.1 - 4.7 (Ying Chen)

Ø QBE (Angela Tong)

Ø More Normal Forms 7.9 7.10 (Derek Shigemi)

Ø Basic SQL 4.1 – 4.7 (Spencer Mak)

Ø Datalog (Raymund Gloria)

Ø Indexing (Yuenshu Li)

Ø Normalization Using Multivalued Dependencies (Yan Qing Lei)

Ø Lossless Decomposition (Chi-Shi Ho)

Ø B+ - Tree (Phi Thong Ho)

Homework Submission

Quizzes

Study Guide for Midterms

Midterm#1 Solution

Midterm#3 Solution

Lecture Notes (Fall 2007)

Quize #10

Powerpoint Presentation

Links