BCA Bachelor of Computer Applications Part 2 Semester 3 RTM Nagpur University BCA Semester 3 Syllabus Course and Coaching Classes in Nagpur
Atlanta Computer Institute Nagpur conducts Tuition Classes for BCA First Semester Second Semester Third Semester Fourth Sem Fifth Sem Sixth Semester for all universities in India . The Following syllabus is of Nagpur University. Final Year Projects Training is also given to BCA Students.
BCA Part 2 Semester 3
1. VISUAL BASIC PROGRAMMING
2. DATA BASE MANAGEMENT SYSTEM
3. DATA STRUCTURES
4. OPERATIONS RESEARCH – I
5. WEB TECHNOLOGY - I
6. DIGITAL ELECTRONICS – I
B.C.A. Part II Semester III
Paper I
VISUAL BASIC PROGRAMMING
UNIT-I :
Working with Visual Basic Window Components: Menu Bar, Tool Bar, Project Explorer Window, Form Layout Window, properties Window, Toolbox, Code Editor Window Working with Forms: Properties, Events, Methods Working with Basic Controls:Label, CommandButton, TextBox, OptionButton, Frame, CheckBox, ListBox, ComboBox, Image, Scroll, Picture, Timer, DriveListBox, DirListBox, FileListBox and Shape Controls. Basic Programming Fundamentals: Variables, Data types, Constant, Conversion Function. Scope of Variable: Public, Private Static. Operators: Logical, Arithmetic, Concatenation, Comparison. Decision Structure: If.. Then, If..Then..Else, Select Case.. End Case. Loop Structure: Do..While, While.. Wend, For.. Next, With..EndWith. DoEvents()
UNIT-II :
Arrays: Dynamic Array, Preserve and Control arrays. Procedure: General procedure, General Methods for Passing Arguments to a Procedure, Functions: User-Interaction, String, Math, Date, Conversion Functions.
Modules: Form, Standard.
UNIT-III :
Menus: Creating, Adding Menu Items, Creating Shortcut, Adding Separators Bars, Submenus, Code for Menus. Creating Popup Menu: System, Custom. Database Handling: Database Concepts, Creating and Accessing Database, Using Data Control.
Using DAO: Creating Search Programs, Numeric Search and Complex Search Programs.
UNIT-IV :
Using ADO Data Control, Data Link, ODBC Data Source name, Using Connection String, Creating Navigating buttons. Working with Advanced Data Controls : DataList Control, DataCombo Control, DataGrid Control and Msflexgrid Control. Handling Errors : Run Time, Trapping and Handling Error, ERR Object. Data Environment and Data Reports.
Reference Books:
1. VISUAL BASIC – to Advance by Soma Dasgupta [BPB Publication]
2. Evangelos Petroutsos, Mastering Visual Basic 6.0 BPB Publication.
3. VISUAL BASIC 6 COMPLETE REFRENCE (TMH PUB)
4. Visual Basic 6 Deitel & Deitel (Pearson Education)
5. Mastering VB 6.0 Black Book -Peter - Norton-Techmedia.
B.C.A. Part II Semester III
Paper II
DATA BASE MANAGEMENT SYSTEM
UNIT- I :
DBMS : Definition: Databases, DBMS, Problems with traditional file processing system, Objectives of the database systems, Three level architectures of DBMS, Component of DBMS, Database Administrator, Database Users, Data model, Different types of data models, Concepts of Hierarchical, Network Models.
UNIT-II :
E-R Models : Basic Concepts, Entity, Attributes, Relation Ship, Mapping, Keys, Weak and Strong Entity Set, Problems on E-R Diagrams, Extended E-R Features: Specialization, Generalization, Aggregation, Problems on Reduction of an E-R Schema to Tables, Tabular representation of Strong, Weak entity Sets and Relationship Sets.
UNIT-III :
Relational Model: Structure, Relational Algebra, Fundamental Operations, Set –Intersection, Natural Join, Division and Assignment Operation. Extended Relational Algebra Operations, Aggregate Functions.
UNIT–IV :
Functional Dependency: Functional Dependency, Fully Functional Dependency, Partial Dependency, Transitive Dependency, Multi Valued Dependency.
Normalization, Normal Forms ( 1NF, 2NF, 3NF, BCNF, 4NF, 5NF). Problems on Normal forms.
Reference Books:
1. Data Base System Concepts By A SilbersChatz By Henry Korth And S.Sudarshan [Mcgraw-Hill ltd. New Delhi] 3rd Edition.
2. Introduction to Data Base Management by NAVEEN PRAKASH [Tata McGrawHill ltd.]
3. Bipin C. Desai, An Introduction to Database Systems, Galgotia Publications.
4. Raghu Ramakrishnan & Johannes Gerhrke, "Data Base Management Systems", Mc Graw Hill International Edition, 2000
5. Muzumdar, Introduction to Database Management Systems. TMH
B.C.A. Part II Semester III
Paper III
DATA STRUCTURES
UNIT - I :
LINKED LIST : Linked List, Representation of Single, Double, Header, Circular Single and Double Linked list, All possible operations on Single and Double linked List using Dynamic representation, Polynomial Representation and its Manipulation.
UNIT - II :
STACKS : Stacks terminology, Representation of Stacks in Memory, Operation on Stacks, Polish Notations, Translation of infix to postfix & prefix expression, Infix to Postfix Conversion, Evaluation of Postfix Expression, Recursion, Problems on Recursion, Quick Sort and Tower of Hanoi Problem.
UNIT - III :
QUEUE : Representation of Queues in Memory, Circular Queue. Dequeue and Priority Queue. Operations of above Structure using Array and Linked Representation.
SORTING AND SEARCHING: Selection Sort, Insertion Sort, Merge Sort, Efficiency of Sorting Methods, Big-O Notations.
Hash Tables, Hashing Technique, Collision Resolution Technique.
UNIT - IV :
TREES : Basic Terminologies, Representation of Binary Trees in Memory, Traversing of Binary tree, Binary Search Tree, Operation on Binary Search Tree, Heap Tree, Operation on Heap Tree, Heap Sort Method
GRAPHS : Basic Terminologies, Definition and Representation of Graphs in Memory: Linked List and Matrix Representation. Traversing graphs : BSF, DFS Method.
Reference Books:
1. Classical Data Structures : D. Samanta. PHI, New Delhi.
2. DATA STRUCTURE : LIPSCTUZ SCHUM OUTLINE SERIES
3. Data structure Using C++ : Y. Kanetkar
4. Data Structures Using C++: Tennenbaum
5. Data structures by Tremblay Sorenson
6. Data structures by Bhagat singh Naps
B.C.A. Part II Semester III
Paper IV
OPERATIONS RESEARCH – I
UNIT - I :
Introduction to Operation Research (OR) Origin and development of OR, Nature of OR, Characteristics of OR, Classification of Problems in OR, Models in OR, Phases of OR, Uses and Limitations of OR, Methodologies of OR, Applications in OR. Linear Programming – Concepts of Linear Programming Model, Mathematical Formulation of the Problem, Graphical solution methods.
UNIT - II :
Linear Programming Methods – Simplex Methods, Big M methods, Dual Simplex Method, TwoPhase methods. Duality in Linear Programming – Formulation of Dual Problem, Application of Duality.
UNIT - III :
Transportation Problem
Mathematical model for Transportation Problem, Types of Transportation Problem.
UNIT - IV :
Assignment Problem – Zero-One Programming Model for Assignment Problem, Types of
Assignment Problem, Hungarian Method, Branch and Bound Technique for Assignment
Problem.
Reference Books:
1. Operation Research by Kanti Swarup, P. K. Gupta, Man Mohan [Sultan]
2. Operation Research by R. Panneerselvam [PHI}
3. Introduction to Operation Research by Billy E. Gillet [TMH]
4. Operation Research by Hira Gupta
5. Operation Research Problems and Solutions by Sharma J. K. [MacMillan]
6. Operation Research Theory and Application by Sharma J. K., [MacMillan]
B.C.A. Part II Semester III
Paper V
WEB TECHNOLOGY - I
UNIT - I :
Introduction to Internet, History of Internet, Internet users, Internet working, Information on Internet, Requirements for connecting to Internet, Basic Internet Terms, Introduction to world wide web, Evaluation of world wide web, basic features, web browsers, popular web browsers, web servers, HTTP, URL, Search Engines, Search Engines categories, how to use Search Engines, Searching criterion.
UNIT - II :
HTML: Introduction, Objective, HTML Browsers, Windows Switching, HTML Command Tags, URLs, links, new web page creation, main body of the text, putting headers, adding paragraph , formatting text in HTML and font mechanism, Color settings, superscripts and subscripts and other manipulations on text and paragraphs, using directory and menu lists, creation of links, inserting graphics, using images, all manipulations on tables and its display, Detailed working with forms, allowing visitors to upload files, active images ,working with frames & framesets, Frames handling, scroll bars, alternatives to frames,
UNIT - III :
Introduction to browsers, Working with e-mail, Parts of e-mail text, working with messages.
DHTML: using DHTML in internet explorer, heading and horizontal line, hidden message, the message at the center of the page, moving boxes ,changeable box.
UNIT - IV :
Cascading style sheets
Introduction to css, creating style sheets, common tasks with CSS, Colors, the font -family, font metrics ,length units ,absolute units ,relative units ,the pixel unit ,percentages as values ,keywords as values, various properties such as the font -size property, font -size property etc, Assigning classes ,tags and attributes for applying classes, applying classes to an HTML tag, applying classes to other document parts ,the layer tag, CSS Tags
Reference Books:
1. Internet and web design by R Bangia, Second edition , firewall media
2. Multimedia and Wed technology by R Bangia
3. Internet and web designing by ITELS (Macmillan)
4. Web Enabled Commercial Application Development Using HTML, DHTML, JS, Perl by Ivan Bayross
5. Deitel, Deitel & Nieto, Internet and Worldwide Web how to Program, Pearson
Education, PHI.
6. Internmet Programming with VBScript and Java Script. Kathhleen Kalata, (Thomsaon Publication)
7. Programming the World Wide Web By. Robert W. Sebesta. (Pearson )
8. Web Technology Theory and Practice By: M Srinivasan (Pearson Publication)
B.C.A. Part II Semester III
Paper VI
DIGITAL ELECTRONICS – I
UNIT - I :
Number System and Data Representation
Number System : Binary, Octal, Decimal and Hexadecimal number system and their interconvertion.
Binary Codes : BCD, Excess3 , Parity, Gray, ASCII, EBCDIC codes and their advantages and disadvantages.
UNIT - II:
Binary Arithmetic
Data Representation: Positive, negative, maximum and minimum number representation (related to 8 bit number), real number representation, underflow, overflow, range and accuracy. Binary Arithmetic: Binary addition, binary subtraction using 1’s and 2’s compliment.
UNIT - III:
Logic gates: Truth table, properties and symbolic representation of NOT, AND, OR, NOR, NAND, EXOR, EXNOR gates. NOR and NAND gates as a universal gates.
UNIT - IV:
Boolean Algebra.
Laws and Identities of Boolean algebra, DeMorgan’s Theorem , use of Boolean Algebra for simplification of logic expression, K-Map for 2,3,4 variables, simplification of SOP and POS logic expression using K-Map.
Reference Books:
1. Digital Electronics by Gothman(PHI)
2. Digital and analogue technique by Navaneeth, Kale and Gokhale
3. Modern Digital Electronics by R. P. Jain
New semester Pattern from 2014-15
Please click on following link for subjects of each year of BCA annual pattern.
BCA Part 1 First Year
BCA Part 2 Second year
BCA Part 3 Final Year
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,
