Syllabus from January 2005

3 Credits

Objectives

This course will help the students to acquire the basic knowledge and practical skills relating to Relational Database Management Systems. After going through this course a student should be able to:

• Describe the Database and Database Management System advantages
• Describe the file organization schemes for DBMS
• Describe various types of index mechanisms for DBMS
• Create small client server applications
• Write SQL queries, create forms and queries
• Draw E R diagrams and design of databases
• Describe and use features for Recovery, Concurrency and Security in DBMS.

Syllabus

• The Database Management System Concepts: The file based system, The need of database, The structure of a database, Three level Architecture of databases, The need of three level architecture, the relational Model, The Entity relationship model, Conversion of ER diagrams to Relational Database, The database Integrity, functional dependency and Normalisation,, Conventional File Organisation, The sequential file organization, Index sequential, Hashing file organization, Multi key file organization and inverted files, Sparse and dense index, Index and B tree,  
• The Structured Query Language: What is SQL? The data definition of SQl,, the data manipulation through SQL, Views, Table handling, Nested Queries.
• Distributed and Client-Server Databases: Need for these systems, Advantages of the distributed and client server database systems, Data Replication, Fragmentation, Client server implementation examples, Distributed queries, Design issues of distributed and client server databases.
• Database Recovery: Transactions, States of Transactions, Checkpoints, Forward and Backward recovery, SQL commands for Recovery
• Concurrency Management: Concurrency Related Problems, Locks, Two Phased Locking, Deadlocks and its Prevention, Concurrency Control, SQL commands to control concurrency.
• Database Security: Security and Integrity, Authorization, Data Access Control, SQL commands for Security GRANT and REVOKE.
• CASE STUDY: Implementation of a Database solution to an Industrial Problem. The description may include: The Problem statement, The basic requirements, Analysis details, The ER diagrams, Realistic database design, Screens and reports, Some MIS oriented query implementation, Summary.