CS 508 DATABASE MANAGEMENT / CO 302 DATABASE SYSTEMS

The slides used for this course are modified versions of the slides downloaded from the web-site of George Mason University and from the web-site of the book "Database System Concepts" by Silberschatz, Korth and Sudarshan (4th and 5th edition)

Introduction

Database Systems Concepts and Architecture

Data modeling using the Entity-Relationship model

Enhanced Entity-Relationship model

Relational Model Concepts

ER/EER to Relational mapping

Structured Query Language

Functional Dependency and Normalization

Database Design Algorithms

Transaction Concepts

Concurrency Control

Database Architecture and Distributed DBMS

Distributed DBMS

FOR CO 302 DATABASE SYSTEMS ONLY (B.Tech)

File Organization

Indexed Sequential File

Indexing and Hashing

Dynamic Hashing

FOR CO 508 DATABASE MANAGEMENT ONLY (MCA)

Database Security

Database Recovery

Object Oriented DBMS

Query Processing and Optimization

Please go through the following topics for which lecture splide are not provided.