02-26-2015, 08:44 AM
DOWNLOAD ALL PREVIOUS YEAR PAPERS HERE of both old and new scheme
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.
- 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.