COSC809 Advanced Database systems

Syllables

A brief intoduction to database concepts: file systems and databases, the relational database model; design concepts and implementation: entity relationship(E-R) modeli ng; normalization of database tables and structured query language; database design and implementation. Transaction management and concurency control, distributed database management systems; databse privacy, security, failure and recovery. Object oriented databases; client/server systems; data warehouse; data mining; database in electronic comerce; web dataases development and database administration

Downloadable Material

Chapter 01 - Introduction: Databases and Database Users
Chapter 02 -Database System Concepts and Architecture
Chapter 03 - Data Modeling using the ER Model
Chapter 04 -Enhanced Entity-Relationship (EER) Model
Chapter 05 - The Relational Data Model and Relational Database Constraints
Chapter 06 - The Relational Algebra and Calculus
Chapter 07 -Relational Database Design by ER- and EERR-to-Relational Mapping
Chapter 08 - SQL 99: Schema Definition, and Queries and Views
Chapter 09 - Introduction to SQL Programming Techniques
Chapter 10 - Functional Dependencies and Normalization for Relational DBs
Chapter 11 - Relational Database Design Algorithms and Further Dependencies
Chapter 12 - Practical Database Design Methodology and Use of UML Diagrams
Chapter 13 - Disk Storage, Basic Files Structures, and Hashing
Chapter 14 - Indexing Structures for Files
Chapter 15 - Algorithms for Query Processing and Optimization
Chapter 16 - Practical Database Design and Tuning
Chapter 17 - Introduction to Transaction Processing Concepts and Theory
Chapter 18 - Concurrency Control Techniques
Chapter 19 - Database Recovery Techniques