BCA 4th Semester

BCA 4.2 – COMMUNICATION SKILLS IN ENGLISH – II

P.S 1 Play
P.S 2 Essay
P.S 3 Personality Development
P.S 1 The Cherry Orchard (NAP)
P.S 2 “The Double Crisis”, “Comfort”, & “Work and Leisure” from Selections from Aldous Huxley (Macmillan)
P.S 3 Nature of Personality Development
P.S.4 Self-Concept

Question paper pattern
Q 1. Reference to Context (2/4) on Play 08
Q 2. Essay Type Question (1/2) on Play 16
Q 3. Reference to Context (2/4) on Essay 08
Q 4. Essay type Question (1/2) on Essay 16
Q 5. Nature of Personality Development 16
Q6The self-Concept

Text Book: Communication Skills in English & Personality Development by Dr. H.S. Matti & Sri D.T. Angadi (SP)

BCA 4.3:ENVIRONMENTAL STUDIES

Unit 1: The Multidisciplinary nature of environmental studies:
1. Definition, Scope and Importance.
2. Need for public awareness.

Unit 2: Natural Resources: Renewable and non-renewable resources:
1. Natural resources and associated problems.
2. Forest resources: Use and over-exploitation, deforestation, case studies. Timber extraction, mining,
dams and their effects on forests and tribal people.
3. Water resources: Use and over-utilization of surface and ground water, floods, drought, conflicts over water,
dam’s benefits and problems.
4. Mineral resources: Use and exploitation, environmental effects of extracting and using mineral resources, case studies.
5. Food resources: World food problems, changes caused by agriculture and overgrazing, effects of modern agriculture,
fertilizer pesticide problems, water logging, salinity, case studies.
6. Energy resources: Growing energy needs renewable and non renewable energy sources, use of alternative energy sources, Case studies.
7. Land resources: Land as a resource, land degradation, man induced landslides, soil erosion and desertification.
8. Role of an individual in conservation of natural resources.
9. Equitable use of resources for sustainable lifestyles.

Unit 3: Ecosystems:
1. Introduction, types, characteristic features, structure and function of the following ecosystem:-
2. Food chains, food webs and ecological pyramids.
3. Ecological succession.
4. Energy flow in the ecosystem.
5. Producers, consumers and decomposers.
6. Structure and function of an ecosystem.
7. Concepts of an ecosystem.
8. Forest ecosystem. Grassland ecosystem. c. Desert ecosystem.
9. Aquatic ecosystem (ponds, streams, lakes, rivers, oceans, estuaries).

Unit 4: Biodiversity and its conservation:
1. Introduction – Definition, genetic, species and ecosystem diversity.
2. Biogeographically classification of India.
3. Value of biodiversity: consumptive use, social, ethical, aesthetic and option values.
4. Biodiversity at global, National and local levels.
5. India as a mega-diversity nation.
6. Hot-spots of biodiversity.
7. Threats to biodiversity: habitat loss, poaching of wildlife, man-wildlife conflicts.
8. Endangered and endemic species of India.
9. Conservation of biodiversity: In-situ and Ex-situ conservation of biodiversity.

Unit 5: Environmental Pollution:
1. Definition. Causes, effects and control measures of a) Air pollution b) Water pollution c) Soil pollution
d) Marine pollution e) Noise pollution f) Thermal pollution g) Nuclear hazards.
2. Solid waste Management: Causes, effects and control measures of urban and industrial wastes.
3. Role of an individual in pvention of pollution.
4. Pollution case studies.
5. Disaster management: floods, earthquake, cyclone and landslides.

Unit 6: Social Issues and the Environment:
Form Unsustainable development.
Urban problems related to energy.
Water conservation, rain water harvesting, watershed management.
Resettlement and rehabilitation of people; its problems and concerns. Case studies.
Environmental ethics: Issues and possible solutions.
Climate change, global warming, acid rain, ozone layer depletion, nuclear accidents and holocaust. Case studies.
Wasteland reclamation.
Environment Protection Act.
Air (pvention and Control of Pollution) Act.
Water (pvention and control of Pollution) Act.
Wildlife Protection Act.
Forest Conservation Act.
Issues involved in enforcement of environmental legislation.
Public awareness.

Unit 7: Human Population and the Environment:
Population growth, variation among nations.
Population explosion – Family Welfare Programme.
Environment and human health.
Human Rights.
Value Education.
HIV/AIDS.
Women and Child Welfare.
Role of Information Technology in Environment and human health.
Case Studies.

Unit 8 :Field work:Visit to a local area to document environmental assets-river / forest / grassland / hill / mountain.
Visit a local site – Urban / Rural / Industrial / Agricultural.
Study of common plants, insects, birds.
Study of simple ecosystems-pond, river, hill slopes, etc. (Field work Equal to 5 lecture hours).

BCA 4.4 – RELATIONAL DATABASE MANAGEMENT SYSTEM

UNIT 1: Database Concepts: Data base, Database Management System (DBMS), characteristics of database approach, advantages
of using the DBMS approach, DBMS users, data models, schemas and instances, three-schema architecture and data independence,
database languages and interfaces, database system environment.

UNIT 2: The Entity Relationship Model: Entities, attributes, relationships, connectivity and cardinality, weak entities, relationship degree,
composite entities, entity super types and subtypes and subtypes, E-R diagrams, naming conventions, and design issues, specialization
and generalization, relationship types of degree higher than two.

UNIT 3: Relational Model: Concepts, constraints and relational database schemas, update operations, relational algebra operations, relational
calculus, relational database design using ER to relational mapping.

Relational Query Language: SQL data definition and data types, specifying constraints, queries in SQL, insert, delete and update statements, nested
queries, correlated queries, aggregated functions, database programming with function calls, cursors, triggers, procedures, PL/SQL programming.

UNIT 4: Relational Database Design: Functional dependencies, normal forms- first, second, third and Boyce-Codd normal forms, relational database
design algorithms, multivalued dependencies and fourth normal form. The database design and implementation process.

UNIT 5: File Structures: Disk storage, basic file structures, and hashing, indexing structures for files.

Transaction processing concepts: Transaction properties, characterizing schedules based upon recoverability, characterizing schedules based upon
serializability, two-phase locking protocol for concurrency control, concurrency control based on Time-Stamp ordering, transaction support in SQL.
Database recovery techniques.

References: Ramex Elmasri, Navathe, Fundamentals of Database Systems, Pearson Education.
H.F. Korth and Silberschatz, Database Systems Concepts, McGraw Hill.
Bipin C. Desai, An Introduction to Database Systems, Galgotia Publications.
Date, C.J., An Introduction to Database Systems, Sixth Edition, Addison-Wesley.
Kroenke David M, Database Processing Fundamentals, Design and Implementation, PHI.
Leon and Leon, SQL Complete Reference, Tata McGraw Hill.
Ivan Bayross, SQL, PL/SQL Programming Language, BPB Publications.

BCA 4.5 – ELEMENTS OF SYSTEM ANALYSIS AND DESIGN

UNIT 1: Information and Management: Types of information, Management Structure, Management and Information requirements,
Qualities of information, Example of information systems.

UNIT 2: Information Systems Analysis: Task and attributes of a System Analyst, tools used by the system analyst, Information gathering,
system requirement specification, feasibility analysis, Data flow diagrams, Process specifications and decision tables.

UNIT 3: Logical Database Design: ER-model, Normalization, database management system (DBMS), object-oriented system modeling.

UNIT 4: Data Input Methods: Data input, coding techniques, detection of error in codes, validating input data, interactive data input.

Designing Outputs: Output devices, objectives of output design, design of output reports, design of screens, Use of business graphics.

UNIT 5: Database Management Systems: Database and Database Management Systems (DBMS), objectives, overview of DBMS,
database administrator, database design.
Control information systems, audit information systems, Control of information systems, Security of information systems.
Introduction to e-commerce.
System design example.

References: Rajaraman V: Analysis and Design of Information System, PHI.
Elias M. Awad, Systems Analysis and Design, Galgotia Publications.
Hawryszkiewycz I. T., Introduction to Systems Analysis and Design, 3rd edition, PHI.
Clifton H.D., Business Data Systems, pntice Hall.
Daniels A. and Yeates D., Basic System Analysis, Galgotia Publications.
Kelkar S.A., Structured Systems Analysis and Design-A Concise Study, PHI.

BCA 4.6 – COMPUTER ORIENTED

NUMERICAL METHODS

UNIT 1 Introduction: Numbers and their accuracy, Computer arithmetic, Mathematical pliminaries, Error and their computation,
General error formula, Error in a series approximation.

UNIT 2 Solution of Algebraic and Transcendental Equation: Bisection method, Iteration method, Method of false position, Newton-Raphson
method, Methods of finding complex roots, Muller’s method, Rate of convergence of iterative methods, polynomial equations.

UNIT 3 Solution of Linear Equations: Solution of linear system by Gaussian elimination and Gauss-Jardon methods, Iterative methods:
Gauss-Seidel methods, Inverse of a matrix by Gauss Jordon method, Eigen value of a matrix by power method and by Jacobi method for symmetric matrix.

UNIT 4 Interpolation: Finite Differences, Difference tables, Polynomial Interpolation: Newton’s forward and backward formula, Central
Difference Formulae: Gauss forward and backward formula, Stirling’s, Bessel’s, Everett’s formula. Interpolation with unequal intervals: Langrange’s
Interpolation, Newton’s devided difference formula, Hermite’s Interpolation.

UNIT 5 Numerical Integration and Differentiation: Introduction, Numerical differentiation, Numerical integration: Trapezoidal rule,
Simpson’s 1/3 and 3/8 rule.

UNIT 6 Solution of Differential Equations: Picard’s method, Euler’s method, Taylor’s method, Runge-Kutta methods, pdictor-Corrector methods,
Automatic Error Monitoring and Stability of solution.

References: Rajaraman V., Computer Oriented Numerical Methods, Pearson Education.
Veerarjan, T and Ramachandran. T, Numerical Methods with Programming in C, Tata McGraw Hill.
S.S. Ssatry, Introductory methods of Numerical Analysis, pntice Hall of India.
Sankar Rao K, Numerical Methods For Scientists and Engineers, pntice Hall of India.
Gerald C.F. and >Wheate, P.O., Applied Numerical Analysis, Pearson Education.
Jain, M.K., Iyengar, S.R.S. and Jain, R.K., Numerical Methods for Scientific and Engineering Computation, Wiley Eastern.

BCA 3.7 – PROGRAMMING LABORATORY –IV

PART I: Lab assignment shall be carried out to include the following features of SQL.
• Data definition in SQL, basic data retrieval, condition specification, arithmetic and aggregate operators, SQL join,
set manipulation, categorization, updates, views, views and updates.
• Triggers, procedures, PL/SQL programming.

Part II: Implementation of Numeral methods studied in paper BCA 4.6 using C/C++.