BCA Bachelor of Computer Applications Part 1 Database Management System

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 Part 1 ( First Year )



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


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