|
| |
ASSUMPTION UNIVERSITY
FACULTY OF ENGINEERING
COURSE OUTLINE 1/2008
|
Subject |
: |
CE 4107 Database Management System |
|
Prerequisite |
: |
CE 2101 Introduction to Data Structure |
|
Lecturer |
: |
Naresh Srikalra |
Objective
|
: |
The objective of
this course is to provide a study of various database models (such as
hierarchical, network, and relational) and theories of database design. Also
data description languages, query facilities, data integrity, and file
security with the introduction of latest trends such as Object-Oriented
Database, Database in E-commerce and Web Database Development. |
Textbook
|
: |
Database Systems: Design,
Implementation, & Management,
Peter Rob
and Carlos Coronel, Eight Edition, Thomson Learning 2008 |
Mark Allocationtion
|
: |
Midterm
30 %
Final
60 %
Assignment/Project 10 % |
|
|
|
|
|
Week |
Topics |
|
1 |
Introduction to
Database Systems |
|
2 |
Data Models:
Evolution, Building Blocks of Data Models,
Degrees of Data Abstraction |
|
3 |
The
Relational Database Model: Keys, Integrity Rules, Data Dictionary &
Catalog, Relationships, Data Redundancy Revisited, Relational
Database Operators |
|
4 |
Entity
Relationship (E-R) Modeling: Data Models, ER Model, Symbols |
|
5 |
Normalization of Database Tables:
Database Design, Normalization, De-normalization |
|
6 |
Database Design: System Development Life Cycle, Database Life Cycle |
|
7 |
The Data
Warehouse
Data
Analysis, OLAP, Star Schemas, Implementation and Data Mining |
|
|
Mid Term Examination |
|
8 |
Project Topics Discussion
Structured Query Language (SQL): Data Definition, Data Management,
Queries |
|
9 |
Advanced Structured Query Language (SQL): SQL Functions & Procedural
SQL |
|
10 |
Transaction Management and
Concurrency Control
Transaction, Concurrency Control, Recovery |
|
11 |
Distributed
Database Management Systems
Evolution, Components, Transparency, Optimization, Fragmentation,
Replication |
|
12 |
Database Performance Tuning & Query Optimization |
|
13 |
Object-oriented
Databases
Evolution, Characteristics, OODM, OODBMS |
|
14 |
Database
Connectivity & Web Development: Internet Databases, ColdFusion, XML
Database Administration |
|
15 |
Project Presentation
& Review |
|
|
FINAL EXAMINATION |
|
