MCA -Master of Computer Applications Second Semester Database Management Systems
University Syllabus and Classes of MCA Second Semester DBMSAtlanta 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.
MCA FIRST YEAR ( SEMESTER -2 )
CSA-2 : DATABASE MANAGEMENT SYSTEMS
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
2. Database Management Systems
3. Discrete Mathematics and Graph Theory
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,
