| Week |
Lab |
Content |
Download |
Notes |
| 2 [20/01/2017] |
|
Introduction |
|
|
| 3 & 4 |
OFF (TET holidays)
|
| 5 [10/02/2017] |
Lab 1
|
Entity Relationship Diagram (ERD) |
Lab 1 |
|
| 6 [17/02/2017] |
Lab 1 (cont.)
|
|
|
Assignment 1 Release |
| 7 [24/02/2017] |
Lab 2
|
Enhanced Entity Relationship Diagram (EERD) |
Lab 2 |
|
| 8 [03/03/2017] |
Lab 3
|
Relational Data Model |
Lab 3 |
|
| 9 [10/03/2017] |
Lab 4
|
Relational Algebra |
Lab 4 |
Assignment 1 Submission |
| 10 [17/03/2017] |
OFF
|
| 11 [24/03/2017] |
|
Assignment 1 Reporting |
|
|
| 12 [31/03/2017] |
|
Assignment 1 Reporting (cont.) |
|
Assignment 2 Release |
| 13 [07/04/2017] |
Lab 5
|
SQL |
Lab 5 |
PL/SQL Overview |
| 14 [14/04/2017] |
Lab 5 (cont.)
|
|
|
|
| 15 [21/04/2017] |
Lab 6
|
View – Store – Procedure – Trigger
|
Lab 6 |
|
| 16 [28/04/2017] |
Lab 7
|
Functional Dependencies & Normalization |
|
Assignment 2 Report Templates |
| 17 [05/05/2017] |
|
Review |
|
|
| 18 [12/05/2017] |
|
Assignment 2 Reporting |
|
|
| 19 [19/05/2017] |
|
Assignment 2 Reporting (cont.) |
|
|
