H6328

Database Management Systems

 

Course Director : Dr. Suliman Hawamdeh

Lecture/Tutorials: Monday, 1800 - 2145

Course Description

This course is an introduction to database management systems. It covers database design and management with emphasis on database principles, which are constants across different software products. It provides an overview of the design and implementation of organizational databases and the role of DBMS in an information system. Students will learn about the main data models, data modeling and database design appropriate to information agencies. Students will have hands on experience designing and implementing an application using selected database management software.

Course Objectives

  1. Understand the concepts and principles of database management system.

  2. Have a basic knowledge of database management

  3. To understand and apply the principles of data modeling and database design when developing applications to support the organizational operation and decision management.

  4. Understand and compose queries in structured query language SQL

  5. To understand the current trends in databases and the role of DBMS in new technologies such as document imaging and the Internet/Intranet.

Course Schedule

Class

Date

Topic

1

13/7/98

Introduction to DBMS

  • The evolution of database systems
  • The architecture of a DBMS
  • The future of a DBMS
  • Applications of DBMS

2

20/7/98

Database Modeling

  • Introduction to ODL
  • Entity relationship diagrams
  • Design principles
  • Subclasses
  • The modeling constrains

3

27/7/98

The relational Data Model

  • Basics of relational model
  • From ODL design to relational design
  • From E/R diagram to relational design
  • Converting Subclass Structure to Relation

4

3/8/98

The relational Data Model

  • Functional dependencies
  • Design and relational schema
  • Multi-valued dependencies

5

10/8/98

Operations in Relational Model

  • Relational operations
  • Logic for relations
  • Constraints on relations

6

17/8/98

Database Language

  • Query by Example
  • Structured Query Language SQL
  • Data definition Language DDL
  • Data manipulation Language DML

7

24/8/98

The Structured Query Language

  • Simple queries in SQL
  • Queries involving more than one relation
  • Sub-queries, Duplicates, aggregation

8

31/8/98

The Structured Query Language

  • Constrains and triggers in SQL
  • System Aspects of SQL
  • Transactions in SQL

9

14/9/98

Object Oriented Query Language

  • Introduction to OQL
  • Query relation feature of ODL
  • Additional forms of OQL expressions

10

21/9/98

Open Database Connectivity ODBC

  • What is ODBC
  • ODBC Architecture
  • ODBC Utilization
  • The future of ODBC

11

28/9/98

Web Access to Databases

  • Overview of the WEB
  • WEB Server
  • Gateway software
  • Performance and security
  • Web database tools

12

5/10/98

Introduction to Client/Server

  • Client /server definition
  • Triggers and Procedures
  • Distributed data

13

12/10/98

Database Trends and applications

  • Data warehousing and data mining
  • Document Imaging

 

References:

Recommended Text:

Ullman, J. D. and Widom J. A First Course in Database Systems. International Edition, Prentice Hall, 1997.

Optional Readings:

Connolly, T .M. Begg, C. E. and Stratchan, A. D. Database Systems. Addison-Wesly, 1996.

Kroenke, D. M. Database Processing: Fundamentals, Design, and Implementation. (6th edition). Printice-Hall.

 Other Readings on SQL Server and MS Access databases are recommended.