DATABASE MANAGEMENT SYSTEMS (DBMS) WITH SAMPLE QUESTION PAPERS: Database Management Systems (DBMS)

What Does Database Management System (DBMS) Mean? A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure.

UNIT I INTRODUCTION TO DBMS
File Systems Organization - Sequential, Pointer, Indexed, Direct - Purpose of Database System-
Database System Terminologies-Database characteristics- Data models – Types of data
models –Components of DBMS- Relational Algebra. LOGICAL DATABASE DESIGN: Relational
DBMS -Codd's Rule - Entity-Relationship model - Extended ER Normalization – Functional
Dependencies, Anomaly- 1NF to 5NF- Domain Key Normal Form – Denormalization
UNIT II SQL & QUERY OPTIMIZATION
SQL Standards - Data types - Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static
Vs Dynamic SQL - QUERY OPTIMIZATION: Query Processing and Optimization - Heuristics
and Cost Estimates in Query Optimization.
UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL
Introduction-Properties of Transaction- Serializability- Concurrency Control – Locking
Mechanisms-Two Phase Commit Protocol-Dead lock.
UNIT IV TRENDS IN DATABASE TECHNOLOGY
Overview of Physical Storage Media – Magnetic Disks – RAID – Tertiary storage – File
Organization –Organization of Records in Files – Indexing and Hashing –Ordered Indices – B+
tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing - Introduction to
Distributed Databases- Client server technology- Multidimensional and Parallel databases-
Spatial and multimedia databases-Mobile and web databases- Data Warehouse-Mining- Data
marts.
UNIT V ADVANCED TOPICS
DATABASE SECURITY: Data Classification-Threats and risks – Database access Control –
Types of Privileges –Cryptography- Statistical Databases.- Distributed Databases-Architecture-
Transaction Processing-Data Warehousing and Mining-Classification-Association rules-
Clustering-Information Retrieval- Relevance ranking-Crawling and Indexing the Web- Object
Oriented Databases-XML Databases.