| Lecture | Date | Topics | Text Chapters | Links |
|---|
| 1.1 |
30 March |
Course overview. Relational and SQL in a nutshell. SQL by rote. |
|
examples |
| 1.2 |
1 April |
DBMS Architecture. Data Models. DDL and DML. Relational Model. |
1, 2, 5 |
|
| 2.1 |
6 April |
Relational Model. Constraints. Referential integrity. |
5 |
|
| 2.2 |
8 April |
Relational algebra and tuple calculus. |
6 |
|
| 3.1 |
13 April |
Relational algebra and tuple calculus. |
6 |
|
| 3.2 |
15 April |
SQL. |
8 |
Borja's SQL wiki |
| 4.1 |
20 April |
SQL. Views. Aggregation. Triggers. |
8, 24.1 |
|
| 4.2 |
22 April |
Entity-Relationship Model |
3 |
|
| 5.1 |
27 April |
ER --> Relational Translation |
7 |
|
| 5.2 |
29 April |
MIDTERM TEST |
1-3, 5-8, 24.1 |
|
| 6.1 |
4 May |
Web DB and PHP |
26 |
examples |
| 6.2 |
6 May |
Web DB and PHP |
26 |
|
| 7.1 |
11 May |
Query Optimization |
15 |
|
| 7.2 |
13 May |
Query Optimization |
15 |
|
| 8.1 |
18 May |
Functional Dependencies. |
10 |
|
| 8.2 |
20 May |
Armstrong's Axioms. FDs and normal forms. 2NF, 3NF, BCNF. |
10 |
Kent paper on Normal Forms |
| 9.1 |
25 May |
Decomposition. |
11 |
|
| 9.2 |
27 May |
Transaction Processing. Serializability. |
17 |
|
| 10.1 |
1 June |
FINAL TEST |
All the above |
|