Page 3 :
Course code:, CC 301, Course, Outcomes, , UNIT No., I, , II, , III, , IV, , BCA-II (Sem.-III), Web Technology, Credit :04, After completion of this course student should be able to1. Understand basics of website and web development life cycle., 2. Design website using HTML and CSS, 3. Implement client side scripting for website development, 4. Understand importance and working of HTML5, Description, Introduction - Internet & Website, 1.1 Internet-Basics, Internet Protocols(HTTP,FTP,IP), 1.2 World Wide Web(WWW), 1.3 HTTP, DNS, IP Address, 1.4 Working of Website, 1.5 Web Browser, Web Server, Types, 1.6 Types of Websites(Static and Dynamic Websites), 1.7 Web Development lifecycle, 1.8 Basics of web hosting, HTML and CSS, 2.1 Introduction to HTML, History, Features, 2.2. HTML tags & attributes, 2.3 HTML Form elements, 2.4. HTML Frameset, 2.5. Limitations of HTML, 2.6 Basics of CSS, Syntax, 2.7 Types of CSS, Importance of CSS, 2.8. CSS Selectors-Group, id, class, 2.9. CSS properties- Border, background, list, image, margins, 2.10. Advantages and limitations of CSS, JAVA Script, 3.1 Introduction to JavaScript., 3.2 Difference between client side and server side scripting., 3.3 Identifier & operators, 3.4 Control structure, 3.5. Dialog boxes, 3.6 Functions, 3.7 Event Handling, 3.8 Objects, 3.9 Form Validation, HTML 5, 4.1 Introduction to HTML5, 4.2. Difference between HTML and HTML5, 4.3 HTML5- Attributes, events, 4.4 HTML5 canvas, 4.5.HTML5 Audio & Video, , Marks:100, , No. of, Periods, 15, , 15, , 15, , 15

Page 5 :
Course code: CC 302, Course, Outcomes, , UNIT No., I, , II, , III, , IV, , BCA-II (Sem III), Computer Network and Internet, , Credit :04, , Marks:100, , After completion of this course student should be able to1. Understand the concept of computer network., 2. Identify different components required to build different networks., 3. Recognize the functions of network layers and different protocols., 4. Discuss the important features of the Internet and Web., Description, Introduction to Computer Network:, Definition of a Computer Network, concept of Network, Components of a, computer network, use of computer networks. Simplex, Half duplex & Full, duplex. Components of computer networks-files server, workstation. Network, devices-hub, repeater, bridge, router, gateway. Classification of computer, network- geographical spread (LAN,WAN, MAN)., Data Transmission & Topologies:, Data transmission-serial and parallel transmission. Data communicationanalog and digital transmission. Transmission Medias- I) Guided media twisted pair, coaxial cable, optical fibers. II) Unguided media-radio waves,, microwaves, infrared. Topologies- bus, star, ring, mesh, tree., TCP/IP and OSI Model:, Introduction- Concept of Error detection & control code. Flow control- Stop, and Wait protocol, sliding window protocol. Routing & Routing algorithmsshortest path, flooding, distance vector. Switching techniques- circuit, packet, & message switching, Connection oriented and connectionless services., TCP/IP Model- Introduction, Working and Functions of –, Process/Application layer, Host to Host/Transport layer, Internet layer,, Network access/Link layer., OSI Model-Introduction, Working and Functions of – Physical layer, Data, Link Layer, Network Layer, Transport Layer, Session Layer, Presentation, Layer, Application Layer., Internet, Introduction to internet. Evolution of Internet, Difference in Internet, Intranet, & Extranet. Domain Name System (DNS). Web browsers & its features,, Search engines, Netiquette, Introduction to Web 3.0, Advantages of Web 1.0,, 2.0 and 3.0. Internet security threats and security solutions., Reference Books:, 1. Computer Networks Andrew Tanenbaum, Pearson Education, 2. Computer Networks Fundamentals and applications, R S Rajesh, K S, Easwarakumar, R Balasubramanian, VIKAS Publishing House Pvt. Ltd., 3. Data Communication and Networks, James Irvin, David Harle Wiley, 4. Computer Networks protocols, Standards and Interface Black C. Prentice, Hall of India, 5. Computer Communication Networks William Stalling Prentice Hall of, India, , No. of, Periods, 15, , 15, , 15, , 15

Page 6 :
Course code: CC 303, , BCA-II (Sem III), Data Structure using C, , Credit :04, , Marks:100, , Course, After completion of this course student should be able toOutcomes, 1. Use and implement appropriate data structure for the required problems using a, programming language such as C., 2. Understand various searching & sorting techniques, 3. Implementing various data structures viz. Stacks, Queues, 4. Implementation of Linked Lists and Trees., UNIT No., Description, No. of, Periods, I, 15, Introduction to data structures,  Introduction to Data Structures,  Data and Information,  Data structures and its types,  Data structures operations, II, 15, Sorting and Searching Methods,  Introduction to Sorting and searching,  Bubble Sort,  Insertion sort,  Selection sort,  Merge sort,  Linear search,  Binary search and hashing concept, III, 15, Stacks and Queues,  Concept of Abstract Data types,  Introduction to stack,  Primitive Stack operations: Push & Pop,  Array and Linked Implementation of Stack in C,  Application of stack: Prefix and Postfix,  Expressions, Evaluation of postfix expression,  Definition of queue.,  Operations on queue.,  Types of queue-Linear, Circular.,  Applications of queue, IV, , Linked Lists and Trees,  Introduction to linked lists,  Implementation of Linked list,  Operations on linear linked list, circular linked list, doubly linked list,  Sequential and linked lists,  Operations such as, o Traversal, o Insertion, o Deletion, o Searching,  Trees : definition, terminologies, representation, types,  Tree Traversal- (Preorder, Inorder, Postorder), Reference Books:, 1. 1Data Structure Through C- By Dr. Sahani., , 15

Page 8 :
BCA-II (Sem III), Course code:, AEC304, , Elements of Statistics, , Credit :04, , Marks:100, , Course, After completion of this course student should be able toOutcomes 1) Explain various term used in Statistics., 2) Describe the Measures of Central Tendency and Dispersion, 3) Understand Analysis of Bivariate data(Correlation and Regression), 4) Elaborate Sampling Techniques and Time Series Analysis., UNIT No., , Description, , I, , Introduction to Statistics, 1.1 Meaning and Scope of Statistics, Primary and Secondary data., 1.2 Frequency, Frequency distribution, Qualitative and quantitative data,, Discrete and Continuous variables., 1.3 Representation of frequency distribution by graphs: Histogram,, Frequency polygon, Frequency curve, O give curve. Representation of, Statistical data by Bar diagram and Pie chart., 1.4 Numerical examples based on 1.2, 1.3., Measures of Central Tendency and Dispersion, 2.1 Measures of central Tendency (Averages), 2.1.1 Meaning of averages, Requirements of good average., 2.1.2 Definitions of Arithmetic mean (A.M.), Combined mean, Median,, Quartiles, Mode, Relation between mean, median and mode., 2.1.3 Merits and Demerits of Mean, Median and Mode., 2.1.4 Numerical examples based on 2.1.2. 2.1.5 Determination of Median, and Mode by Graph., 2.2 Measures of Dispersion (Variability):, 2.2.1 Meaning of Variability, Absolute and Relative measures of, dispersion., 2.2.2 Definitions of Q.D., M.D., S.D. and Variance, Combined variance, and their relative measures, Coefficient of Variation (C.V.)., 2.2.3 Numerical examples based on 2.2.2., Analysis of Bivariate data:, 3.1 Correlation:, 3.1.1 Concept of Correlation, Types of correlation (Positive,, Negative, Linear and Non-linear), Methods of studying correlation:, Scatter diagram, Karl Pearson’s Correlation Coefficient (r) and, Spearman's Rank Correlation Coefficient (R)., 3.1.2 Interpretation of r = + 1, r = -1, r = 0., 3.1.3 Numerical examples on 3.1.1and 3.1.2, 3.2 Regression:, 3.2.1. Concept of Regression, Definitions of regression coefficients, and Equations of regression lines. Properties of regression, coefficients (Statements only), 3.2.2 Numerical examples on 3.2.1., , II, , III, , No. of, Periods, 15, , 15, , 15

Page 9 :
IV, , Sampling Techniques and Time Series Analysis:, 4.1 Sampling Techniques:, 4.1.1 Definitions of Sample, Population, Sampling, Sampling Method and, Census method. Advantages of sampling method over census, method., 4.1.2 Types of sampling: Simple Random Sampling (with and without, replacement), Stratified Random Sampling, Merits and Demerits of, S.R.S. and Stratified Sampling., 4.1.3 Simple examples on Stratified Sampling., 4.2 Time Series: (Analysis and Forecasting), 4.2.1 Meaning and components of Time Series, 4.2.2 Methods of determination of trend by, (I) Method of Moving Averages., (II) Method of Progressive Averages. (III) Method of Least Squares, (St.Line only), 4.2.3 Numerical examples on 4.2.2., Note: Use of Nonprogrammable calculator is allowed., Reference Books:, 1) Mathematical Statistics by H.C. Saxena and J. N. Kapur, 2) Business Statistics by G. V. Kumbhojkar, 3) Fundamentals of Statistics by S. C. Gupta, 4) Business Statistics by S. S. Desai, 5) Business Statistics - SIM-Shivaji University, Kolhapur, , 15

Page 10 :
BCA-II (Sem.-III), Course code:, AEC305, , Human Resource Management and, Materials Management, , Credit :04, , Marks:100, , Course, After completion of this course student should be able toOutcomes 1. Understand Human Resource Planning Process., 2. Elaborate Performance Appraisal, Training and Development, Wage and salary, Administration., 3. Explain functions of material management, 4. Demonstrate 5 R in purchasing and Inventory control techniques., UNIT No., Description, No. of, Periods, I, Human Resource Management: Definitions, Objectives, Functions, Scope, 15, and Activities of HRM,, Human Resources Planning: Definition and objectives of Human Resource, planning, HRP process, Concept of Recruitment and Selection -Recruitment, policy-Sources of Recruitment-Selection procedure – Promotion and, demotion policy- Transfer policy., II, 15, Performance Appraisal, Training and Development, Wage and salary, Administration, Performance Appraisal Concept and objectives of performance AppraisalProcess of Performance Appraisal and methods, Training and Development: Meaning and Definition- Need-ObjectivesImportance of Training-Training Methods-Evaluation of Training, Programme., Wage and Salary Administration Methods of wage payments-Employee, Remuneration factors determining the level of remuneration- Profit sharingFringe Benefits and welfare incentives. Wages& Salary Administration, III, 15, Introduction to Material Management:, Definition, Objectives, Importance of Material Management. Functions of, Material Management, Integrated approach to Material Management,, Challenges in Material Management, Future of Material Management in, India and Role of Computer in Material Management., IV, , Purchasing & Inventory ManagementPurchasing-Definition, Objectives, Purchasing as a profit centre, 5R in, purchasing, Purchasing cycle. Inventory Management-Definition, types of, inventory, inventory costs, need of inventory.EOQ, Basic EOQ model., Vendor Managed Inventory, Selective Inventory control techniques., Note: Students should study your own institute/college from the perspectives, of first two units. Students should study the different heads of salary sheet, from office of institute/college/any business organisation. The details of, every heads should be learnt i.e. PF, ESI, Income Tax, DA, HRA and the, like., Reference Books:, 1) Personnel Management by Edwin Flippo., 2) Personnel & Human Resource Management - Text &Case by P.Subba, , 15

Page 11 :
Rao., 3) Human Resource Management by Garry Desslar, Pearson Education, Asia., 4) Purchasing and Materials Management by P. Gopalakrishnan, 5) Materials Management-An Integrated Approach-Prentice Hall India, New, Delhi-P.Gopalkrishnan & M.Sudarshan, 6) Materials Management-Procedure,Text & Case-Prentice Hall India-A.K, Dutta, 7) Materials and Logistics Management-Everest Publication-L.C Jhamb

Page 12 :
BCA-II (Sem.-III), Lab Course-V Based on CC301, , Course code:, Credit :02, Marks: 50, CCL 306, Course, After completion of this course student should be able toOutcomes 1: Understand Web Design Concept, 2: Design Web Pages using CSS, HTML & Java Script, Sr. No., List of Practical’s, 1., Design web page using heading and formatting tags in HTML, 2., Design web page using tags-marquee, Image tags, hyperlink, list, 3., Create Railway timetable using Table tag, 4., Create HTML form for students registration, 5., Create your class timetable using table tag., 6., Design a web page of your home town with an attractive background color, text color, an, Image, font etc. (use internal CSS)., 7., Use Inline CSS to format your resume that you created., 8., Use External CSS to format your class timetable as you created., 9., Use External, Internal, and Inline CSS to format college web page that you created., 10., Design a web page of your home town with an attractive background color, text color, an, Image, font etc. (use internal CSS)., 11., Demonstrate dialogue boxes in java script, 12., Write a program in java script to perform arithmetic operations., 13., Write a java script function that reverse a number., 14., Demonstrate Objects in Javascript., 15., Write a javascript function to check the number prime or not ., 16., Changing the background color of a web page using javascript DOM., 17., Validating html form elements using javascript., 18., Write a program in javascript to print the fibonacci series., 10., Demonstrate events in Javascript, 20., Design web page using HTML5 Tags

Page 13 :
Course Code: CCL307, Course, Outcomes, , BCA-II (Sem.-III), Lab Course VI based on CC303 and AEC304, , Credit :02, , Marks:50, , After completion of this course student should be able to1. Implement various data structures viz. Stacks, Queues, Linked Lists and Trees, 2. Apply Ms Excel features for Data Manipulation and Analysis., Practical’s on CC303, , Sr.No., 1, , Write a program to implement stack using static method., , 2, , Programs to implement applications of stack., , 3, , Write a program to implement Queue using static method., , 4, , Programs to implement applications of queue., , 5, , Write a program to create linked list, add node to linked list and Remove node from linked, list., , 6, , Write a program to implement types of linked list., , 7, , Write a program to implement stack and queue dynamically., , 8, , Write a program to sort given elements using bubble sort, insertion sort, selection sort, , 9, , Write a program to search given element using Linear Search., , 10, , Write a program to search given element using Binary Search., Practical’s on AEC304, Ten Lab assignments based on AEC 304 using following Excel features:, , , , , , , , , , , , , , , , , , , Create workbook, Excel Charts, Apply Custom Data Formats, Use Advanced Fill Options, Apply Advanced Conditional Formatting and Filtering, Apply Custom Styles and Templates, Use Custom Views, Functions, Apply functions in formulas, Mathematical Functions, Financial functions, Useful Data Functions, Some Other Useful Functions, Look up data by using functions, Apply advanced date and time functions, Functions for Manipulating Text, Pivot tables

Page 14 :
BCA II (Sem. IV), Course Code:, CC 401, Course, Outcomes, , Unit No., I, , II, , III, , RDBMS, , Credits:04, , Marks: 100, , After completion of this course student should be able to1. Describe the fundamental elements of Relational Database Management, Systems., 2. Explain various commands in data languages with example., 3. Understand various subqueries & joins., 4. Apply the control statements and stored procedures., Descriptions, Introduction to RDBMS,  Concept of RDBMS,  Difference between DBMS and RDBMS,  Terminologies: relation, attribute, domain, tuple, entities,  Entity relationship model,  Relational Model: Structure of Relational Database,  Concept of RelationalAlgebra,  Role and Responsibilities of DBA,  Database Protection: Security Issues, Threats to Databases,, Security Mechanisms, Basics of MySQL,  Difference between SQL and MySQL,  Creating a Database and Tables,  DDL,DML,DCL,TCL Commands,  Clauses- Order by, where and group by,  Functions in MySQL, o Aggregate functions(avg, count, min, max, sum), o String Functions(concat, instr,mid, length, strcmp, trim,, ltrim, rtrim), o Math Functions(abs, ceil, floor, mod,pow, sqrt), o Date and Time Functions( adddate, datediff, day, month,, year, hour, min, sec), Subqueries and Joins in MySQL,  Subqueries,  Concepts of Sub queries,  sub queries with IN, EXISTS,NOT EXISTS,  subqueries restrictions,  Nested subqueries,  ANY/ALL clause,  correlated sub queries,  Group by and Having clause,  Concepts of Join,  Types of Join,  Inner Join, , No. of, Periods, , 15, , 15, , 15

Page 15 :
IV, ,  Outer Join,  Left Join,  Right Join,  Cross Join,  Views (creating, altering dropping, renaming and manipulating, views), MySQL control statements and stored procedures, , , , Control Statements- If, case and loop, Stored procedures – Creating and executing procedures with and, without parameters,  Cursors- Declare, open, fetch, close,  Triggers- Create, show and drop trigger, Types of trigger, Books Recommended:, 1.Introduction to Database Systems C. J. Date Pearsons Education, 2. Database System Concept Korth, Silberschatz and Sudarshan MGH, 3. Fundamentals of Database Systems Elmasri Navathe Pearson, Education, 4. SQL /PL SQL For Oracle 11G BlackBook Dr.Deshpande Wiley, Dreamtech, 5. ORACLE PL/SQL Programming Scott Ulman TMH 9th, 6. SQL, PL/SQL the programming language of Oracle Ivan Bayross, BPB 4th Edition, , 15

Page 16 :
BCA-II (Sem IV), Course code:, Software Engineering, Credit :04 Marks:100, CC 402, Course, After completion of this course student should be able toOutcomes, 1. Understand life cycle models, requirement elicitation techniques, understand the, concept of analysis and design of software., 2. Develop SRS document., 3. Use of analysis and design tools for system development., 4. Apply software engineering concepts in software development to develop quality, software., UNIT No., Description, No. of, Periods, Introduction to Software Engineering:, Introduction to system, Characteristics of system, types of system, Program, vs Software, Definition of Software Engineering, importance, principles of, software engineering, Difference between software engineering and, I, 15, software programming, Members involved in software development. SDLC, (General software development life cycle with all phases), Software process models:, Overview of software models (Waterfall, Prototyping and Spiral model)., Requirement Engineering:, What is Requirement Engineering, Types of requirements, Requirement, elicitation techniques- Traditional methods and Modern methods,, II, 15, Verification and validation process, Formal technical review, Principles of, Requirement Specification, Software Requirement Specification document,, Characteristics of good SRS., Analysis and System Design tools:, Data Flow Diagrams (DFD), Data Dictionary, Entity-Relationship, Diagrams, Decision Tree and Decision Table., Input and Output Design- I/O design considerations, Structured Chart, HIPO, III, 15, chart, Characteristics of Good Design,, CASE STUDIES – Library Management System, Inventory Management, System., Software Testing and Software Quality Assurance, Software Testing:, Definition, Test characteristics, Types of testing: Black-Box Testing ,, White-Box Testing ,Unit testing , Integration testing, Validation testing,, IV, 15, System testing., Software Quality Assurance:, Introduction- Quality, and its attributes, quality control, quality assurance,, cost of quality, SQA activities, SQA plan.

Page 17 :
References (Books, Websites etc):, 1. Software Engineering a Practitioners Approach by S. Pressman & Roger,, Seventh Edition, McGraw Hill International Edition., 2. Software Engineering by Sommerville, , 7th edition,, Pearson, Publication, 3. Software Engineering by K.K. Aggarwal & Yogesh Singh, New Age, International Publishers., 4. Web sites of NPTEL / Swayam, 5. www. edx.com

Page 18 :
Course code: CC 403, , BCA-II (Sem IV), DOT NET Technology, , Credit :04, , Marks:100, , Course, After completion of this course student should be able toOutcomes, 1. Understand features of C# DOT NET, 2. Implement various server controls for website development, 3. Apply validation and state management for interactive website development, 4. Design and develop dynamic web application using ADO.Net, UNIT No., Description, No. of Periods, I, 15, Introduction to .NET Framework, 1.1. Overview of .NET, 1.2. Features of .NET, 1.3. Managed and unmanaged code, 1.4. Meta Data, 1.5. .NET types and .NET object and name spaces, 1.6. Architecture of DOT NET Framework: CLR, CTS, MSIL, JIT,, CLS, FCL, 1.7. Types of JIT, 1.8 Visual studio .NET IDE, II, 15, C# Basics, 2.1 Introduction to C#, 2.2 Entry point method, command line arguments, 2.3 Different valid forms of main(), 2.4. Difference between .Exe and .DLL, 2.5 Parameter Passing mechanism, Out parameter, 2.6 Data types, 2.7 Type Casting, Boxing & Unboxing, 2.8 Partial class and implementation, 2.9 Control structures, III, 15, ASP .NET, 3.1. Asp.Net Server controls, 3.2. Web form lifecycle, 3.3.Validtion controls, 3.4. Navigation controls, 3.5 Response.redirect, server.response,, 3.6 Cross page posting, 3.7 State Management, IV, 15, ADO.NET, 4.1 Data Controls in ASP.Net, 4.2 ADO.Net Classes-Connection, Command, DataReader,, DataAdapter,Dataset, 4.3 Connected and Disconnected architecture, 4.4 Data binding using ADO.net, 4.5 Report generation, simple and parameterized reports, Books Recommended:, 1. ASP .NET-The Complete Reference Tata MacGraw Hill, 2. ASP.NET 4 Unleashed by Stephen Walther, Kevin Scott, Hoffman, Sams Publishing

Page 19 :
3. Bill Evjen, Professional ASP.NET 3.5 in C# and VB, Wrox, Publication, 4. Kogent Solutions, C# 2008 Programming covers. NET 3.5 (Black, Book), Dreamtech Press, 5.Microsoft ASP.NET 4.0 Step by Step - George Shepherd,, Microsoft Press, 6. Mastering ASP.Net - BPB Publication, 7. ASP.net – The Complete Reference- Tata McGraw Hill, 8. ASP.NET Programming – Murach, 9. ASP.NET 4.0 Programming- Joydip Kanjilal

Page 20 :
BCA II (Sem IV), Course, code:, AEC 404, Course, Outcomes, , UNIT No., I, , II, , III, , IV, , Entrepreneurship Development, , Credit :04, , Marks:100, , After completion of this course student should be able to1. Define characteristics, function and types of entrepreneurs and know the role of, Entrepreneurship in Economic Development., 2. Identify Business Opportunities and prepare business plan., 3. Know project finance agencies., 4. Understand New Opportunities and Challenges in digital entrepreneurship., Description, No. of, Periods, 15, Introduction to Entrepreneurship :, Evolution, Concept and definition of an entrepreneur, Characteristics,, function and types of entrepreneurs, Qualities of an Entrepreneur,, Growth of Entrepreneurship in India, Role of Entrepreneurship in, Economic Development, Women Entrepreneurship in India., Business Opportunity Identification: Search for Business Ideas,, 15, Market Assessment, Sources of Information and Environmental, Analysis, Entrepreneurial opportunities in India, Business Opportunity, identification and selection., 15, Business Plan Preparation and Project Finance, Meaning of Business plan, Significance and Contents of a Business, Plan, developing Business Plan, Presenting Business Plan and, Preparation of project report., Project Finance: Introduction, Types of Finance, Sources of Finance,, Venture Capital, Start-up and Make-in-India program, MUDRA., Support Agencies: Support to Entrepreneurs by DIC, SIDBI, SIDCO,, SSIB, NSIC, SISI, Other Institutions etc. Entrepreneurship promotion, by Government through various schemes., Digital Entrepreneurship:, Meaning and Introduction, New, 15, Opportunities and Challenges, Choosing a Digital Business Idea,, Creating a Digital Business Design., Digital Business Model. Digital business platforms. Different, Electronic interface to consumers. Components of business website., IT Entrepreneurs: Azim Premji, N.R. Narayan Murthy and Shiv Nadar, References Books:, 1.Dr. Dilip Sarwate, Entrepreneurship Development and Project, Management, Everest Publishing house, 2.Vasant Desai, Dynamics of Entrepreneurship development and, Management, Himalaya Publishing House, 3. David H Holt, Entrepreneurship and New Venture Creation, Prentice, Hall, 4. Paul Ajit Kumar, Paul, Entrepreneurship Development, Himalaya, Publishing House Mumbai, 5. Raj Shankar – Entrepreneurship: Theory and Practice‖ – Vijay, Nicole Imprints Pvt. Ltd., 6. S.S. Khanka – Entrepreneurial Development – S. Chand And

Page 21 :
Company Ltd., New Delhi, 7. Onathan P Allen- Digital Entrepreneurship, Routledge-CRC press, Websites :, www.startupindia.gov.in, www.india.gov.in, http://www.makeinindia.com/home, , BCA-II (Sem IV), Course, Code: CCL, 405, Course, Outcomes, , PHP, , Credits: 02, , After completion of this course student should be able to1. Understand the environment of PHP programming Language., 2. Develop web applications using PHP., , Unit No., , Description, , I, , Introduction:, PHP introduction, Basic Syntax, PHP variables and constants, Types of, data in PHP, Expressions, scopes of a variable (local, global),, Operators: Arithmetic, Assignment, Relational, Logical, Bitwise, ternary, and MOD operator., Control Structures: PHP if else conditional statements (nested if and, else), switch case, while, for and do while loop, goto, break, continue and, exit., String and Regular Expression:, Creating and accessing String , Searching & Replacing String ,, Formatting, joining and splitting String ,String Related Library functions., Arrays: Anatomy of an Array, Creating index based and Associative, array, Accessing array, Looping with Index based array, with associative, array using each() and foreach()., Functions: Need of Function, Scope of Function Global and Local,, declaration and calling of a function, PHP Function with arguments,, Default Arguments in Function, Function argument with call by value,, call by reference,, Working with Forms: Processing Form Input, Validating Form Input:, Required Fields, Numbers, Email Addresses, Drop-Down Menus, Radio, Buttons, Checkboxes, Dates and Times., List of Practical’s, 1. Write a PHP program to swap two numbers with and without using, third variable., 2. Write a PHP program to find the factorial of a number., 3. Write a PHP program to count the total number of words in a string., 4. Write a program in PHP to find the occurrence of a word in a string., 5. Write a PHP program to demonstrate various functions of regular, expression., 6. Write a PHP program to find area of triangle and rectangle using, functions., , II, , Marks: 50, , No. of, Periods, 15, , 15

Page 22 :
7. Write a PHP program to find the GCD of two numbers using user-, , defined functions., 8. Write a Program for demonstrating sorting functions., 9. Write a Program using arrays., 10. Design a simple web page using PHP., Books Recommended:, 1. PHP & MySQL for Dummies by Janet Valade, 2. PHP and MySQL Web Development by Luke Welling, Laura Thompson, 3. Programming PHP by RasmusLerdorf, Kevin Tatroe, 4. PHP Cookbook by David Sklar& Adam Trachtenberg

Page 23 :
BCA II (Sem.- IV), Course Code:, CCL 406, Course Outcomes, , Sr.No., 1, , 2, , 3, , 4, , 5, , 6, , 7, , 8, , 9, , 10, , Lab Course VII Based CC 401, , Credits:02, , Marks: 50, , After completion of this course student should be able to1. Design database for business applications., 2. Use of queries, sub queries, join, view and stored procedures on, databases., List of Practical’s:, Create the tables with appropriate constraints., Perform the following:,  Viewing all existing databases,  Creating a Database,  Viewing all Tables in a Database,  Creating Tables (With and Without Constraints),  Inserting/Updating/Deleting Records in a Table,  Saving (Commit) and Undoing (rollback), Perform the following:,  Altering a Table,  Dropping/Truncating/Renaming Tables,  Granting and revoking permissions, Perform the following:,  Simple Queries,  Simple Queries with Aggregate functions,  Queries with Aggregate functions (group by and having clause), Queries involving,  Date Functions,  String Functions,  Math Functions, Join Queries,  Inner Join,  Outer Join,  Left Join,  Right Join, Subqueries,  With IN clause,  With EXISTS clause, Subqueries,  Nested subqueries,  ANY/ALL clause, Views,  Creating Views (with and without check option),  Dropping views, Stored Procedures, cursors and triggers,  Creating stored procedure with and without parameters,  Creating cursor,  Creating triggers

Page 24 :
BCA II (Sem IV), Course code:, CCL 407, Course Outcomes, , Sr. No., , Lab course-VIII Based on CC403, , Credit :02, , Marks: 50, , After completion of this course student should be able to1. Design console applications using C#., 2. Design web application using ASP.Net, List of Practical’s, Consol Applications, , 1., 2., , Write a program to display even no and odd no using C#., Write a program to demonstrate parameter passing mechanism and out parameter., , 3., , Write a program to demonstrate type casting., , 4., , Write a program to demonstrate partial class., , 5., , Web Applications, Create web page using server controls- Textbox, List Controls, Calender, Imagebutton,, Linkbutton, , 6., , Develop ASP.Net Application through which user upload Image and that Image should be, displayed in Image Control., , 7., , 8., , Write a program to create a web page showing use of following validation controls, a. Required field validator, b. Range validator, c. Compare validator, d. Custom validator, e. Regular expression validator, f. Validation summary, Write a program to create a web page passing multiple values between asp.net pages, , 9., , Write a program to create a web page showing use of response, redirect and server transfer, , 10., , Write a program to create a database for Medical shop system and represent data using, Gridview., , 11., , Using ADO.NET, create a student database and perform operations like- insert, update and, delete records., , 12., 13., 14., , Develop ASP.Net application for uploading Image., Develop a ASP.Net application for recording Registration details using different controls, & validators, Create application for displaying different reports.

Page 25 :
BCA-II (Sem IV), Mini Project, , Course code:, Credit :02 Marks:50, CCL 408, Course, After completion of this course student should be able toOutcomes 1. Implement fundamental domain knowledge of core courses for developing simple, business applications., 2. Utilize the software development techniques, skills and modern tools., Guidelines for Project, 1. A group of maximum two to four students prepare a mini project under the, guidance of internal teacher., 2. Students should adopt SDLC approach, 3. Project guide should provide progress report to each group & student should, follow it.(Encl. Progress report ), 4. Number of Copies: The student should submit two Hard-bound copies of the, Project Report., 5. The project report is duly signed by Principal or Head of Department, Project, Guide and Student., 6. Acceptance/Rejection of Project Report:, o The student should submit progress report with draft project report to the, guide., o Respective guide has right to suggest modifications for resubmission or accept, the project., o Only on acceptance of draft project report, the student should make the final, copies., , IV, , Following format for the submission of the Project Report., a. Paper:, The Report shall be typed on white paper, A4 size, for the final submission. The, Report to be submitted must be original and subsequent copies may be photocopied on, any paper., b. Typing:, The typing shall be of standard letter size, 1.5 spaced and on both side of the paper., (Normal text should have Times New Roman, Font size 12. Headings can have bigger, size), c. Margins:, The typing must be done in the following margins:, Left -----1.5 inch, Right ----- 1 inch, Top ----- 1 inch, Bottom ----- 1 inch, d. Front Cover:, The front cover should contain the following details:, TOP : The title in block capitals of 6mm to 15mm letters., CENTRE: Full name in block capitals of 6mm to 10mm letters., BOTTOM: Name of the University, Course, Year of submission -all in block capitals, of 6mm to 10mm letters on separate lines with proper spacing with center alignment., e. Blank Sheets:, At the beginning and end of the report, two white black papers should be provided,, one for the purpose of binding and other to be left blank., Documentation Format

Page 26 :
a) Cover Page, b) Institute/College Recommendation, c) Guide Certificate, d) Declaration, e) Acknowledgement, f) Index, g) Chapter Scheme, 1) Introduction to Project, -Introduction, -Existing System, -Need and scope of Computer System, -Organization Profile(Optional & applicable for live project only), 2) Proposed System, -Objectives, -Requirement Engineering., • Requirement Gathering, • Software Requirements, 3) System Analysis,  System Diagram, • DFD, • ERD, • UML(if applicable), (Note: Use advanced tools and techniques as per requirement.), 4) System Design, • Database Design, • Input Design & its samples, • Output Design (on screen), 5) Implementation, - System Requirement, - Hardware, - Software, - Installation process, - User Guideline, 6) Reports (with valid Data), (Minimum 4 reports), 7) Conclusion and Suggestions, • Conclusion, • Limitations, • Suggestion, Annexure,  Source code(Include Main Logic source code),  Questioner/Schedule(if used),  Student Guide Meet Record, References, i) Books, ii) Journals, iii) Periodicals and Newspapers, iv) Web/Blogs

Page 27 :
<<Name of College>>, , Student Guide Meet Record, <<Year>>, Title of Project, , Student Names, , Sr., 1, 2, 3, , 4, 5, 6, , 7, , Date, , Class:, , 1), 2), 3), 4), Description, , Guide Name:, , Signature of, Guide, , Signature, of, Student/s, , Guide, Remark, , Problem Identification and Topic, and title finalization, ( 1st week of semester), SRS submission and approval, ( 6th week of semester), Logical Design of System, (DFD, System flowchart, ERD,, UML diagram, Decision tables,, Decision tree ,site map which is, applicable), (7th week of Semester), Database Design, ((8th week of Semester)), I/O Design (with Reports), (10th of Semester), Submission of Draft, Project Report, (11th Week of semester ), Submission of Final, Project Report, (12th Week of semester ), , HOD/ Director/Principal