Database Management Systems

Paper Code: 
BIF 225
13.00
Unit I: 
Basic Concept

An Introduction to database System, Basic Data System Terminology, Purpose of DBMS, Data Independence, An Architecture of DBMS: Schema, Subschema, mapping, Physical & Logical Data, Basic File Systems, File Organization: Sequential, Index Sequential, Hosting, B-Tree based index, File Organisation based on Dynamic Hashing with immediate splitting, Model of Real World, Details of E-R Model.

14.00
Unit II: 
Three Data Models

An Overview of three Main Data Models i.e. Hierarchical Model, Network Model, Relational Model and their Inter comparison, Concept of Relation, Relational Algebra: Basic Operation like Union, Intersection, Difference, Product Join, The relational Calculus: Domain & Tuple Calculus, Relational Database Design: Integrity Constraints, Functional Dependency: Single Value and Multi Value Functional dependency, Normal Forms: I, II, III, Boycee Codd, & IVth Normal forms; Join Dependency.

13.00
Unit III: 
Query Processing & Database Software

Query Interpretation, Equivalence of Expression, Estimation of Query Processing Cost, Query Optimization by Algebraic Manipulation, Join Algorithms, Types of Data Base Languages: Procedural and Non-procedural Language, Relational Commercial Query languages,QBE,

9.00
Unit IV: 
SQL implementation

SQL: Introduction, Basic Structure, the Power of SQL (Creation, Insertion, Deletion, Indexing & Modification of Databases in SQL), query optimization strategies.

11.00
Unit V: 
Management Considerations & Future Trends: Security & Integrity

Introduction, Access Control, Crypto Systems, Statistical DataBase Security; Concurrency Control: Transaction, Database System Architecture, Serializability, Locking, Database Recovery: Kinds of Failure, Recovery Techniques, Object, An Overview of Oriented Model, Distributed database: Structure, Tradeoffs, Design, Client Server Database, Knowledge databases.

ESSENTIAL READINGS: 

1. Abraham Silberschatz, Henry Korth, S. Sudarshan. “Database Systems Concepts”. 4th Edition, McGraw Hill, 1997. 2. R. Elmarsi and SB Navathe, “Fundamentals of Database Systems”, Addison Wesley, 4th Edition, 2004. 3. Henry F. Korth & A. Silbershatz. “Data Base System Concepts”. McGraw-Hill, New York, 1991. 4. Jeffrey O. Ullman. “Principles of Database System”. Galgotia Publishers, New Delhi. 1998

REFERENCES: 

1. A. K. Majumdar, P. Battacharya. “Data Base Management Systems’’. TMH, 1996. 2. Bipin Desai. “An Introduction to database Systems”. Galgotia Publications, 1991. 3. Arun K. Majumdar & P. Bhattacharya. “Data Base Management System”. Tata McGraw-Hill, 1996.

Academic Year: 
2018-2019
  • Printer-friendly version
  • PDF version