Lecture Notes 1

Lecture Notes 2

Lecture Notes 3

Lecture Notes 4

SQL Exercise 1

SQL Exercise 2

SQL Exercise 3

Normalization Examples

Another Normalization Example

SQL*Loader Tutorial

How to check if your SQL is using INDEX?

One-Page Summary of Basic DB Concepts

Learn SQL in One Hour

SQL*Plus Tutorial

SQL*Plus Tutorial

BIS Pass Exam 2001/2002

BIS Pass Exam 1999/2000


BIS 4222 Database Management Systems

(Course Code: ST06-803-04-02/02)

Time:

7pm- 10pm

bis4222@yahoo.com.hk
What is it?
BIS4222 is a 20 credit, middle level course. The success of many organizations depends upon information stored in database management systems. Given the importance of such systems it is essential that managers with responsibility for IT understand the underlying DBMS principles examined in this course. This unit serves to provide a perspective on database management system structure and functions. Database design and likely developments in database technology are also considered.

Brief Syllabus

A perspective on database management system structure and function is provided. Topics introduced include:

  • architecture of databases

  • data models: network, hierarchical, relational , Object-oriented,relational databases, normalization, front-end systems

  • database environment: security , recovery and concurrency data and database administration,object-oriented database systems,client-server and distributed database systems and research topics in DBMS.


Why do you need to visit this page?
  • You can know the lecture notes
  • You can know News Update if any.
News Update...
PowerPoint Download
  • Deadline for course work : 5 December 2002. Click here to download the coursework (Word document)