RHS -> Allan-> ADAB ->Semester plan

Semester plan
Advanced Databases
... using Oracle 10g EE
4th semester - Spring 2008

Plan is subject to change without notice
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.
Lab Activity 2, p. 96.

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
Maybe you'd need to skim Chap. 10 - 13 as background knowledge..

 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 new
Week 15
07.04-13.04		 System catalog / dictionary, Security, Grant.... Chap. 09 (review)
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....
Maintained by: Allan Helboe
Updated: 16 April, 2008 9:58