DMS database management system papers and NOTES with syllabus MDU BTECH free download

[admin]

DOWNLOAD ALL PREVIOUS YEAR PAPERS HERE of both old and new scheme

• DOWNLOAD PAPER OF YEAR 2009
  
  
• DOWNLOAD PAPER OF YEAR 2010
  
  
• DOWNLOAD PAPER OF YEAR 2011
  
  
• DOWNLOAD PAPER OF YEAR 2012
  
  
• DOWNLAOD PAPER OF YEAR 2013
  
  
• DOWNLOAD PAPER OF YEAR 2014
  
  
• DOWNLOAD PAPER OF YEAR 2015
  
  
• DOWNLOAD PAPER OF YEAR 2016
  
  
• DOWNLOAD PAPER OF YEAR 2017
  
  

SYLLABUS:-

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, ER 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.

Part Time Work For Students

Win Free Netflix Account