Database Management Systems detailed Syllabus Scheme for Master of Computer Applications (MCA), 2017 regulation has been taken from the University of Mumbai official website and presented for the MCA students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.
For all other Mumbai University MCA 3rd Sem Syllabus 2017 Pattern, do visit MCA 3rd Sem 2017 Pattern Scheme. The detailed Syllabus Scheme for database management systems is as follows.
MCA301: Database Management Systems Syllabus for MCA 3rd Sem 2017 Pattern Mumbai University
Prerequisites:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.
Course Educational Objectives (CEO):
At the end of the course, the students will be able to
- Emphasize on basic concepts to organize, maintain and retrieve information from a DBMS.
- Cover the principles of database systems and recognize how they are used in developing data-intensive applications.
- To study an effective and efficient database system with the help of the rising trends of parallel and distributed databases.
Course Outcomes:
At the end of the course, the students will be able to
- Understand various database concepts and apply them in real life applications.
- Determine the manner in which data can be stored, organized and manipulated in a database system.
- Apply various indexing and optimization techniques to process queries.
- Analyze and design database applications using suitable database techniques.
1. Overview of DBMS
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier..
2. Database Design using ER Model and Relational Model
Overview of design process: Entity Relationship Model, Constraints, Entity relationship Diagram, Entity Relationship Design Issues, Weak Entity Sets, Extended ER features The Relational Model: Concepts of Relational Models, Integrity Constraints over Relations, Enforcing Integrity Constraints, Querying Relational data, Logical Database Design: ER to Relational with Case Studies 06
3. Normalization
Informal Design Guidelines for Relational Schema, Functional Dependencies Normal forms: First, Second, Third Normal Form and BCNF.Introduction to De-normalization. Inference Rules for Functional Dependencies, Equivalence of Sets of Functional Dependencies, Minimal Set of Functional Dependencies, Properties of Relational Decomposition-Dependency Preservation, Lossless Join. 08
4. Indexing
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier..
5. Query Evaluation and Transaction Management
Overview of Query Processing and Query Optimization, Query Evaluation Plans.Transaction Concepts, Transaction State, Implementation of Atomicity and Durability, Concurrent Executions, Serializability, Recoverability. Concurrency Control: Lock-Based Protocol, Timestamp-Based, Multi-version Schemes, Deadlock Handling Recovery: Failure Classification, Log Based Recovery 10
6. Parallel and distributed Databases
Parallel Databases: Architecture for Parallel Databases, Parallel Query Evaluation Distributed Databases: Types of Distributed Databases, Distributed DBMS Architecture, Storing Data in a Distributed DBMS, Distributed Transaction, Distributed Concurrency Control, Distributed Recovery 08
7. Object database systems
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier..
Reference Books:
- Korth, Silberchatz, Sudarshan, Databse system Concepts, McGraw Hill,2006
- Raghu Ramakrishnan, Johannes Gehrke,Database Management Systems, Third Edition, McGraw Hill2003.
- Elmasari and Navathe, Benjamin Cummins /Fundamental of Database System, Pearson Education,2009
- C. J. Date ,An Introduction to Database Systems, 8/e,Pearson Education,2002
- Rob Coronel /Database Systems Design, Implementation and Management, Cengage Publication,2009
- AtulKahate, Database Management SystemPearson Education. 2006
Assessment:
Internal: Assessment consists of two tests (T1 and T2) .The final marks should be the average of the two tests. End Semester Theory Examination: Guidelines for setting up the question paper.
- Question paper will comprise of total six questions.
- Question Number One should be compulsory.
- All question carry equal marks.
- Students can attempt any three from the remaining.
- Questions will be mixed in nature (for example supposed Q.2 has part a from module 3 then part b will be from any module other than module 3).
In question paper weightage of each module will be proportional to number of respective lecture hours as mention in the syllabus.
For detail syllabus of all other subjects of Master of Computer Applications (MCA), 2017 regulation do visit MCA 3rd Sem Subjects syllabus for 2017 regulation.