| Week | Topic | Course Materials | Note |
|---|---|---|---|
| 1 | Course Overview | [syllabus] | |
| 2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 |
| 3 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
| 2-2 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 |
| 3 | SQL Practice - Part 1 |
|
|
| 4 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 |
| 5 | Transfer ER to Relational Schema | [slides] | Chapter 6 |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 | 1.Richard Phan, 2.Yevhen Mishchenko, 3.Matthew Valdivia | TBD |
| #2 | 1.Mahfuz Ahmed, 2.Fardad Ahmed | TBD |
| #3 | 1.Justin Scott, 2.Riley White | TBD |
| #4 | 1.Taksh Joshi, 2.Pushpak Khunt | TBD |
| #5 | 1.Carl Edora, 2.Martha Jauregi | TBD |
| #6 | 1.Brenda Caldera, 2.Esmeralda Munoz | TBD |
| #7 | 1.Francisco Anaya Esquivel, 2.lavanya Mahapatra, 3.Pablo Panduro Torres | TBD |
| #8 | 1.Stefan Juganu, 2.Lance Sierra | TBD |
| #9 | 1.Josiah Weber, 2.Richie Delgado, 3.Sean Lee | TBD |
| #10 | 1.Nhan Dinh, 2.Trong Dinh | TBD |