| Lecture | Date | Topics | Text Chapters | Links |
|---|
| 1.1 |
31 March |
Course overview. Relational and SQL in a nutshell. |
|
examples |
| 1.2 |
2 April |
DBMS Architecture. Data Models.
Relational Model. Constraints. Referential integrity. |
1, 2, 5 |
|
| 2.1 |
7 April |
Relational Alegbra |
6 |
|
| 2.2 |
9 April |
Relational Algebra. Relational tuple calculus. |
6 |
|
| 3.1 |
14 April |
Relational tuple calculus. SQL |
6, 8 |
Borja's SQL wiki |
| 3.2 |
16 April |
SQL. |
8 |
|
| 4.1 |
21 April |
SQL. Views. Triggers. |
8, 24.1 |
|
| 4.2 |
23 April |
Physical organization. Query Optimization. |
13, 14, 15 |
|
| 5.1 |
28 April |
Query Optimization. |
15 |
|
| 5.2 |
30 April |
MIDTERM TEST |
1-2, 5-6, 8, 13, 14, 24.1 |
|
| 6.1 |
5 May |
Entity-Relationship Model |
3 |
|
| 6.2 |
7 May |
ER -> Relational Translation. |
7 |
|
| 7.1 |
12 May |
Web DB and PHP |
26 |
examples |
| 7.2 |
14 May |
More web DB and PHP |
26 |
|
| 8.1 |
19 May |
Functional Dependencies. |
10 |
|
| 8.2 |
21 May |
Armstrong's Axioms. FDs and normal forms. 2NF, 3NF, BCNF. |
10 |
|
| 9.1 |
26 May |
Decompostion. |
11 |
|
| 9.2 |
28 May |
Transaction Processing. Serializability. |
17 |
|
| 10.1 |
2 June |
FINAL TEST |
all the above |
|