DATABASE MANAGEMENT SYSTEMS

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY ANANTAPUR.

MCA II-I Sem                                                                                                   

(9F00301) DATABASE MANAGEMENT SYSTEMS

UNIT I

Database Systems: Data vs Information-Introducing the Database and the DBMS-Why Database Design is Important-Files and File Systems-Problems with File System Data Management-Database Systems.

Data Models: Data Modeling and Data Models-The Importance of Data Models-Data Model Basic Building Blocks-Business Rules-The Evolution of Data Models-Degree of Data Abstraction.

UNIT II

Entity Relationship Modeling: The Entity Relationship Model (ERM)-Developing an ER Diagram-Database Design Challenges:Conflicting Goals-The Extended Entity Relationship Model-Entity Clustering- Entity Integrity: Selecting Primary Keys-Learning Flexible Database Design-Data Modeling Checklist.

UNIT III

The Relational Database Model: A Logical View of Data-Keys-Integrity Rules-Relational Set Operators-The Data Dictionary and the System Catalog-Relationships within the Relational Database-Data Redundancy Revisited-Indexes-Codd’s Relational Database Rules.

UNIT IV

Structured Query Language (SQL): Introduction to SQL-Data Definition Commands-Data Manipulation Commands-SELECT Queries- Advanced Data Definition Commands-Advanced SELECT Queries-Virtual Tables: Creating a View-Joining Database Tables.

Advanced SQL: Relational Set Operators-SQL Join Operators-Subqueries and Correlated Queries-SQL Functions-Oracle Sequences-Updatable Views-Procedural SQL-Embedded SQL.

UNIT V

Normalization of Database Tables: Database Tables and Normalization-The Need for Normalization-The Normalization Process- Improving the Design-Surrogate Key Considerations-Higher-Level Normal Forms-Normalization and Database Design-Denormalization.

UNIT VI

Transaction Management and Concurrency Control: What is a Transaction?-Transaction State-Implementation of atomicity and durability-Concurrency Control-Serializability-Testing for Serializability-Concurrency Control with Locking Methods-Concurrency Control with Time Stamping Methods-Concurrency Control with Optimistic Methods-Database Recovery Management-Validation Based Protocols-Multiple Granularity.

UNIT VII

Recovery System: Recovery and Atomicity-Log-Based Recovery-Recovery with Concurrent Transactions-Buffer Management-Failure with loss of nonvolatile storage-Advance Recovery Techniques-Remote Backup Systems.

UNIT VIII

File Structure and Indexing: Overview of Physical Storage Media-Magnetic  Disks-RAID-Tertiary Storage-Storage Access- File Organization-Organization of Records in Files-Data-Dictionary Storage-Basic Concepts of Indexing-Ordered Indices-B⁺-Tree Index Files-B-Tree Index Files-Multiple Key Access- Static Hashing-Dynamic Hashing-Comparison of Ordered Indexing and Hashing-Bitmap Indices-Indexed Sequential Access Methods (ISAM).

REFERENCES:

1. Database Management Systems, Peter Rob, A.Ananda Rao and Carlos Coronel, Cengage Learning.
2. Fundamentals of Database Systems, Elmasri, Navate, Pearson Education.

3. Introduction to Database Systems, C. J. Date Pearson Education.
4. Oracle for Professionals, The X Team, S. Shah and V. Shah, SPD.
5. Database Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA

       McGraw Hill 3^rd Edition.

6. Database System Concepts, Silberschatz, Korth, McGraw hill, V edition.
7. Database Systems Using Oracle: A Simplified guide to SQL and PL/SQL, Shah, PHI.
8. Fundamentals of Database Management Systems, M. L. Gillenson, Wiley Student Edition.