---

Weekly Course Materials

Week	Materials	Notes
7/14 - 7/15	Course Overview Introduction to Database	Chapter 1
7/19 - 7/20	Introduction to SQL	Chapter 3 Sample Database
7/21 - 7/22	MS Powerpoint: SQL Practice 1 PDF Format: SQL Practice 1 Intermediate SQL	Chapter 4 SQL Practice Database (.sql file)
7/26 - 7/27	Advanced SQL	Chapter 5
7/28 - 7/29	MS Powerpoint: SQL Practice 2 PDF Format: SQL Practice 2 Database Design - ER Diagram	SQL Practice Database (.sql file)
8/2 - 8/3	ER Practice ER Case Study	Chapter 6
8/4 - 8/5	Transfer ER to Relational Schema Database Design - Normalization	Chapter 7
8/9 - 8/10	Database Design - Normalization Example Database Design - Relation Decomposition
8/11 - 8/12	Relational Algebra Relational Algebra and SQL Practice	Chapter 2
8/16 - 8/17	Database Design - Decomposition Exam Topics Review (Chapters 1 - 7)	Exam on Tuesday, August 17 at 3:00 PM - 4:35 PM via Canvas

---

Project Team Members

Team number	Team member	Demo Date
#1	Emanuel Aguirre-Franco Randy Flores My Tran	Tuesday, 8/24 at 12:00 PM
#2	Mihai Mihailescu Michelle Chheung Cesar Villa	Friday, 8/27 at 2:15 PM
#3	Ariel Berkowicz Ruitao Wu Cyrus Tabatabai Kevin Tran	Monday, 8/23 at 3:00 PM
#4	Camrynn Dilley Sally Chung Daniel Santoyo	Tuesday, 8/24 at 3:00 PM
#5	Mohammad Zahed Aminreza Hajiasgari Krupa Patel	Tuesday, 8/24 at 3:30 PM
#6	Anthony Shenouda Christian Trujillo Timur Dzhavadov	Monday, 8/23 at 3:30 PM
#7	Osher Boudara Alexis Diaz	Monday, 8/23 at 4:00 PM
#8	Ibtehaz Utsay Hongpeng Yan Ramona K Yaghoubi	Friday, 8/27 at 1:45 PM
#9	Teresa Doan Brittany Dakoske Sathya Govindarajan	Saturday, 8/21 at 12:00 PM
#10	Christopher L. Delgado Amanjot Ubhi	Tuesday, 8/24 at 3:20 PM