CS7380/4380 DATABASE MANAGEMENT SYSTEMS - I

Syllabus

Overview:    Fundamental concepts of current database systems with emphasis on the relational model. Topics include entity-relationship model, relational algebra, query by example, indexing, query optimization, normal forms, crash recovery, web-based database access, and case studies. Project work involves a modern DBMS, such as Oracle, using SQL.

Textbook:    Require: Database Management Systems, 3rd Edition, by Raghu Ramakrishnan and Johannes Gehrke, McGraw Hill, ISBN 007-2465638, 3rd Edition, 2003.
Reference: Oracle9i: The Complete Reference, by Kevin Loney and George Koch, Oracle Press, ISBN 0072225211.

        
Prerequisites:    CS 3380

1.    Topics:    Introduction
2.    ER Model
3.    Relational Model - I
4.    Relational Model - II
5.    Relational Algebra - I
6.    Relational Algebra - II
7.    Lab
8.    Recitation Section for Relational Algebra
9.    SQL - I
10.    SQL - II
11.    Indexing I & Triggers
12.    Indexing II
13.    Evaluation of Relational Operator - I
14.    Evaluation of Relational Operator - II
15.    Review for Exam 1
16.    Exam 1
17.    Relational Query Optimizer I
18.    Relational Query Optimizer II
19.    Normal Forms I
20.    Normal Forms II
21.    Normal Forms III
22.    Decomposition and Dependency Preserving
23.    DBS Design and Tuning
24.    Transaction Management
25.    Security and Backup
26.    Intro to Search Engine
27.    Exam 2: Comprehensive
28.    Advanced Topics
29.    Final Project Demonstration


Prepared by:    Chi-Ren Shyu    

Date:    September 2004

 Fundamental concepts of current database
systems with emphasis on the relational model.
Topics include entity-relationship model,
relational algebra, query by example, index-
ing, query optimization, normal forms, crash
recovery, web-based database access, and
case studies. Project work involves a modern
DBMS, such as Oracle, using SQL. Prerequi-
site: CS 3380.