Course Description and Outline

Course Description:             This course gives the students a closer look at the most commonly used Database Management Systems (DBMS). Emphasis is     on DBMS that are publicly available through the GNU General Public License (GPL) and are widely used in a variety of private and commercial implementations. Topics include database design, Structured Query Language (SQL), client-server architecture, web database development and desktop applications, transaction processing, and database administration.

General Objectives:  At the end of the semester, the student must:

a)      Understand the importance DBMS in business software solutions;

b)      Understand the database design process;

c)      Know how to build a business-oriented and web-based database implementation;

d)      Understand transaction processing;

e)      Know how to manage and administer a database system;

f)       Learn the emerging database technologies.

OUTLINE

1.  Review on Database concepts, data and relational models. 

2.  Relational Database Design Process

3.   Structured Query Language (advanced)

4.  The Client-server architecture

5.  Transaction Processing, Concurrency, Recovery and Security

6.  Emerging Trends in Database Technology

Reference Book:

Elmasri, R. and Navathe, S.B., Fundamentals of Database Systems, Int Edition, Addison Wesley, 2003. ISBN: 0321204484.