---

Weekly Course Materials

Week	Materials	Notes
1	Course Overview Introduction to Database	Chapter 1
2	Introduction to SQL	Chapter 3 Sample Database
3	Materials from previous week used.	Chapter 3
4	MS Powerpoint: SQL Practice 1 PDF Format: SQL Practice 1	Database for SQL Practice SQL Cheat Sheet
5	Intermediate SQL	Chapter 4
6	Materials from previous week used.	Chapter 4
7	MS Powerpoint: SQL Practice 2 PDF Format: SQL Practice 2	Database for SQL Practice SQL Cheat Sheet Homework 1
8	Advanced SQL	Chapter 5
9	Relational Algebra	Chapter 2
10	Database Design - ER Diagram ER Case Study	Chapter 6
11	Exam Review (Chapters 1 - 5)	Midterm Exam on Nov 4 at 3:30 PM - 4:45 PM
12	Transfer ER to Relational Schema	Wednesday, 11/11 - No Classes Veterans' Day
13	Database Design - Normalization Database Design - Normalization Example	Chapter 7
14	Database Design - Relation Decomposition Indexing	Chapter 14

---

Project Team Members

Team number	Team member	Demo Date
#1	Andrew Takemoto Ronald Reyes Roderick Montgomery	Friday, 12/4 at 6:00 PM
#2	Jonathan Lacanlale Armineh Karamian Josue Vega	Wednesday, 12/2 at 4:30 PM
#3	Nicolas Martinez Javier Aguayo Omid Arian	Wednesday, 12/2 at 2:00 PM
#4	Muhammad Hayat Osmar Herrera Austin Lucky	Friday, 12/4 at 7:30 PM
#5	Bryan Rodriguez Young Jin Seo Zhen Sun	Wednesday, 12/2 at 3:00 PM
#6	Cindy Navarrete Ben La France Kavya Dhyasani	Thursday, 12/3 at 4:00 PM
#7	Auhbon Amiri Charleigh McCone Aaron Tiania	Thursday, 12/3 at 6:30 PM
#8	Max Bogatyrov Bayron Pineda Samoel Molhempour	Wednesday, 12/2 at 2:30 PM
#9	Marja Centina Aishwarya Nerlekar Matthew Estes	Friday, 12/4 at 3:00 PM
#10	Ravi Archana Rudri Oza Brian Mcclelland	Friday, 12/4 at 4:15 PM
#11	Kate Go Nick Korpinen Late'jah Whittaker	Friday, 12/4 at 5:00 PM