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, WEST HIGH COURT ROAD,  DHARAMPETH,
NAGPUR -10, MAHARASHTRA, INDIA. 
NAGPUR
Mobile:  90281 57794
               9595 321479
Tel: 0712-2557946
INDIA

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

University Syllabus Course For BCA Part 1  DBMS 

Atlanta Computer Institute Nagpur conducts Tuition Classes for BCA First Year (  Part 1 ) , BCA  Second Year (   Part 2  ) and BCA Final Year ( Part 3 ) for all universities in India . The Following syllabus is of Nagpur University.  Final Year Projects Training is also given to  BCA  Students.
BCA Bachelor of Computer Applications   Part 1 Database Management System

 BCA Part 1 ( First Year ) 

Subject-I  :  COMPUTER SCIENCE

PAPER-3 DATABASE   MANAGEMENT   SYSTEM

UNIT-1:   Database  Concept

Introduction, data , information, metadata, terminology of  file, association   between  fields, entities   and  their  attributes, Relationship  records  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  user, DBMS   facilities,  structure of DBMS, The three level  architrcure   proposal for  DBMS, MAPPING  between  views, data   independence

 UNIT-2:  Data  models

Introduction,data  association –( entities, Attributes   and   association   and   relationship  among  entities , representation of association  and    relationship)data model  classification-(Approaches to the relationa   model,Hierarchical   model  & netowork  model  with  an examples) , entity- Relationship model. Concepts  of  file  organization-  sequential  files, index- sequential files, direct  file, secondary  key  Retrieval.

 UNIT-3:  The  Relational   model

Introduction, Relational   Database:  Attributes and domains, tuples,  relation  and their schems, 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 manipulation i N QUEL, QBE , Data  Manipulations IN QBE.

UNIT -4  :   Relational   database design

Relational  schema  and relational   design, functional   dependency, normalization  ,first  second , third  normal  forms, relationa    with  more  than  oe  candidate  key, good  and bad  decomposition,  multivalued  dependency, fourth  normal  form   Network  data   model:  the architecture  of DBTG  system, Schema  and sub schema  and  DBTG  DATA  manipulation  facility. Hierarchical   data  model: the  tree  concepts,  Architecture of an IMS System, data manipulation

Unit -5    Datbase Operation   And Maintenance

Database  Administrator( DBA) , database security , integriry  and  control (  user  with  password  and complete /ltd .authorisation  Encryption   of  data) concurrency   Control: problem  of concurrent  acesss, rsource  locking, deadlock  . database   recovery: restore , backword  &  forward   recovery.  Distributed    Database:  introduction ,data distribution, deadlock  In distributed  system, security   and protection,homogeneous  and  heterogeneous   Systems, knoweleg  base and database  Systems, expert database   systems, object  database  system.

 

 

 

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 Coaching Institute Web Design and Development Courses
Advance Accounting Courses Short Term Computer Course Design and Animation Courses Job Oriented Courses Professional Courses Nagpur University Classes and Syllabus of BCA BCCA MCM MCA BE Diploma
Short Term Courses

Programming & Database

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

Testing

Software Testing

Hardware & Networking

CCNA
MCITP
Hardware
Networking

Web Designing

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

.Net

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

Basic Courses

MS-CIT
English Speaking
Interview SkillS
Personality Development
MS-Office

AutoCAD

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

Computer Application

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
Taxation
Tally 9 ERP
Share Market

 Tuition Classes

      BCCA
      BCA
      MCM
      MCA
      Polytechnic
      BE