Course Code – 3T4

UNIT – I

Introduction: Concept of the System, Types of Decisions, Information System, Classification of information System, Conventional File Processing System, Database System, Components of Database Management System, Economic 52

Justification of Database Approach. Database Concepts: Introduction, Data, Information, Metadata, Terminologies of Files, Association between Fields, Association between Files (Record Types), File Organization.

UNIT – II

Data Models: Introduction, Classification of Data Model, Entity Relationship Model. Database Design: Introduction, Steps of Database Design, Normalization, Case Problem, Data Volume and Usage Analysis, Integrated Case Study-Database Design for Academic institution. Implementation Design: Introduction, Implementation Design,

UNIT – III

Structured Query Language - I: Table fundamentals, viewing data in the tables, Eliminating duplicate rows when using a select statements, sorting data in a table, creating a table from a table, inserting data into a table from another table, delete operations, updating the contents of a table, modifying the structure of tables, renaming tables, truncating tables, destroying tables, creating synonyms.

UNIT-IV

Structured Query Language - II: Data Constraints, Types of data constraints, defining different constraints on a table, computations done on table data, ORACLE functions, Date conversion functions, Data functions, Miscellaneous functions, Grouping data from tables in SQL, Subqueries, Joins, concatenating data from table columns, using the UNIONS, INTERSECT and MINUS clause.

Text Books

1. R. Panneerselvan, Database Management Systems, PHI Publication.

2. Ivan Bayross, SQL, PL/SQL, BPB Publications.

Reference Books

1. Silberschatz, Korth, Sudarshan, Database System concepts, McGraw-Hill.

2. Gupta, Database Management Systems, McGraw-Hill.

3. Alexis Leon, Mathews Leon, Database Management System, Leaon Vikas.

4. Mike Mcgrath, SQL in Easy Steps, McGraw-Hill. 53

BCCA Part – 2  Semester –  1 ( Old 2016-17 onwards )

Paper -I: Environmental Studies ( Old 2016-17 onwards )

UNIT-I
Multidisciplinary Nature of Environmental Studies-Environment, Environment Studies, Need for public Awareness, Environmental Degradation, Shelter Security, Economic Security, Social Security, Effects of Housing on Environment , Effects of Industry on Environment. Natural Resources-Introduction, Types of Natural Resource, Forest Resources, Water Resources, mineral Resources, Food Security Resources, Energy resources, Land Resources, Conservation of Natural Resources, Sustainable Lifestyles, Sustainable Water Management(SWM), Biogeochemical Cycle.
UNIT – II
Ecosystem-Introduction to Ecology and Ecological Succession, Ecosystem, Food Chain, Ecological Pyramids, Types of Ecosystems, Forest Ecosystems, Aquatic Ecosystems, Grassland Ecosystem, Desert Ecosystem. Biodiversity and its
Conservation-Biodiversity, Values or Benefits of Biodiversity,Biogeographic Zones of India, Hot Spots of Biodiversity, Endangered and Endemic Species, Rare and
Threatened Species, Threats to Biodiversity, Human –Wildlife Conflicts, Conservation of Biodiversity.
UNIT – III
Environmental Pollution and Its Effects-Introduction ,Requirements of a Nonpolluted Environment, Public Health Aspects, Air Pollution, Land Pollution, Land Pollution or Soil
Pollution, Marine Pollution, Noise Pollution, Thermal Pollution, Hazardous Wastes, Nuclear Hazards (Radiation Pollution),Solid Waste and Its Management, Role of Individuals in Pollution Prevention, Disaster Management.
UNIT – IV

BCCA Syllabus RTMNU
Social Issues and the Environment-Introduction, Sustainable Development, Urbanization, Water Conservation, Resettlement and Rehabilitation of People ; Its Problems and Concerns, Social Issues and The Environment, Wasteland Reclamation,
ACTs for Environmental Protection, Carbon Credits, Industrial Symbiosis, Initiatives and Roles of Nongovernmental Organization (NGOs) in Environmental Protection, Issues
Involved in Enforcement of Environmental Legislation ,Animal Husbandry. Human population and the Environment-Population Growth, Family Welfare Programs, Environment and Human Health, Fundamental Rights, Human Rights, Value Education,
HIV/AIDS, Environmental Education, Women‘s Education, Role of Information Technology in Environment and Human Health.

Text Book

1. Shashi Chawla , Environmental Studies, McGraw-Hill.

Reference Books
1. Dr. D. K. Asthana, Dr. Meera Asthana ,Environmental Studies, S. Chand.
2. Dr. K. Mukkanti, Environmental Studies, S. Chand.
3. Dr. D. D. Mishra,Fundamental Concepts in Environmental Studies, S.Chand.
4. Benny Joseph, Environmental Studies, McGraw Hill Education.

Paper -II: Business Economics ( Old 2016-17 onwards )

UNIT – I
Introduction: Economics And Business Economics -Introduction, What Is Economics, Definitions, Nature And Scope Of Business Economics, Some Economics Concepts Applied In Business Analysis. The Economy, Its Basic Problems And Price Mechanism :-Introduction, What Is An Economy?, How A Free Enterprise Economy Works, Kinds Of Economic Systems, Production Possibilities Of An Economy, Basic Problems Of An Economy, How Market Mechanism Solves The Basic Problems, All Is Not Well With Free Enterprise Economies, Role Of The Government In The Economy. Laws Of Demand And Supply And Market Equilibrium :-Introduction, The Concept
Of Market, Demand Side Of The Market, Supply Side Of Market, Market Equilibrium, Stability Of Market Equilibrium. Theory of Consumer Demand: Analysis Of Individual Demand -Introduction, Meaning Of Individual Demand, Utility-The Basis Of Consumer Demand, Cardinal Approach To Consumer Demand, Ordinal Utility Approach To Consumer Demand –The Indifference Curve Approach, Comparison Of Cardinal And
Ordinal Utility Approaches, Revealed Preference Theory, Consumer Surplus. Elasticity Of Demand :-Introduction, Meaning Of Demand Elasticity, Price Elasticity Of Demand,
Cross-Elasticity Of Demand, Income-Elasticity Of Demand, Advertisement Elasticity Of Demand, Price Expectation-Elasticity Of Demand, Some Estimates Of Demand Elasticity. Demand Forecasting: -Introduction, Meaning And Purpose Of Demand Forecasting, Prerequisites Of Good Demand Forecasting, Methods Of Forecasting Demand, Concluding Remarks, Some Case Studies Of Demand Forecasting.
UNIT – II
Production And Cost Analysis: Theory Of Production -Introduction, Some Basic Concepts, Production Function, Laws Of Production-Meaning And Kinds, Short-Run Laws Of Production, Long-Term Laws Of Production-I:Tools Of Analysis, Long-Term Laws Of Production-II: Laws Of Return To Scale, Laws Of Returns To Scale Through Production Function. Theory Of Cost -Introduction, Cost Concepts, Cost Function,
Short-Run Cost-Output Relations, Long-Run Cost Output Relations, Economics And Diseconomies Of Scale, Modern Theory Of Cost. Market Structure And The Firm‘s Objectives -Introduction, Market Structure And Degree Of Competition, Market Structure And Pricing Decisions, The Firm And The Industry, Profit: Meaning And Concepts, Objectives Of Business Firms, A Reasonable Profit Target: A Pragmatic
Approach, Profit As Control Measure. Price And Output Determination Under Perfect Competition -Introduction, What Is Perfect Competition? Features Of Perfect Competition, Price Determination Under Perfect Competition, Equilibrium Of The Firm In Short-Run, Derivation Of Supply Curve, Equilibrium Of Industry And Firm In Short-Run, Equilibrium Of The Firm And Industry In Long-Run, Long-Run Supply Curve Of The Industry.

UNIT – III
Pricing Decisions Under Monopoly -Introduction, Definition And Features Of Monopoly, Sources And Kinds Of Monopolies, Revenue Curves Under Monopoly, Price And Output Determination In Short-Run, Two Common Misconceptions About Monopoly, There Is No Supply Curve In Short-Run, Monopoly Equilibrium In The Long-Run, Capacity Utilization Under Monopoly, Equilibrium Of Multiplant Monopoly, Price
Discrimination Under Monopoly, Monopoly Vs. Perfect Competition, Application Of Monopoly Theory, Measures Of Monopoly Power, Government Regulation Of Monopoly Prices. Pricing Decision Under Monopolistic Competition -Introduction, Monopolistic Competition: Definition & Characteristics, Basic Elements Of Monopolistic Competition, Firms Equilibrium Under Monopolistic Competition, Excess Capacity Under Monopolistic
Competition, Selling Cost And The Firm‘s Equilibrium: Non-Price Competition, Monopolistic Competition Vs Perfect Competition: A Comparison, Drawbacks Of Chamberlin‘s Theory Of Monopolistic Competition. Pricing Decisions Under Oligopoly -Introduction, Oligopoly: A Market Of Few Sellers, The Oligopoly Models: An Overview, A Classical Model Of Duopoly: Cournet‘s Model, Chamberlin‘s Model Of Oligopoly : The Small Group Model, Sweezy‘s Kinked-Demand Curve Model, Price And Output Determination In Collusive Oligopoly, Baumol‘s Theory Of Sales Maximization, Oligopoly And The Game Theory.

UNIT – IV
Factor Market: Factor Demand And Supply -Introduction, Marginal Productivity Of Factor And Factor Demand, The Factor Supply: An Overview, Derivation Of Individual Labor Supply Curve, Derivation Of Market Labor Supply Curve. Theory Of Wage Determination -Introduction, Wage Determination Under Perfect Competition, Wage Differentials, Wage Determination Under Product Monopoly And Competitive Labor Market. Theory Of Rent, Quasi-Rent And Economic Rent -Introduction, Ricardian Theory Of Rent, Quasi-Rent: The Short-Term Rent On Fixed Factors, Factor Price, Transfer Earning And Economic Rent. Theory Of Interest -Introduction, Meaning Of Interest And Interest Rate, The Classical Theories Of Interest, The Loanable Fund Theory Of Interest, Keynesian Theory Of Interest. Theory Of Profit -Introduction, The Meaning Of Profit And Pure Profit, Accounting Profit Vs Economic Profit, Theories Of Profit, Does Profit Enter The Cost Of Production?.

Text Book

1. D. N. Dwivedi, Essentials of Business Economics, Vikas Publishing House Pvt. Ltd.

Reference Books
1. David P. Doane, Lori E. Seward, Applied Statistics in Business and Economics, McGraw-Hill.
2. Amit Kumar Upadhyay, Principles of Economics, Vikas Publishing House Pvt. Ltd.
3. P. K. Mehta, Business Economics, Taxmann.
4. Michael Mandel, Economics The basics, McGraw-Hill.
5. Sudip Chaudhuri, Anindya Sen, Economics, McGraw-Hill.
BCCA Syllabus RTMNU
6. Geetika, Piyali Ghosh, Purba Roy Choudhury, Managerial Economics, McGraw-Hill.

Paper -III: Visual Basic Programming ( Old 2016-17 onwards )

Unit – I
Introduction To Visual Basic – Advantages Of Visual Basic, Hardware Requirement, Software Requirement, Installing Visual Basic, Starting Visual Basic, Exiting From Visual Basic. Working With Visual Basic Window Components – Menu Bar, Standard
Toolbar, Project Explorer Window, Form Layout Window, Properties Window, Toolbox, Code Editor Window, Object Browser, Customizing The Application Development Environment, Editor Tab, Editor Format Tab, General Tab, Docking Tab , Environment Tab, Advance Tab. Working With Forms – Extension & With Function Of The File, Properties, Events And Method Of The Form. Using The Controls Of Visual Basic – Using Label Control, Using Commandbutton Control, Using Textbox Control, Using Option Button Control, Using Frame Control, Using Checkbox Control, Using Listbox Control, Using Combobox Control, Using Image Control, Using Scroll Control, Using Picture Control, Using Timer Control, Using Drivelistbox Control, Using Dirlistbox, Using Filelistbox Control, Using The Shape Control. Basic Programming Fundamentals –
Scope Of Variables, Arrays, Operators, Decision Structure, Loop Structure.

Unit – II
Working With Procedure, Functions And Modules – Procedure, Functions, Modules Accessing Files – Sequential Method, Random Method, Binary Method. Menus – Creating Menus, Creating Popup. Working With Common Dialog Control – Showopen, Showsave, Showprint, Showfont, Showcolor, Showhelp. Control Arrays – What Is Control Arrays?, Creating Control Arrays Using The First Method, Control Arrays Using The Second Method, Control Arrays Using The Third Method, Use Of Load And Unload Statement. Working With Custom Controls – Imagelist Control, Imagecombo Control, Treeview Control, Listview Control, Sorting Listitems, Toolbar Control, Statusbar Control.
Unit – III
Creating Mdi Applications – Features Of Child Form, Arranginh Windows, Window List Creating An Application – Making An Exe File, Taking Printouts. Database Handling – Creating The Database, Accessing The Database By Using The Data Control, Using Ado Data Control. Working With Advance Data Controls – Datalist Control, Datacombo Control, Datagrid Controls, Setting The Properties Of The Datagrid Control, Mshflexgrid Control, Setting The Properties Of Mshflexgrid Control, Sorting A Column, Merging Cells, Description Of Merge Options, Using The Data Form Wizard, Working With Ms Chart Layout. Working With Sql Statement – Displaying All Fields, Displaying Selected Fields, Modifing The Data, Creating Search Program, Creating Numeric Search Programs, Creating Complex Search Program.

Unit – IV
Debugging Techniques – Syntax Errors, Logical Errors, Run-Time Error, Debug Toolbar, Assert Method, Debugging Mode, Step Into, Step Out, Run To Cursor, Set Next, Show Next, Locals Window, Immediate Window, Watch Window, Edit Watch, Deleting Watch Expression, Quick Watch, Call Stack. Handling Errors – How Run-Time Error Occurs?, Trapping Error, Handling Errors, Resuming Program Execution, Resume,
Resume Next, Using Resume Next, Err Object, Properties, Methods. Working With Data Environment And Data Report –
SQL Query Builder, Data Report, Use Of Controls, Using The Function Control, Using The Page Footer. Working With Com
Components – What Is COM?, Introduction, Activex Controls, Using The Activex Control, Creating The Activex Control, Using The Activex Control In The Standard EXE, Activex Documents, Benefits, Creating An Activex Documents, Lifetime Events Of An Activex Documents, Describing About Hyperlink Object, Propertybag Object, Write Property, Read Property, Property Change Method, Inserting Menus, Activex Document Migration Wizard, Activex Code Components, Setting Project Properties

Text Book
1. Soma Dasgupta, Visual Basic – to Advance, BPB Publications.

Reference Books
1. Mohammad Azam, Programming with Visual basic, Vikas Publishing House Pvt. Ltd.
2. Mike Mcgrath, Visual basics in Easy Steps, McGraw-Hill.
3. Michael Vine, Microsoft Visual Basic Programming, PHI.
4. Evangelos Petroutsos, Mastering Visual basic, Wiley India Pvt. Ltd.

Practical List of Visual Basic Programming ( Old 2016-17 onwards )

BCCA Syllabus RTMNU


B1. Draw a Flowchart. Write an Algorithm and Program to calculate the bonus for the Employee using user defined data types. If grade is A then bonus will be 1000, if B bonus 7000, if C bonus 5000, otherwise no bonus will be given. If the users
have to reuse the program then all the values should be cleared and the cursor should be set to the first control. (Note -Use option button & frames)
B2. Draw a Flowchart. Write an Algorithm and Program to give options of Font size, Font color and Font face in the check boxes. Convert the text in the text box by applying the selected fonts.
B3. Draw a Flowchart, write an Algorithm and Program to increase & decrease the width of command button. And to change the position of command button (top & left) on the form using scrollbar.
B4. Draw a Flowchart. Write an Algorithm and Program to generate a thermometer using vertical scrollbar.
B5. Draw a Flowchart. Write an Algorithm and Program to accept an employee_no, emp_name from the user. Display several cities in the list box in which your company have the branches. Allow the user to do the following.
a. User should add the city if new branch opens.
b. Display the selected city.
c. Remove the city if the branch closed.
d. Create another list box in which user can add the metropolitan cities.
Note : Multiple cities can be added from the available cities.
B6. Draw a Flowchart. Write an Algorithm and Program to find the reverse of a 4 digit number and print the sum of all the digits.
B7. Draw a Flowchart. Write an Algorithm and Program to enter a base number and an exponent number from the user. Calculate exponential value of an entered base number.
(For Example, if base = 2and the exponent = 5 then the value will be 32)
B8. Draw the Flowchart. Write an Algorithm and Program to ask a Password while opening a project. Validate the user‘s password for 3 times, else do not allow the user to open the project.
B9. Draw a Flowchart. Write an Algorithm and Program to generate a stopwatch of 10 minutes using timer control.
B10. Draw a Flowchart. Write an Algorithm and Program to calculate the age of the user in year, month and days as on the current date.
B11. Draw a Flowchart. Write an Algorithm and Program to match the given pairs.
1. Sachin Tendulkar
a. Boxing
2. Vishwanath Anand
b. Tennis
3. Leander Pace
c. Chess
4. MikeTyson
d. Cricket
B12. Draw a Flowchart. Write an Algorithm and Program to conduct a competitive examination. The examination contains 5 questions and each question is having 4 option. Assign 10 marks for every appropriate answer & 0 for wrong. Display
the total marks at the end.
B13. Draw a Flowchart. Write an Algorithm and Program to add and subtract two different matrices.
B14. Draw a Flowchart. Write an Algorithm and Program to prepare a calculator. The calculator includes following operations -addition, subtraction, multiplication, division.
B15. Draw a Flowchart. Write an Algorithm and Program to calculate the area of a triangle and the area of circle.
Area of Triangle = 1/2 x Base x Height
Area of Circle = Pi x Radius x Radius
B16. Draw a Flowchart. Write an Algorithm and Program to enter the temperature in degree & convert it into Fahrenheit and vice versa. Celsius = (F-32) x (5/9 )
Fahrenheit = (C+ 32)x(9/5 )
B17. Draw a Flowchart. Write an Algorithm and Program to calculate the average of five numbers using focus event.

BCCA Syllabus RTMNU
B18. Draw a Flowchart. Write an Algorithm and Program to input text from the user & change it to Upper case and Lower case using option buttons.
B19. Draw a Flowchart. Write an Algorithm and Program to generate an Electricity Bill.Input customer number, customer name, current reading, last reading and area from the user. Are should be any one from the following
I. Household II. Industrial III. Non Household IV. Urban V. Rural VI. Agriculture VII. Poultry Farm
Rates for Household : Rates for Industrial :
1 to 30 -Rs.1 1 to 1000 -Rs.2.40
31 to 100 -Rs. 2.55 1001 to 15000 -Rs. 3
101 to 300 -Rs.2.95 15001 and above -Rs. 3.40
301 and above -Rs. 4.55
Rates for Non Household : Rates for Urban :
1 to 100 -Rs.2.50 For all -Rs. 2.25
201 and above -Rs. 5
Rates for Rural :
Rates for Agriculture :
For all -Rs. 1.40 For all -Rs. 1.90
B20. Draw a Flowchart. Write an Algorithm and Program to input ASCII values from the user & classify them into Small letters, Capital letters, Numeric value & special characters.
B21. Draw a Flowchart; write an Algorithm and Program to generate a Telephone Bill. Input customer number, customer name, telephone number, current reading, last reading, the month of billing and area as Urban OR Rural from the user. Calculate the bill as follows
Call rates for Urban area :Free Calls -150
151 to 400 -0.80 Rs.
401 to1000-Rs. 1
1001 and above -Rs. 1.20
Call rates for Rural area :Free Calls -250
251 to 450 -0.60 Rs.
451 to 500 -Rs. 0.80
501 to1000-Rs. 1
1001 and above -Rs. 1.20
B22. Draw a Flowchart, write an Algorithm and Program to sort a Numeric Array using Linear Sort method.
B23. Draw a Flowchart. Write an Algorithm and Program to sort a String Array using Bubble Sort.

BCCA Syllabus RTMNU

Paper -IV: Database Management System ( Old 2016-17 onwards )

UNIT – I
Introduction: Concept of the System, Types of Decisions, Information System, Classification of information System, Conventional File Processing System, Database System, Components of Database Management System, Economic Justification of Database Approach. Database Concepts: Introduction, Data, Information, Metadata, Terminologies of Files, Association between Fields, Association between Files (Record Types), File Organization. Data Structure: Introduction, Location Methods, Types of Pointer, Interrecord Data Structure.
UNIT – II
Data Models: Introduction, Classification of Data Model, Entity Relationship Model. Database Design: Introduction, Steps of Database Design, Normalization, Case Problem, Data Volume and Usage Analysis, Integrated Case Study-Database Design for Academic institution. Implementation Design: Introduction, Implementation Design, Guidelines for mapping Conceptual data model into a desired logical Data Model, Problem Design Guidelines.
UNIT – III
Hierarchical Database Management Systems: Introduction, Information Management System (IMS), PC-FOCUS. Network Database Management Systems: Introduction, Integrated Database Management Systems (IDMS). Relational Database Management Systems: Introduction, Relational Database Languages, Interactive SQL.
UNIT-IV
Distributed Database Management Systems: Introduction, Types of data Processing Application, Distinction between Centralized Databases and Decentralized Databases, Database Portioning, Case Study on Vertical Partitioning (Schema level Partitioning). Client/Server Systems: Introduction, Client/Server Concept, Examples of Client/Server
Systems, Three-Tier Client/Server Architecture, Types of Client, Client/Server Protocols, Benefits and Drawbacks of Client/Server Systems, Design and Implementation Issues of
Client/Server Design. Database Operations and Maintenance: Introduction, Database Administration (DBA), Security Mechanisms, Concurrency Control, Database Recovery,
Cryptography for Network Security.

BCCA Syllabus RTMNU
Text Books
1. R. Panneerselvan, Database Management Systems, PHI Publication.

Reference Books
1. Silberschatz, Korth, Sudarshan, Database System concepts, McGraw-Hill.
2. Gupta, Database Management Systems, McGraw-Hill.
3. Alexis Leon, Mathews Leon, Database Management System, Leaon Vikas.
4. Mike Mcgrath, SQL in Easy Steps, McGraw-Hill.
5. Dr. P. S. Deshpande, SQL & PL/SQL for Oracle 11g, Dreamtech Press.
6. Ivan Bayross, SQL, PL/SQL, BPB Publications.

Practical List of Database Management System

1. Write a SQL Query to create a table.employee.:
Field Name Datatype Size
Emp_no varchar2 5
Emp_name varchar2 25
Address varchar2 50
Phone_number number 10
Designation varchar2 15
Salary number 15

1. Display the structure of table.
2. Add qualification field at the end of employee table.
3. Modify the size of the name field 25 to 30.
4. Display the employee name whose salary is greater than 20,000.
5. Display the employee details whose name starts with .A..
2. Write a SQL Query to create a table .student.:
Field Name Datatype Size Constraint
Roll number 5
Name varchar2 30
Address varchar2 30
City varchar2 30
DOB date
Phone number 11
Class varchar2 10
Marks number (10, 2)

1. Display the structure of database and insert 10 records.
2. Display student information for all student in city Pune and Nagpur.
3. Display student information where marks greater than 80 and less than 90.
4. Display student name where first two character of student name =An‘.
5. Change student name to Ashish where student roll number A001.
3. Write a SQL Query to create a table .sales_details.:
Field Name Datatype Size
S_id varchar2 8
P_id varchar2 8
P_name varchar2 15
Price number 10
Qty number 8

1. Drop foreign key constraint on column p_no in table sales_details.
2. Add foreign key constraint on column sale_no in table sales_details.
3. Modify the column qty to include not null constraint.
4. Insert 10 records in sale_details.
5. Display p_id and total of quantity qty for each product.
6. Display p_id and total of price for all the products.
4. Write a SQL Query to create a table .customer.:
FieldName Datatype Size
Cust_no varchar2 10
Cust_name usertype
Address varchar2 10
Salary number 10

1. Modify address field with not null.
2. Add city field as it must keep city name Mumbai, Delhi and Kolkata.
3. Add salary field where salary greater than 20,000.
4. Display the structure of table customer.
5. Insert 10 records into the table customer.
6. Display all the customer details who lives in Mumbai and Kolkata.
7. Display all the customer records whose salary>20,000 and salary<30,000.
8. Modify the address field where customer number is =C001‘.
5. Write a SQL query to create c_master with fields c_no, name, address, city, state and
pin_code:
Field Name Datatype Size

C_no varchar2 10
Name varchar2 10
Address varchar2 10
State varchar2 20
City varchar2 20
Pin_code number 10

1. Create sequence which will generate number from 1..999 in ascending order, with an interval of 1 and in cyclic order.
2. Insert 10 records.
3. Create index on c_master which column name c_no and state.
4. Create view on c_master .
5. Select columns c_no, city which belongs to Nagpur and Mumbai.
6. Write a SQL query to create a syntax seq_order which generating numbers from
1…9999 in ascending will number with an interval of 1 in cyclic order.
Field Name Datatype Size

P_no varchar2 10
P_name varchar2 20
Qty varchar2 10
P_rate varchar2 10

1. Display next value of sequence seq_order.
2. Display current value of sequence seq_order.
3. Insert values in sal_order table must be generated using sal_order sequence.
4. Display all records of sal_order table.
5. Change a cache memory of 50 seq_order sequence having interval 2.
6. Drop sequence.
7. Write a SQL Query to1.
Create an index employee_index depends on employee table using field name.
2. Create a view depends on employee table.
3. Display the records from the view where city as Delhi and Mumbai.
4. Update the view where employee id is =E006‘.
8. Write a SQL query to illustrate numeric function.
1. Sqrt 2. Ceil 3. Power 4. Floor 5. Round
6. Mod 7. Abs 8. Exp 9. Greatest 10. Least
9. Write a SQL query to create tablespace datauser or data where size of file 100MB
extend it by 10MB reach upto 250MB in size. Create user data1 with default tablespace
and temporary tablespace. Create role acc_create with create session, create user, alter
user and assign role to user. Assign profile to user where user should fail after 5 attempt
and valid for 3 days. Destroy user data1 and tablespace from system.
10. Write a SQL query for join, inner join, outer join, self join and Cartesian join.

BCCA Part 1 Semester 1 New & Old

BCCA Part 1 Semester 2 New & Old

BCCA Part 2 Semester 3 ( BCCA Semester 3 ) New & Old

BCCA Part 2 Semester 4 ( BCCA Semester 4 ) New & Old

BCCA Part 3 Semester 5 ( BCCA Semester 5 ) New & Old

BCCA Part 3 Semester 6 ( BCCA Semester 6 ) New & Old

BCCA Syllabus

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 B.Arch Bachelor Of Architecture, Others,

Basic Programming

Testing

Hardware & Networking