CS 157A Lecture Notes

Fall, 2007

Ø     Lecture 01: History Of Database Systems

Ø     Lecture:       Using PowerPoint [Spring 05]

Ø     Lecture 02: Introduction of DBMS

Ø     Lecture 03: ER-Diagram (1)

Ø Obtaining LaTeX: http://www.latex-project.org/ftp.html
 
Ø                               LaTeX Documentation: http://www.latex-project.org/guides/
Ø LaTeX by Wen Ying Gao (2/7)
Ø LaTeX by John Eagle (2/21)
                        Ø  LaTeX Graphics Inclusion Techniques (2/23)
Ø Using Graphics LaTeX by Matt Edwards (2/28)

Ø     Lecture 04: ER-Diagram (2)

Ø     Lecture 05: EER-Diagram student presentation: Michael Goebel  

Ø     Lecture:      How to Draw Entity Relationship Diagrams using PowerPoint [Spring 05]

Ø     Lecture 06: Relational Model

Ø     Lecture 07: Translation of ER-Diagram into Relational Schema

Ø     Lecture 08: Relational Algebra I

Ø     Lecture 09: Relational Algebra II

Ø     Lecture 10: Relational Algebra Join

Ø     Lecture 11: Basic SQL

Ø     Lecture 12: Midterm 2 Review

Ø     Lecture 13: Last Lecture by Professor Randy Pausch

Ø     Lecture 14: Relational Algebra & SQL

Ø     Lecture 15: Theory of Functional Dependency

Ø     Lecture 16: 3NF and Boyce-Codd Normal Form

Ø     Lecture 17: Decomposition

Ø     Lecture 18: Normalization

Ø     Lecture 19: Multivalued Dependency

Ø     Lecture 20: Midterm 3 Revision

Ø     Lecture 21: Mutivalued Dependency by Fagin

Ø     Lecture 22: Midterm 3 Revision 2

Ø     Lecture 23: Midterm 3 Revision 3

Ø     Lecture 24: Data Mining

Ø     Lecture 25: Association Rules

Ø     Lecture 26: Association Rules1

Ø     Lecture 27: Final Revision I

Ø     Lecture 28: Final Revision II

Ø     Lecture 29: Final Revision 4

Ø     Lecture 30: Data Mining-Association Rules and Clustering

Ø     Lecture 31: Final Revision III

Ø     Lecture 32: Final Revision 5

 

 

 

Spring, 2004

 

 

Fall, 2002