Database Management System Question Paper

[gview file=””]

Database Management System

MCA301Database Management System
Subject CodeSubject NameTeaching Scheme (Contact Hours per week)Credits Assigned
MCA301Database Management System040404
Examination Scheme
TheoryTerm WorkPractOralTotal
Internal AssessmentEnd Sem. Exam.

[ Once in a semester ]

Test 1Test 2Average





The major objective of this subject is to provide a strong foundation in database concepts, technology and practice to the students to groom them into well-informed database application developers. The subject will emphasis on basic concepts, how to organize, maintain and retrieve–efficiently, and effectively–information from a DBMS.


Outcomes The students will be able to understand, appreciate and effectively explain the underlying concepts of database technologies. Design and implement a database schema for a given problem-domain, Normalize a database, Populate and query a database using SQL DML/DDL commands, Declare and enforce integrity constraints on a database, Worked successfully in a team by design and development of a database application system.

Unit No.                                                                      Contents                                                               No. of Hrs.


Unit I                Overview:   Overview   of   Database   management   system:   Limitation of  data processing environment, data independence, three levels of abstraction, data models, DBMS Architecture, people who with database, overview of conventional data models-Hierarchical, and Network models. Codd’s Rule, DBMS v/s RDBMS, Types Of databases.

Unit II              Entity    Relation    Model:    Entity,    attributes,    keys,    relation.    Cardinality, participation. Weak entities, ER Diagram Generalization Specialization and aggregation. Conceptual design with ER model. Entity v/s attributes. Entity v/s Relationship, Binary v/s ternary relationship. Aggregate v/s ternary relationship.

Studies –ER Diagram

Unit III             Relational Model: Introduction to relational model, Integrity Constraints over relation. Logical database design: ER to relational

Unit IV             Overview of Storage and Indexing: Storage hierarchies, Tree structured indexing and hash based indexing.

Unit V              Schema refinement and Normal Forms:    Functional      dependencies,      first, second, third, fourth and fifth normal form, BCNF, Comparison of 3NF and BCNF Lossless and dependency preserving decomposition, closure of dependencies, minimal closure

Unit VI            Query  Evaluation  Overview:  Overview  of  query  optimization,   Measures  of query cost, Evaluation of query, Query evaluation plans, relational optimization.

Unit VII           Transaction processing: Transaction concurrency control recovery of Transaction failure, Serilazibility, locking techniques. Granularity in locks. Time stamping techniques, two phase locking system, deadlock handling

Recovery, Types Of failure, Techniques of Recoverability

Unit VIII Security and Authorization: Introduction to database security, Issues, Control Measure, Grant and revoke. Permissions Access Control-Discretionary, Manadatory, Bell La Pedula Model, Audit Trail, Challenges in database security

4 Hrs

Unit IX             Case Study: One database application development (Oracle\SQL Server)              3 Hrs


Reference Books:

  1. Korth, Silberchatz, Sudarshan, “Databse system Concepts”, McGraw Hill ,2006
  2. RiniChakarabarti and     ShilbhadraDasgupta,     ,”Advanced    Database     Management     System                                “, Dreamtech,2011
  3. J. Date ,”An Introduction to Database Systems”, 8/e,Pearson Education,2002
  4. Rob Coronel ,”Database Systems Design, Implementation and Management”, Cengage Publication,2009
  5. Raghu Ramakrishnan, Johannes Gehrke ,”Database Management Systems”, Third Edition, McGraw Hill


  1. Mark Gillenson ,”Fundamental of Database System” ,Wiley Publication,2011
  2. Elmasari and Navathe, Benjamin Cummins ,”Fundamental of Database System”, Pearson  Education


  1. Murach,”Murach’s Oracle SQL and PL/SQL” ,SPD,2012
  2. S Deshpande ,”SQL & Pl\SQL for Oracle 11g Black Book”,Dreamtech,2011
  3. Sharnam Shah ,Vaishali Shah ,”Oracle for professionals” ,SPD,2011