BCA Syllabus (CCS) - SEMESTER 5

Course Name: Introduction to DBMS

Course Code: BCA-501


UNIT-I: Introduction
Characteristics of database approach, data models, DBMS architecture, and data independence.
UNIT-II: E-R Modeling
Entity types, Entity set, attribute and key, relationships, relation types, roles, and structural constraints, weak entities, enhanced E-R and object modeling, Subclasses; Superclasses, inheritance, specialization, and generalization.
UNIT-III: File Organization
Indexed sequential access files; implementation using B & B++ trees, hashing, hashing functions, collision resolution, extendible hashing, dynamic hashing approach implementation, and performance.
UNIT-IV: Relational Data Model
Relational model concepts, relational constraints, relational algebra. SQL: SQL queries, programming using SQL.
UNIT-V: EER and ER to Relational Mapping
Database design using EER to relational language.
UNIT-VI: Data Normalization and Concurrency Control
Functional Dependencies, Normal form up to 3rd normal form. Concurrency Control: Transaction processing, locking techniques and associated, database recovery, security and authorization. Recovery Techniques, Database Security.

Course Name: Java Programming and Dynamic Webpage Design

Course Code: BCA-502


UNIT-I: Java Programming
Data types, control structures, arrays, strings, and vector; classes (inheritance, package, exception handling); multithreaded programming.
UNIT-II: Java Applets and AWT Controls
Java applets, AWT controls (Button, Labels, Combo box, List, and other Listeners, menu bar), layout manager, string handling (only main functions).
UNIT-III: Networking and JDBC
Networking (datagram socket and TCP/IP-based server socket), event handling. JDBC: Introduction, Drivers, Establishing Connection, Connection Pooling.
UNIT-IV: HTML
Use of commenting, headers, text styling, images, formatting text with <FONT>, special characters, horizontal rules, line breaks, table, forms, image maps, <META> tags, <FRAMESET> tags, file formats including image formats.
UNIT-V: Java Servlets
Introduction, HTTP Servlet Basics, The Servlet Lifecycle, Retrieving Information, Sending HTML Information, Session Tracking, Database Connectivity.
UNIT-VI: Java Server Pages
Introducing Java Server Pages, JSP Overview, Setting Up the JSP Environment, Generating Dynamic Content, Using Custom Tag Libraries and the JSP Standard Tag Library, Processing Input and Output.

Course Name: Computer Network

Course Code: BCA-503


UNIT-I: Basic Concepts and Models
Components of data communication, distributed processing, standards and organizations. Line configuration, topology, Transmission mode, and categories of networks. OSI and TCP/IP Models: Layers and their functions, comparison of models. Digital Transmission: Interfaces and Modems: DTE-DCE Interface, Modems, Cable modems.
UNIT-II: Transmission Media
Guided and unguided, Attenuation, distortion, noise, throughput, propagation speed and time, wavelength, Shannon capacity, comparison of media.
UNIT-III: Telephony and Switching
Multiplexing, error detection and correction: Many to one, One to many, WDM, TDM, FDM, Circuit switching, packet switching and message switching. Data link control protocols: Line discipline, flow control, error control, synchronous and asynchronous protocols, character and bit-oriented protocols, Link access procedures. Point to point controls: Transmission states, PPP layers, LCP, Authentication, NCP. ISDN: Services, Historical outline, subscriber’s access, ISDN Layers and broadcast ISDN.
UNIT-IV: Devices and Network Layer
Repeaters, bridges, gateways, routers, The Network Layer: Design issues, Routing algorithms, Congestion control Algorithms, Quality of service, Internetworking, Network-Layer in the internet.
UNIT-V: Transport and Upper Layers
Transport layer functions, connection management, functions of session layers, presentation layer, and application layer.

Course Name: Numerical Methods

Course Code: BCA-504


UNIT-I: Roots of Equations
Bisections Method, False Position Method, Newton’s Raphson Method, Rate of convergence of Newton’s method.
UNIT-II: Interpolation and Extrapolation
Finite Differences, The operator E, Newton’s Forward and Backward Differences, Newton’s divided differences formulae, Lagrange’s Interpolation formula for unequal Intervals, Gauss’s Interpolation formula, Starling formula, Bessel’s formula, Laplace-Everett formula.
UNIT-III: Numerical Differentiation and Integration
Introduction, direct methods, maxima and minima of a tabulated function, General Quadratic formula, Trapezoidal rule, Simpson’s One-third rule, Simpson’s three-eight rule.
UNIT-IV: Solution of Linear Equations
Gauss’s Elimination method and Gauss’s Siedel iterative method.
UNIT-V: Solution of Differential Equations
Euler’s method, Picard’s method, Fourth-order Ranga-Kutta method.