BCCA Bachelor of Commerce and Computer Application 2nd Year Sem 2
BCCA Course and Classes Syllabus for Fourth Semester BCCA Nagpur University
Atlanta Computer Institute Nagpur conducts Tuition Classes for BCCA Part 1 First semester BCCA Part 1 second semester BCCA Part 2 third semester BCCA Part 2 fourth semester BCCA Part 3 Fifth Sem & BCCA Part 3 6th semester for all universities in India . The Following syllabus is of Nagpur University. Final Year Projects Training is also given to BCCA Students.
Paper - 1: Mathematics
UNIT - 1
Introduction Scope, Data Collection and Classification: Meaning of Statistics,
Variable and Attribute, Primary Data and Secondary Data, Population (or Universe) and
Sample, Complete Enumeration (or Census) and Sample Survey, Statistical Enquiry,
Useful Terms Classification, Tabulation, Mechanical Tabulation. Permutation:
Introduction, Fundamental Rules of Counting, Result on Permutation Examples.
Combination: Introduction, Result of Combination. Set Theory :Method of Set
Representation and Notation, Types of Sets, Venn Diagram, Set Operations, Union(Set
Addition), Intersection (Set Multiplication), Complement, Difference, Examples on Set
Operations, Laws of Algebra of Sets, Duality, Verification of Laws (Using Venn Diagram),
Proof of the Laws of Set Algebra, Number of Elements in a set
UNIT - 2
Logarithm: Introduction, Definition of Logarithm, Laws of Logarithm, Common
Logarithm and Natural Logarithm, Antilogarithm. Compound Interest: Interest
Compounded Continuously, Amount at the Changing rates of Interest, Nominal and
Effective rate of Interest, Growth and Depreciation. Other Useful Mathematics
Devices: Rounding of Numbers, Absolute, Relative and Percentage Errors, Significant
Figures, Some Short Processes of Calculation, Roots and Reciprocals Expressed as
Power, A.P. Series and G.P. Series, Sum and Sum of the Squares of Numbers,
Inequalities, Concept of Function, Polynomial, Sigma (S) Notation, Simple Interpolation
UNIT - 3
Charts and Diagrams: Objects of Diagrammatic Representation, Types of Charts and
Diagrams. Frequency Distribution :Observation, Frequency, Simple Series(or
BCCA Syllabus RTMNU
Ungrouped Data)and Frequency Distribution, Useful Terms Associated with Grouped
Frequency Distributions, Construction of frequency Distribution, Cumulative Frequency
Distribution, Relative Frequency Distribution, Diagrammatic Representation of Frequency
Distributions, Frequency Curve. Measures of Central Tendency :Average or Measure
of Central Tendency, Arithmetic Mean(A.M.), Important Properties of A.M., Simplified
Calculation for A.M., Mean of Composite Group, Geometric Mean(G.M.), Properties of
G.M., Harmonic Mean(H.M.), Advantages and Disadvantages of A.M.,G.M.,H.M.,
Relations between A.M.,G.M.,H.M., Median, Calculation of Median, Advantage and
Disadvantage of Median, Mode, Calculation of Mode, Advantages and Disadvantages of
Mode, Relation between Mean, Median, Mode, Partition Values -Quartiles, Deciles,
Percentiles, Calculation of Partition Values. Measures of Dispersion :Meaning and
Necessity of =Measures of Dispersion, Range, Quartile Deviation (Or Semi – Interquartile
Range), Mean Deviation (Or Mean Absolute Deviation), Standard Deviation(S.D.),
Important Properties of S.D., Calculation of Standard Deviation (s), S.D. of Composite
Group, Relation between S.D. and Other Measures, Relative Measure of Dispersion.
UNIT - 4
Moments, Skewness and Kurtosis :Moments, Relation between central and Non-
Central moments, Beta coefficients and Gamma-coefficients, Standardized Variable,
Moments of Frequency Distributions, Skewness, Kurtosis. Curve Fitting :Curve Fitting,
Straight Line and Parabola, Free-hand Method of Curve Fitting, Method of Least
squares, Fitting Straight line, Simplified Calculations, Fitting Parabola, Fitting Exponential
and Geometric Curves. Correlation and Regression :Concepts of =correlation =and
=Regression‘, Bivariate Data, Bivariate , Frequency Distribution, Scatter Diagram,
Correlation, Covariance, Correlation Coefficient(r), Properties of Correlation coefficient,
Calculation of r, Interpretation and use of r, Variance of the Sum (Difference)of Two
Series, Regression, Properties of Linear Regression, Explained Variation and
Unexplained Variation, Regression Curve in Bivariate Frequency Distribution , Rank
Correlation. Time Series : Meaning and Necessity of =Time Series Analysis‘,
Components of Time Series, Adjustments to Time Series Data, Secular Trend,
Measurement of Trend, Monthly Trend from Annual Data, Seasonal Variation,
Measurement of Seasonal Variation, Cyclical Fluctuation, Business Forecasting,
Exponential Smoothing. Probability Theory :Introduction, Random Experiment,
Outcome, Event, Important Terminology, Techniques of Counting, Classical (or‘a
Priori‘)Definition of Probability, Theorems of Probability, Draw without Replacement,
Repeated Trials-Drawing with Replacement, Bayes‘ Theorem Other Approaches to
Probability Theory, Set and Probability, Finite Probability Space and Assignment of
Probabilities, Finite Equiprobable Sample Space and Classical Definition, Conditional
Probability, Independent Events.
1. N G Das, J K Das, Business Management and Statistics, McGraw-Hill.
1. Mrintunjay Kumar, Business Mathematics, Vikas Publishing House Pvt. Ltd.
2. Ajay Goel, Alka Goel, Mathematics & Statistics, Taxmann.
3. Walter Rudin, Principals of mathematical Analysis, McGraw-Hill.
4. Dr. S. R. Arora, Dr. Kavita Gupta, Business Mathematics and Statistics, Taxmann.
BCCA Syllabus RTMNU
Paper - 2: Business Law
THE INDIAN CONTRACT ACT, 1872
Meaning Of Essentials Of Contract, Offer And Acceptance, Capacity Of Parties,
Considerations, Free Consent, Legality Of Object And Consideration, And Agreements
Opposed To Public Policy, Void Agreement And Contingent Contracts, Performance Of
A Contract, Discharge Of A Contract, Remedies For Breach Of Contract, Quasi-
Contracts, Indemnity And Guarantee, Bailment And Pledge, Contract Of Agency.
THE SALE OF GOODS ACT, 1930:-The Sale Of Goods Act,1930, Contract Of Sale,
=Sale‘ And =Agreement To Sell‘ Distinguished, Meaning & Types Of Goods,
Sale/Agreement To Sell, Price. Condition And Warranties-Meaning, Condition &
Warranty Distinguished, Express And Implied Conditions And Warranties, Doctrine Of
Caveat Emptor. Transfer Of Property-Meaning, Rules Regarding To The Transfer Of
Property, Transfer Of Property In Specific Or Ascertained Goods, Transfer Of Property In
Unascertained Goods And Future Goods, Rules Relating To Transfer Of Property Of
Goods Sent =On Approval‘ Or =On Sale Or Return‘, Delivery. Rights Of Unpaid Seller Meaning,
Right Of Lien, Right Of Stoppage Of Goods In Transit, Lien And Stoppage In
Transit Distinguished, , Effect Of Sub-Sale Or Pledge By Buyer Upon The .Two Rights
Of The Unpaid Seller., Right Of Resale, Rights Of Seller And Buyers, Right Of Unpaid
Sellers Against Buyer Personality, Auction Sale.
THE INFORMATION TECHNOLOGY ACT, 2000 :-Meaning, objectives, scheme,
scope, provision relating to electronic signature, provision relating to electronic
governance, acknowledgement and dispatch of electronic records, secure electronic
records and secure electronic signature, regulation of certifying authorities, electronic
signature certificates, duties of subscribers, penalties, compensation and adjudication,
the cyber appellate tribunal, offences, constitution of advisory committee, power of
controller to make regulations.
BCCA Syllabus RTMNU
THE INDIAN PARTNERSHIP ACT, 1932: Meaning & Essentials Of Partnership, Co-
Ownership, Partnership Deed, Registration Of Firm, Types Of Partnership On The Basis
Of Duration, Types Of Partners, Position Of Minor As A Partner, Mutual Rights And
Duties, Relation Of Partners With Third Parties, Implied Authority Of Partners,
Reconstitution Of Firms, Dissolution Of Firm, Settlement Of Accounts, Public Notice.
THE LIMITED LIABILITY PARTNERSHIP ACT, 2008 (LLP):-Meaning & Features Of
LLP, Comparison Between Existing Partnership & LLP, Comparison Between Company
& LLP, Minimum No. Of Partners, Designated Partners, Incorporation Document,
Incorporation By Registration, Effects Of Registration, Registered Office Of LLP &
Change Therein, Name Of LLP and change therin, partners of LLP and change therin,
cessation of partnership interest, partner as agent of LLP And Not Of Other Partners,
Extent Of Liability Of LLP, Extent Of Liability Of Partner, Unlimited Liability In Case Of
Fraud, Whistle Blowing, Contribution. Account, Audit And Taxation :-Maintenance Of
Books Of Account, Other Records And Audit, Etc, Annual Return, Parteners
Transferable Interest, Taxation of LLP, Conversion From Firm Into LLP, Conversion
From Private Co. Into LLP, Conversion From Unlisted Public Co. Into LLP , Winding Up
Of LLP, compulsory winding up, commencement of winding up by tribunal, voluntary
winding up of a LLP.
The Negotiable Instruments Act, 1881 (Part-I) :-Negotiable instrument, promissory
note, bill of exchange, acceptance, distinction between bill of exchange & promissory
note, cheque, distinction between a cheque and bill of exchange, crossing, bouncing or
dishonor cheque, holder & holder in due course, distinction between holder & holder in
due course, negotiation and assignment, distinction between negotiation and
assignment, endorsement, material alteration. The Negotiable Instruments Act, 1881 (Part-II):-liabilities of various parties,
proportionate in case of partial failure of consideration, presentment for acceptance,
presentment for payment, acceptance for honour, payment for honour, dishonor of bill,
notice of dishonor, rights of holder in case of instrument acquired after dishonor or after
maturity, noting and protesting, drawee in case of need, discharge of an instrument,
discharge of a parity, distinction between discharge of an instrument & discharge of a
parity, hundi, types of hundies.
1.P C Tulsian, Bharat Tulsian, Business law, McGraw-Hill.
1. M. C. Kuchhal, Vivek Kuchhal, Business laws, Vikas Publishing House Pvt. Ltd.
2.Sushma Arora, Business Laws, Taxmann.
3.Akhileshwar Pathak, Legal Aspects of Business, McGraw-Hill.
4.C. L. Bansal, Business Laws, Taxmann.
5.Chandra Kumar Roy, Pravhat Kumar Roy, Business Laws, Vikas Publishing House
6. Satish B Mathur, Business Law, McGraw-Hill.
7.Dr. K. V. Achalapati, Ramanna Murthi, Business Laws, Taxmann
BCCA Syllabus RTMNU
Paper - 3: Core Java
Getting Started -The HelloWeb Applet, What is Java?, Why Learn Java, Installing and
Setting Up the Java SDK, Writing Your First Application, Learning Java Syntax Basics,
Writing Your First Applet! Variables, Data Types, and Simple I/O –
The Project: the NameGame Application, Variables and Data Types, Working with Numbers, Getting
Simple User Input, Strings and String Operations, Getting Back to the Name Game. The
Fortune Teller: Random Numbers, Conditionals, and Arrays –
The Project: the Fortune Teller, Generating Random Numbers, Controlling the Random Numbers Range, The If
Statement, The if-else Statement, Using the Switch Statement, Understanding the
Arrays, Back to the Fortune Teller.
Using Loops and Exception Handling – The Project: The NumberGuesser, Counting
Forward with Loops, Skipping Values, Counting Backwords, Nested For Loops, Looping
on Arrays, Using the while loop, Exception Handling, Back to the NumbersGuesser
Program. Blackjack: Object-Oriented Programming – The Project: The BlackJack
Application, Understanding Object-Oriented Concept, Examining Member Variables,
Defining and Using Methods, Understanding Access Modifiers, The Card and CardDeck
Class, Extending a Class, Back to the BackJack Game. Creating a GUI Using the
Abstract Windowing Toolkit – The Project: MadLib Program, The java.awt Package,
Using Frames, Using Components, Back to the MadLib Game Application.
Advance GUI: Layout Managers and Events Handling – The Project: the
AdvancedMadLib Application, Using Layout Managers, Handling AWT Events, Getting
Back to the AdvancedMadLib Application. Writing Applets – The Project: QuizShow
Applet, Understanding Applets, Including an Applet in a Web Page, Learning Applet
Methods: init(), start(), stop(), and destroy(), Printing Status Messages, Writing Java
Programs that Can Run as Applets or Applications, Using Sounds and Images, Back to
the QuizShowApplet Applet.
The Graphics Class: Drawing Shapes, Images, and Text – The Project: Memory Game, The Graphics Class, Fonts and FontMatrics, Drawing Images, Using the Color Class, Getting Back to the Memory Game. Custom Events Handling and File I/O – The Project: The Block Game, Building the Block Class, Creating the BlockGrid Class,
Building the PlayArea Event Model, Creating the PlayArea Class, Creating the ScorelnfoPanel Class, Creating the Block Game Application. Creating Your Own Components and Packages – The Project: MinePatrol, Creating Lightweight
Components, Preparing to Create the jpr.lightweight Package, Building the MineCell Classes, Creating the Mine Field Classes, Creating the MinePatrol Application.
1. Java Programming for the absolute beginner, PHI, Joseph P. Russel (Text book).
1. E. Balagurusamy, Programming with Java – A Premier, McGraw-Hill.
2. Mike Mcgrath, Java in Easy Steps, McGraw-Hill.
3. Rashmi Kanta Das, Core Java for Beginners, Vikas Publishing.
4. Schildt,The Complete Reference Java 2, McGraw-Hill.
5. Dr. R. NageswaraRao, Core Java – An Integrated Approach, Dreamtech Press.
6. Joel Murach, Murach‘s Java Programming, Shroff Pubishers.
Practical List of Core Java
A1.Write an algorithm, draw a flowchart and develop a Java program to accept a number
from the user and print its factorial.
A2.Write an algorithm, draw a flowchart and develop a Java program to accept three
numbers from the user and print the largest number.
A3.Write an algorithm, draw a flowchart and develop a Java program to print first 10
A4.Write an algorithm, draw a flowchart and develop a Java program to to print the
*1 1 1
* * 1 2 2 2 2 2
* * * 1 2 3 3 3 3 3 3 3
* * ** 1 2 34 2 2 4 4 44
A5.Write an algorithm, draw a flowchart and develop a Java program to accept any 10
numbers from the user to store it in an Array and print the largest of all.
A6.Write an algorithm, draw a flowchart and develop a Java program to multiply two
matrices by accepting matrix elements from the user.
A7.Write an algorithm, draw a flowchart and develop a Java program to accept 10
names from the user to store them in array of string and print them in Alphabetical
A8.Write an algorithm, draw a flowchart and develop a Java program to demonstrate
A9.Write an algorithm, draw a flowchart and develop a Java program to demonstrate
A10. Write an algorithm, draw a flowchart and develop a Java program to accept any
digit number from the user and print its reverse.
A11. Write an algorithm, draw a flowchart and develop a Java program to find area of
rectangle, square, cylinder using the concept of method overloading.
A12. Write an algorithm, draw a flowchart and develop a Java program to accept a
number from the user and search that number in array of numbers.
A13. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
method overriding and method overloading.
A14. Write an algorithm, draw a flowchart and develop a Java program to define a
package P1 with class A having method show1() and show2(). Write another class B
in package P2 to access elements of class A in it.
A15. Write an algorithm, draw a flowchart and develop a Java program to declare
abstract class student having methods getName(), showName() and define these
methods in another class B and access them.
A16. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
i. public variables and methods
ii. private variables and methods
iii. Final class and Methods
iv. Default Variables
v. Protected Variables and Methods
A17. Write an algorithm, draw a flowchart and develop a Java program to display the
following using Applet
APPL E T
A18. Write an algorithm, draw a flowchart and develop a Java program to design user
login screen using Applet and provide the facility of valid user login.
A19. Write an algorithm, draw a flowchart and develop a Java program to draw
following using graphics class methods in a frame.
BCCA Syllabus RTMNU
A20. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
multithreading using moving balls example in
A21. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
multithreading using moving strings example in a frame.
A22. Write an algorithm, draw a flowchart and develop a Java program to change color
of applet window with following condition
a. Green Color should be for exact 3 sec
b. Red color should be for exact 1 sec
A23. Write an algorithm, draw a flowchart and develop a Java program to accept two
numbers from user and perform their division. Define an array with size 10, accept
index number from the user and store the value at that index of the array. The
exception if occurred for division should be handled in inner try block and exception
for array storage should be handled at outer try block.
A24. Write an algorithm, draw a flowchart and develop a Java program to define an
user defined exception sal_out_of_range and write a class named employee with
fields id, name, sal, phno and accept details of user according to id and store in the
variables, if sal exceeds 10000, sal_out_of_range should be thrown and handled
A25. Write an algorithm, draw a flowchart and develop a Java program to design a
registration form for new user creation. It should include fields such as First_Name,
Last_Name, User_Name, Password, Confirm_Password and Email. After user enters
complete data and clicks on Ok button, a dialog box should display message of
successful user creation else user creation failed message should be displayed. A
validation for password and confirm password should be performed in this practical.
A26. Write an algorithm, draw a flowchart and develop a Java program to handle all
mouse events using an example of cursor movement on a frame.
A27. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
card layout manager.
A28. Write an algorithm, draw a flowchart and develop a Java program to add a text
field, a choice control and a label on a frame. User should enter some text in the text
field then after hitting the enter key, entered text should be added to choice control
and label should display the number of items present in the choice control.
A29. Write an algorithm, draw a flowchart and develop a Java program to design a
menu called Text with MenuItems like Set Fore Color, Set Back Color, Set Font to
the text in the TextField on the Frame.
A30. Create a class named EmpAccDetails, add a method getEmpAccDetails to
accept Account Details of Employee such as Income tax paid, gross sal, basic sal,
HRA allowance. Add this class to a package EMP. Create another class called
EmpDetails with method getEmpPerDetails, also access getEmpAccDetails in the
same class by importing the EMP Package.
A31. Write an algorithm, draw a flowchart and develop a Java program to create three
child Threads, all threads should print numbers from 1 to 10 but condition is that
Thread 1 whenever starts printing the number should print all numbers completely
BCCA Syllabus RTMNU
without any break and then Thread 2 and 3 should print values as per the priority set
by the system.
A32. Write an algorithm, draw a flowchart and develop a Java program to accept 10
numbers from the user, store it in an Array and print them in Ascending order, also
print largest and smallest number of the array.
A33. Write an algorithm, draw a flowchart and develop a Java program to demonstrate
Parameterized Applet by loading images to the Applet Window using specific name
from the Parameter.
Paper - 4 : PHP & MySQLUNIT-1
Getting Started With PHP-Basic HTML Syntax, Basic PHP Syntax, Using FTP, Testing
Your Scripts, Sending Text To The Browser, Using The PHP Manual, Sending HTML To
The Browser, Adding Comment To The Script, Basic Debugging Steps. Variables-What
Are Variables?, Variable Syntax, Types Of Variables, Variable Values, Understanding
Quotation Marks. HTML Forms And PHP-Creating A Simple Forms, Choosing A Form
Data In PHP, Displaying Errors, Error Reporting, Manually Sending Data To A Page.
Using Numbers-Creating The Forms, Performing Arithmetic, Formatting Numbers,
Understanding Precedence, Incrementing And Decrementing A Number, Creating
Using Strings-Creating The HTML Forms, Concatenating Strings, Handling Newlines,
HTML And PHP, Encoding And Decoding Strings, Finding Substrings, Replacing Parts
Of A String. Control Structures-Creating The HTML Forms, The if Conditional,
Validation Functions, Using Else, More Operators, Using elseif, The Switch Conditional,
The For Loop. Using Arrays-What Is An Array, Creating An Array, Adding Items To An
Array, Accessing An Array From A Form.
Creating Web Applications-Creating Templates, Using External Files, Using
Constants, Working With The Date And Time, Handling HTML Forms With PHP, Making
Forms Sticky, Sending Email, Output Buffering, Manipulating HTTP Headers. Cookies
And Sessions-What Are Cookies?, Creating Cookies, Reading From Cookies, Adding
Parameters To Cookies, Deleting A Cookie, What Are Sessions?, Creating Session,
Accessing Session Variables, Deleting Session. Creating Functions-Creating And
BCCA Syllabus RTMNU
Using Simple Functions, Creating And Calling Functions That Take Arguments, Setting
Default Arguments Values, Creating And Using Functions That Return A Value,
Understanding Variable Scope.
Files And Directories-File Permissions, Writing To Files, Locking To Files, Reading
From Files, Handling File Uploads, Navigating Directories, Creating Directories, Reading
Files Incrementally. Intro To Database-Introduction To SQL, Connecting To MYSQL,
MYSQL Error Handling, Creating And Selecting A Database, Creating A Database,
Inserting Data Into A Database, Securing Query Data, Retrieving Data From A
Database, Deleting Data In A Database, Updating Data In A Database. Putting It All
Together-Getting Started, Connecting To The Database, Writing The User-Defined
Function, Creating The Template, Logging In, Logging Out, Adding Quotes, Listing
Quotes, Editing Quotes, Deleting Quotes, Creating The Home Page.
1. Larry Ullman, PHP for Web, Pearson.
1. Holznr, The Complete Reference – PHP, McGraw-Hill.
2. Mike Mcgrath, PHP & MySQL in Easy Steps, McGraw-Hill.
3. Steve Suehring, Tim Converse & Joyce Park, PHP and MySQL, Wiely.
4. Joel Murach & Ray Harris, murach‘s PHP and MySQL, Shroff Publishers.
5. Jason Gilmore, Beginning PHP and MySQL.
Practical List of PHP & My-SQL
1. Write an algorithm, draw a flowchart and Write a PHP script to print the value of
variable in PHP and use print function for printing.
2. Write an algorithm, draw a flowchart and Write a PHP script to print the values of
variable using echo.
3. Write an algorithm, draw a flowchart and Write a PHP script to print the following
pattern using nested loop.
* *** *
4. Write an algorithm, draw a flowchart and Write a PHP script to that creates the
following table using for loops. Add cell padding="3px" and cell spacing="0px" to
the table tag.
1 * 1 = 1 1 * 2 = 2 1 * 3 = 3 1 * 4 = 4 1 * 5 = 5
2 * 1 = 2 2 * 2 = 4 2 * 3 = 6 2 * 4 = 8 2 * 5 = 10
3 * 1 = 3 3 * 2 = 6 3 * 3 = 9 3 * 4 = 12 3 * 5 = 15
4 * 1 = 4 4 * 2 = 8 4 * 3 = 12 4 * 4 = 16 4 * 5 = 20
5 * 1 = 5 5 * 2 = 10 5 * 3 = 15 5 * 4 = 20 5 * 5 = 25
6 * 1 = 6 6 * 2 = 12 6 * 3 = 18 6 * 4 = 24 6 * 5 = 30
BCCA Syllabus RTMNU
5. Write an algorithm, draw a flowchart and Write a PHP script using nested for loop
that creates a chess board as shown below. Use table width="270px" and take
30px as cell height and width.
6. Write an algorithm, draw a flowchart and Write a PHP script to insert a new item
in an array on any position.
7. Write an algorithm, draw a flowchart and Write a PHP script to sort an array of
positive integers using the Sort function asort() and ksort().
8. Write an algorithm, draw a flowchart and Write a PHP script to for Creating,
Retrieving and Deleting data from the cookie using POST Method.
9. Write an algorithm, draw a flowchart and Write a PHP script to convert a date
from yyyy-mm-dd to dd-mm-yyyy.
Sample Date: 2012-09-12
Expected Result: 12-09-2012
10. Write an algorithm, draw a flowchart and Write a PHP script to remove the
whitespaces from a string.
11. Write an algorithm, draw a flowchart and Write a PHP function that checks if a string
is all lower case.
12. Write an algorithm, draw a flowchart and Write a PHP script to check whether a
entered string is palindrome or not
13. Write an algorithm, draw a flowchart and Write a PHP script to print Fibonacci
series using recursion.
14. Write an algorithm, draw a flowchart and Write a PHP script using switch case
and dropdown list display a -Hello. message depending on the language
selected in drop down list.
15. Write an algorithm, draw a flowchart and Write a PHP script to replace the first
'the' of the following string with 'That' –
16. Sample: 'the quick brown fox jumps over the lazy dog.'
17. Expected Result: That quick brown fox jumps over the lazy dog.
18. Write an algorithm, draw a flowchart and Write a PHP script to check that email id
is valid or not.
19. Write an algorithm, draw a flowchart and Write a PHP script to create a simple
'birthday countdown' script, the script will count the number of days between
current day and birth day.
20. Write a SQL statement to create simple table countries including columns
country_id, country_name and region_id.
21. Write a SQL statement to create table countries including columns country_id,
country_name and region_id and make sure that the column country_id will be
unique and store an auto incremented value.
22. Write a SQL statement to create a table named countries including columns
country_id, country_name and region_id and make sure that no countries except
Italy, India and China will be entered in the table.
23. Write a SQL statement to insert a record with your own value into the table
countries against each columns region_id.
24. Write a SQL statement to rename the table countries to country_new.
BCCA Syllabus RTMNU
BCCA New Syllabus Semester Pattern 2016 -17 onwards RTMNU
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,