Advanced Database Management Systems

Course Contents, Concepts and Issues

Module 6

Essentials of Databases:

Relational Database Model and Languages, Database Analysis and Design

I. Background

• Introduction to Databases
• Database Environment
• Database Architectures and the Web

II. The Relational Model and Languages

• The Relational model
• Relational Algebra and Relational Calculus
• SQL: Data Manipulation
• SQL: Data Definition
• Query-By-Example (QBE)

III. Database Analysis and Design

• Database System Lifecycle
• Database Analysis and the DreamHome Case Study
• Entity–Relationship Modeling
• Enhanced Entity–Relationship Modeling
• Normalization
• Advanced Normalization

Module 7

Database Methodology, Selected Database Issues, Distributed Database management Systems (DBMSs) and Replication

IV. Methodology

• Methodology—Conceptual Database Design
• Methodology—Logical Database Design for Relational Model
• Methodology—Physical Database Design for Relational Databases
• Methodology—Monitoring and Tuning the Operational System

V. Selected Database Issues

• Security and Administration
• Professional, Legal, and Ethical Issues
• Transaction Management
• Query Processing

VI. Distributed DBMSs and Replication

• Distributed DBMSs—Concepts and Design
• Distributed DBMSs—Advanced Concepts
• Replication and Mobile Databases

Module 8.

Object Database Management Systems (DBMSs), Web and DBMSs, Business Intelligence Technologies

VII. Object DBMSs

• Object-Oriented DBMSs—Concepts and Design
• Object-Oriented DBMSs—Standards and Languages
• Object-Relational DBMSs

VIII. Web and DBMSs

• Web Technology and DBMSs
• Semistructured Data and XML

IX. Business Intelligence Technologies

• Data Warehousing Concepts
• Data Warehousing Design
• OLAP
• Data Mining