Instructor: Mirela Damian, Mendel 167A
|
|
Aug. | 27, | 29
| Course Overview (pdf). Assignments #1 out.
|
Sep. | 3, | 5
| Conceptual Data Modeling. Basic ER Diagrams.
(pdf).
|
Sep. | 10, | 12
| Towards more complex ER Diagrams (pdf).
|
Sep. | 17, | 19
| EER Models: Enhanced ER
(pdf)
|
Sep. | 24, | 26
| Relational Models (pdf).
Data Normalization (pdf).
|
Oct. | 1, | 3
| Data Normalization (contd.).
No class meeting on Thursday, Oct. 3.
|
Oct. | 8, | 10
| Basic SQL (pdf).
|
Oct. | 12 | - 20
| Fall Break
|
Oct. | 22, | 24
| SQL Aggregate Operations (pdf).
Hands-on (pdf)
|
Oct. | 29, | 31
| Advanced SQL (pdf).
Hands-on (pdf)
|
Nov. | 5, | 7
| SQL Hands-on Activities (handout distributed in class).
|
Nov. | 12 |
| Database Performance
(pdf).
PHP Environment
(html). Using MySQL with XAMPP
(html)
|
Nov. |   | 14
| Physical Database Design
(pdf).
A Database Driven Web Application (Part I,
html)
|
Nov. | 19, | 21
| A Database Driven Web Application (Part II,
html)
|
Nov. | 26 |
| Exam
|
Nov. | 27 | - 30
| Thanksgiving Break
|
Dec. | 3, | 5
| Database Protection and Recovery
(pdf)
|
Dec. | | 12
| Project Work
|
Presentations |
Poster Presentations
and Application Demonstrations on Friday, December 13, 11:30 am - 1:30 pm, Mendel 158.
|