Engineering Tutorials

CSE-202 E Database Management Systems

Class Work: 50
Exam: 100

Unit–1:Introduction 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,

Unit-2: 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.

Unit-3: File Organisation: Sequential Files, index sequential files, direct files, Hashing, B-trees Index files.

Unit-4: Relational Model, Relational Algebra & various operations, Relational and Tuple calculus.

Unit-5: Introduction to Query Languages :QLB , QBE, Structured query language – with special reference of (SQL of ORACLE), integrity constraints, functional dependencies & NORMALISATION – (up to 4^th Normal forms), BCNF (Boyce – code normal forms)

Unit-6: Introduction to Distributed Data processing, parallel Databases, data mining & data warehousing, network model & hierarchical model, Introduction to Concurrency control and Recovery systems.

Text Books:

• Database System Concepts by A. Silberschatz, H.F. Korth and S. Sudarshan, 3^rd 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 S.B. Navathe, 3^rd edition, 2000, Addision-Wesley, Low Priced Edition.
• An Introduction to Database Systems by C.J. Date, 7^th edition, Addison-Wesley, Low Priced Edition, 2000.
• Database Management and Design by G.W. Hansen and J.V. Hansen, 2^nd edition, 1999, Prentice-Hall of India, Eastern Economy Edition.
• Database Management Systems by A.K. Majumdar and P. Bhattacharyya, 5^th 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

Note: Eight questions will be set in all by the examiners taking at least one question from each unit. Students will be required to attempt five questions in all.

Related posts:

1. MDU Syllabus | F-Scheme | CSE-202 F Database Management Systems
2. CSE-434 E Advanced Database Management Systems
3. PTU Syllabus | CS– 305 DATABASE MANAGEMENT SYSTEMS
4. CSE- 212 E Database Management Systems Lab
5. MDU Syllabus | F-Scheme | CSE- 212 F Database Management Systems Lab