|
RHS |
Semester plan
Advanced Databases
... using Oracle 10g EE
4th semester - Spring 2008
| Date | Topic | Reading | Exercises (Click here for Solutions) |
| Week 05 28.01-03.02 |
Introduction Relational model, RDMS, Normalization |
Chap. 01 Chap. 02 |
Exercise 4, p. 18;
Exercise 8, p. 19; E-R Diagram Exercise, p. 36; Dependency Diagram Exercise, p. 36; Normalization Exercise, p. 36 (ignore DEPENDENTNO and let PK = (EMPID, DEPENDENTSSN) |
| Week 06 04.02-10.02 |
SQL using Oracle | Chap. 03 Chap. 04 Chap. 05 |
Install Oracle 10g Express Edition. |
| Week 07 11.02-17.02 |
SQL using Oracle | Chap. 06 Chap. 07 Chap. 08 |
Populate the tables with the example values shown on p. 61/62 (Hint: use scripts and work together: each student types a subset of the commands and then you collect it all into one file). Lab Activity 1, 2, 7, 8, p. 130. Lab Activity 1, 2, 6, 7, 8, 9, 14, 15, 17, 18, pp. 154-155 Extra : N2 exercise 01 |
| Week 08 18.02-24.02 |
Holidays | Catch up.... | Catch up.... |
| Week 09 25.02-02.03 |
Views | Chap. 09, pp.191 - 214 | Lab Activity 1, 2 p. 172 (ignore the remarks about spooling to a file) Lab Activity 1, 2 pp. 189-190 (ignore the remarks about spooling to a file) Lab Activity 1, 2, 8, 9, pp. 213-214 |
| Week 10 03.03-09.03 |
Assertions, Triggers | Chap. 14 pp. 328 - 334 |
Lab Activity 4, 5, 6 p. 337 |
| Week 11 10.03-16.03 |
Stored procedures | Chap. 14 pp 313 - 328 Maybe you'd need to skim Chap. 10 - 13 as background knowledge.. |
Lab Activity 1, 2, 3 pp 336-337 |
| Week 12 17.03-23.03 |
Holidays | Catch up.... | Catch up.... |
| Week 13 24.03-30.03 |
JDBC connection | Chap. 15 (only browse through the java code) | Oracle / Java 01 |
| Week 14 31.03-06.04 |
JDBC connection | ExtraExercise01 |
|
| Week 15 07.04-13.04 |
Chap. 16 |
Canceled | |
| Week 16 14.04-20.04 |
None | ||
| Week 17 21.04-27.04 |
None | ||
| Week 18 28.04-04.05 |
Synopsis start | Info Meeting Monday 28th April 10:15 in Danish, 11:00 in English |
|
| Week 19 05.05-11.05 |
Synopsis - Full time | Meet with your counselor | |
| Week 20 12.05-18.05 |
Synopsis - Full time | Meet with your counselor | |
| Week 21 19.05-25.05 |
Synopsis - Full time | Meet with your counselor | |
| Week 22 26.05-31.05 |
Exam preparation | Catch up.... | Catch up.... |