MCA -Master of Computer Applications Second Semester Database Management Systems

University Syllabus and Classes of MCA Second Semester DBMS

Atlanta Computer Institute Conducts Tuition Classes for MCA Semester 1 MCA Semester 2 MCA Semester 3 and MCA Semester 4. We also provide final year Projects of MCA Students and guidance for Final Year Projects with Certificates.



Unit-1: Database   concept- Introduction , Data, Information  Metadata, Terminology Of  File, Association Between Fields, Entities And Their  Attributes, Relationship Record And Files, Abstraction  And Data  Integration, Association Between Files( Record Types), Conventional File Processing System,Database  System, Components Of Database  Management  System – (  Classification Of DBMS  Users, The Tree-Leve  Architecture  Proposal For DBMS, Mapping Between View, Data Independence.

Unit-2 : Data Models- Introduction , Data Association-(Entities, Attributes And Associations, Relationship Among Entities, Representation  Of Association  And  Relationship), Data Model Classification-(Approaches To The Relational  Model, Hierarchical Model & Network Model Withan Examples), Entity – Relationship Model,

Concept Of File Organization – Sequential Files, Index-Sequential Files, Direct Files,Secondary Key Retrieval.


Unit-3: The  Relational  Model- Introduction,

Relational  Database:  Attributes And Domains, Tuples, Relation And Their Schemas Relation  Representation,Keys, Relationship , Relational Operations, Integrity Rules.

Relational Algebra:  Basic Operations,Relational Algebra Queries , Relational Calculus: Tuple Calculus, Domain  Calculus.

Relational Database Manipulations: Introduction, Sql, Data Manipulations In Sql, QUEL, Data Manipulations In QUEL,QBE , Data Manipulations In Qbe.

UNIT-4: Relational  Database Design- Relational Schema, Relational Design, Functional Dependency, Normalization, First –Second- Third  Normal Forms, Relational  With  More Than One Candidates Key ,Good And  Bad Decomposition, Multivalued  Dependency, Fourth  Normal   Form, Fifth  Normal  Form.

Network  Data Model:  The Architecture Of Dbtg System, Schema  &  Subshcema , And DBTG  Data Manipulation Facility.


Hierarchical Data Model: The Tree Concept, Architecture Of Anims System , Data Manipulation.

UNIT -5 : Database Operations And Maintence – Database Administrator (DBA, Database Security, Integrity And Control (User With Password And Complete / Limited Authorization, Encryption Of Data).

 Concurrency Control : Problem Of Concurrent Access, Resource Looking, Deadlock.

Database Recovery : Restore, Backward & Forward Recovery.

Distributed Database : Introduction, Data Distribution, Deadlock In Distributed Systems, Security, Security And Protection, Homogeneous And Heterogeneous Systems.  Knowledge Base And Database Systems, Expert Database Systems, Object Database System.



MCA First Year Semester 2 Syllabus Nagpur University


1. Data Structures

2. Database Management Systems

3. Discrete Mathematics and Graph Theory

4. Java Programming

5. Statistics and Numerical Mathematics



BCA Bachelor Of Computer Application, BCCA, Bachelor of Commerce & Computer Application BE IT/CS, Information technology/Computer Science MCA, Master of Computer Application MCM, Master of Computer Management Diploma , Polytechnic Others,

Basic Programming

C / C++ ,


Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2017 All Right Reserved - Atlanta Computer Institute, Nagpur. Site Map