Who When Where and What |
- Lecturer: Sasakthi Abeysinghe
- Location: 5LA
- Time: Tuesday 5.30pm - 7.30pm
-
- Office Hours : By Appointment
|
| This class discusses advanced features of Oracle PlSql, Object Oriented Databases, Data Warehousing,
Data Mining, OLAP, and Distributed Transaction Processing |
Grade Calculation |
- Coursework (40 %)
- Assignment (20 %)
- In-Class Test (20%)
- Final (60%)
- A: 70 - 100
- B : 60 - 69
- C : 50 - 59
- D : 40 - 49
- F : 0 - 39
|
|
Coursework |
- Tutorial 1
[handout]
[sample solution]
- Tutorial 2 (Discussed in class)
- Tutorial 3
[handout]
- Group Assignment - Fly-on-wheels
[handout]
- Assignment Groups
[handout]
- Issue Date: 26th Jan 2005
- Hand-In Date: 01st March 2005
- All assignments handed in after the hand-in date will incur a penalty.
|
Lecture Notes |
| Course Syllabus and Learning Outcomes
[handout] |
- SQL Basics
[handout]
- PLSQL Basics
[handout]
- SQL in PLSQL
[handout]
- Connecting to Oracle
[handout]
- Introduction to DB and ER Modelling
[handout]
- Object Orientation and Class Diagrams
[handout]
- Relational Model and Object Database Management Systems
[handout]
- Distributed Databases
[handout]
- Data Warehousing
[handout]
- Data Warehousing 2
[handout]
- Data Mining
[handout]
- Artificial Intelligence in Data Mining
[handout]
|
|
