Database Management System
|MCA301||Database Management System|
|Subject Code||Subject Name||Teaching Scheme (Contact Hours per week)||Credits Assigned|
|MCA301||Database Management System||04||—||—||04||—||—||04|
|Internal Assessment||End Sem. Exam.
[ Once in a semester ]
|Test 1||Test 2||Average|
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
Unit IX Case Study: One database application development (Oracle\SQL Server) 3 Hrs
- Korth, Silberchatz, Sudarshan, “Databse system Concepts”, McGraw Hill ,2006
- RiniChakarabarti and ShilbhadraDasgupta, ,”Advanced Database Management System “, Dreamtech,2011
- J. Date ,”An Introduction to Database Systems”, 8/e,Pearson Education,2002
- Rob Coronel ,”Database Systems Design, Implementation and Management”, Cengage Publication,2009
- Raghu Ramakrishnan, Johannes Gehrke ,”Database Management Systems”, Third Edition, McGraw Hill
- Mark Gillenson ,”Fundamental of Database System” ,Wiley Publication,2011
- Elmasari and Navathe, Benjamin Cummins ,”Fundamental of Database System”, Pearson Education
- Murach,”Murach’s Oracle SQL and PL/SQL” ,SPD,2012
- S Deshpande ,”SQL & Pl\SQL for Oracle 11g Black Book”,Dreamtech,2011
- Sharnam Shah ,Vaishali Shah ,”Oracle for professionals” ,SPD,2011