Current Teaching 

Previous Teaching 

Research Interest

About Me

 

 

COMP305 (Database Management System)


Syllabus     Grading System

 

Lecture Notes

Assignments

Tests

Quizzes

Labs

Lec1_Introduction

Assignment1 (see on Lec1)

First Test

(Solution)

Quiz1

Lab1

Lec2_E-R_model

Assignment2 (Due on 29th March 09)

Lab2

Lec3 E-R model2

Lec4_Relational Model

Lec5_algebra

Lec5_Domain_calculus

Lec6_Intigrity

Sql_notes

Lec7_Functional_Depedency

lec8_ Normalization

Lec9_Transactions

Lec10_Serializability_Concurrency_Controll

Lec11_Recovery System

Lec12_Index_database

References:

Textbooks:

· A. Silberschatz, H. Korth, S. Sudershan, Database System Concepts, 4th Edition, MC Graw-Hill

· Ramakrishnan, J. Gehrke, Database Management Systems, Edition, McGraw-Hill

· C.J. Date, An Introduction to Database Systems, 8th Edition, PEA, 200

URLs

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/contents.html

JDBC and SQL

http://java.sun.com/j2se/1.3/docs/api/java/sql/package-summary.html

http://www.w3schools.com/sql/default.asp        

http://www.firstsql.com/tutor.htm

http://www.1keydata.com/sql/sql.html

http://saturn.cs.unp.ac.za/~michaelm/oracledocs/www.spnc.demon.co.uk/ora_sql/sqlmain2.htm

Relation Algebra

http://www.it.jcu.edu.au/Subjects/cp1500/resources/docs/introToRA.soln.html

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter3/node7.html