MDU Syllabus | F-Scheme | CSE-202 F Database Management Systems
CSE-202 F Database Management Systems
SECTION A: Introduction, Client Server Arch., E-R Diagram and Keys
Overview of database Management System; Various views of data, data Models, Introduction
to Database Languages. Advantages of DBMS over file processing systems, Responsibility of
Database Administrator,
Introduction to Client/Server architecture, Three levels architecture of Database Systems, E-
R Diagram (Entity Relationship), mapping Constraints, Keys, Reduction of E-R diagram into
tables.
Section B: File Organization and Relational Model and Calculus:
Sequential Files, index sequential files, direct files, Hashing, B-trees Index files. Relational Model, Relational Algebra & various operations, Relational and Tuple calculus.
Section C; Introduction to Query Languages :
QLB , QBE, Structured query language – with special reference of (SQL of ORACLE), integrity constraints, functional dependencies & NORMALISATION – (up to 4th Normal forms), BCNF (Boyce – code normal forms)
SECTION D:
Introduction to Distributed Data processing, parallel Databases, data mining & data warehousing, network model & hierarchical model, Introduction to transaction, properties of transaction and life cycle of transaction, Introduction to Concurrency control and Recovery systems., need of concurrency control and recovery system, problems in concurrent transactions.
Text Books:
Database System Concepts by A. Silberschatz, H.F. Korth and S. Sudarshan, 3 edition, 1997, McGraw-Hill, International Edition.
• Introduction to Database Management system by Bipin Desai, 1991, Galgotia Pub.
Reference Books:
Fundamentals of Database Systems by R. Elmasri and SB. Navathe, 3 edition, 2000, Addision-Wesley, Low Priced Edition.
• An Introduction to Database Systems by C.J. Date, 7th edition, Addison-Wesley, Low Priced Edition, 2000.
• Database Management and Design by G.W. Hansen and J.V. Hansen, 2n edition, 1999, Prentice-Hall of India, Eastern Economy Edition.
• Database Management Systems by A.K. Majumdar and P. Bhattacharyya, 5th edition, 1999, Tata McGraw-Hill Publishing.
• A Guide to the SQL Standard, Date, C. and Darwen,H. 3rd edition, Reading, MA: 1994, Addison-Wesley.
• Data Management & file Structure by Looms, 1989, PHI
Related posts: