BCA Bachelor of Computer Applications Part 1 Database Management SystemUniversity 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 )
Subject-I : COMPUTER SCIENCE
PAPER-3DATABASE 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,