| Intro to DBMS’s, Relational Model, SQL Data Definition, XML |
1, 2.1–2.3 |
100% |
20200625 |
| Relational Algebra |
2.4, 5.1 |
100% |
20200627 |
| Introduction to SQL |
6.1–6.3 |
100% |
20200713 |
| Advanced Relational Algebra and SQL |
5.2, 6.4, 6.5 |
100% |
20200715 |
| Constraints and Triggers |
7 |
100% |
20201011 |
| SQL Transactions, Views, and Indexes |
6.6, 8 |
100% |
20201015 |
| Embedded SQL, PSM, PL/SQL |
9.3, 9.4 |
100% |
20201016 |
| JDBC, PHP, CLI |
9.1, 9.2, 9.5–9.7 |
100% |
20201016 |
| Semistructured Data, XML, DTD’s, XML Schema |
11 |
|
|
| XPath, XQuery |
12.1, 12.2 |
|
|
| More XQuery, XSLT |
12.3 |
|
|
| Functional Dependencies, Normalization |
3.1–3.3 |
|
|
| Inference of Dependencies, Multivalued Dependencies, 3NF, 4NF |
3.4–3.7 |
|
|
| Entity/Relationship Model |
4.1–4.6 |
|
|
| More E/R, UML, ODL |
4.7–4.10 |
|
|
| Authorization, Datalog, Recursive SQL |
10.1, 5.3, 5.4, 10.2 |
|
|
| Object-Relational SQL |
10.3–10.5 |
|
|
| OLAP, Data Cubes, Warehousing |
10.6, 10.7 |
|
|
