C/C++ | Java | Advance Java | J2EE | Data Structure | Visual Basic | Oracle | SQL Server | Software Testing | CCNA | CCNP | CCIE | MCITP | Hardware | Networking | HTML / CSS | JavaScript / XML | Dreamweaver | Ethical Hacking | PHP & My SQL | VB.Net | ASP.Net | C#.Net | SQL Server | MS-CIT | English Speaking | Specialized Courses | Foreign Education | Personality Development | Auto CAD 2D | Auto CAD 3D | STAAD Pro | REVIT | ARCHI CAD | 3D Studio Max | Uni-Graphics NX | Ansys | Pro-E / Creo | CATIA | CAD CAM | MS-Word | Excel | Powerpoint | Access | Internet and Email | Animation | Photoshop | Corel Draw | Illustrator | Premiere | Flash | 2D Max / 3D Max | Maya 2D / 3D Maya | Pinnacle | Graphics Design | Basic Advance Accounting | Costing & Auditing | Import and Export | Taxation | Tally 9.0 ERP | OCA / OCP | BCA | BCCA | MCA | MCM | Polytechnic | Distance Learning | Industrial Accounting | Share Market | SEO | Digital Marketing | Autocad Electrical
Contact information:
ATLANTA COMPUTER INSTITUTE
SECOND FLOOR,
SHIVAJI COMPLEX,
NEAR COFFEE HOUSE AND BANK OF BARODA,WHC ROAD, DHARAMPETH,
NAGPUR-10, MAHARASHTRA, INDIA.
NAGPUR  
Tel: 0712-2557946
Mobile: 9595 321479

ATLANTA COMPUTER INSTITUTE
SECOND FLOOR, SELOKAR BHAVAN
Opp. PETROL PUMP AND SANGAM SWEETS
MEDICAL SQUARE,
NAGPUR-09, MAHARASHTRA, INDIA. 
NAGPUR
Tel: 0712-2701833
Mobile: 9595 321479
Email: atlantaworld@gmail.com
www.atlantacomputer.in

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.
MCA -Master of Computer Applications Second Semester Database Management Systems

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

 

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++ ,

Testing

Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking
Join our newsletter:
Course Offers
Dot Net Courses Java Coaching Classes Autocad and CAD Training Institute Web Design and Development Courses
Advance Accounting Training Short Term Computer Course Design and Animation Courses Job Oriented Courses Professional Courses Nagpur University Syllabus and Classes for MCA MCM BCA BCCA BE Poly Diploma
Short Term Courses

Programming & Database

C / C++
Java
Advance Java
J2EE
Data Structure
Visual Basic
Oracle
SQL Server

Testing

    Software Testing
ISTQB

Hardware & Networking

CCNA
MCSE
Hardware
    Networking

Embedded Systems

Web Designing

HTML / CSS
JavaScript / XML
Dreamweaver
Frontpage
   PHP & My SQL
Joomla
     WordPress

.Net

VB.Net
ASP.Net
C#.Net
SQL Server

Basic Courses

MS-CIT
English Speaking
Interview SkillS
Personality Development

AutoCAD

AutoCAD
STAAD Pro
REVIT
ARCHI CAD
3D Studio Max
Uni-Graphics
Ansys
Pro-E
CATIA

Computer Application

   MS-Office
MS-Word
Excel
Powerpoint
Access
Internet and Email

Animation & Multimedia

Photoshop
Corel Draw
Illustrator
Premiere
Flash
2D Max / 3D Max
Maya 2D / 3D Maya
    Pinnacle
Advance Animation

Advance Accounting

Basic Advance Accounting
Costing & Auditing
Import and Export
Direct / In Direct Taxes
Tally 9.0
Portfolio Management