Bachelor of Commerce in Computer Application (BCCA)

First Year (Part 1)

A. COMMERCE GROUP

PAPER-I :ENGLISH & BUISNESS COMMUNICATION

I. TEXTUAL PORTION

The following items are prescribed:

PROSE:

1. Child marriage

2. Sir roger at church

3. of travel

4. all about a dog

5. the ant and the grasshopper

6. the fortune teller

7. the Doctor’s word

8. the Barber,s trade union

One Act play: the never never nest

II. BUISNESS COMMUNICATION:

SECTION-A : Comprehension(unseen passage)

SECTION- B : Paragraph Writing, Description and narration, Writing Adevertisment, writing news paper reports.

SECTION-C: Buisness correspondence, Credit and collection letters, quotation Letters (inviting/ sending quotations), placing orders.

SECTION –D : Process of communication and presentation skills:

Communication-Signs & synbols- process of communication – speech Act theory - principles of communication – noise - vertical communication- lateral communication – diagonal Communication-myths and realities of Communication- Barrier to communication- Rules for overcoming barriers -differencr between listening and hearing – the listening process- type s of listening – essential for good listening – deteerents to listening process- presentation skills- evev steps to a successful presentation- body sport: positive gestures-hand shakes- smile- hand movements-style of walking-Group discussion and interviewes: qualities looked for in GD’s- Strategies for GD’s- Body sport for group Discussion- pre-plannning for interviews- facing the interview- body sport for interviews.

PAPER-II : PRINCIPLES OF BUISNESS MANAGEMENT

Unit-I

1 . Nature and scope of Buisness: Meaning and Defination of business, characteristics and objectives of business, classification of business activities, industry, commerce & trade, social responsibility of business towards different groups.

2. Forms of business units: sole trader, joint stock company and co-operative society- meaning, characteristics, advantages and disadvantages.

3. Management and it’s process: meaning and definition of management, charctristics, scope, importance, management and administration, management-ascience or art, levels of management, management, process, development of management trough, management of change and conflict, management in changing environment.

Unit-II

4. Planning : meaning, nature and charctristics, objects, process, importance, types components. Decision making – concept, characteristics, importance, process, types of decisions.

5.Staffing: determining the needs of staff, staff recruitment, sources of recruitment, different methods of recruitment, selection personnel- meaning, cope of selection process.procedure-interviewing meaning, objectives, types & principle s of interviewing, training –importance, types & methods, management development-importance,objects, technique 7 methods.

6. organizing : concept, principles, types-line, functional, line and staff, formal and informal organization, advantages, disadvantages, distinction between formal and informal oraganisation.

Unit-III

7. Delegation of authority: meaning and definition, elements of delegation of authority, advantages , obstacles in the process of delegation, centralization & Decentalisation- meaning degree of centralization & decentalisation, causes advantages and disadvantages.

8. Direction: meaning, nature, importance and techniques.

9. Communication: meaning, role and importance, scope types, media, essential of effective communication.

10. co-ordination : meaning, principles, internal and external, co-ordination, methods of achieving effective co-ordination

Unit –IV

11.Motivation:Meaning, importance, factors of motivation, financial and non –financial incentives, theories of motivation-Maslow’s need hierarchy theory, megregor’s theory x and theory y, Herzberg’s two- factor model.

12. Leadership and morale: leadership- concept, characteristics, types and qualities. Morale – meaning, high and low morale, measurement of morale, morale of excutive and supervisors.

13. Control :meaning , characteristics, need, procedure, types, essential of good control system, control devices.

PAPER-III : BASIC ECONOMICS & BUISNESS ENVIRONMENT

Part A : Basic Economics (70 marks)

Unit-I

Nature and scope of economics- definition, nature and scope of economics; micro and macro economics, positive and normative economics, working of economics systems with special reference to the capitalistic, socialistic and the mixed economics.

Unit –I

Demand analysis- utility analysis - total utility and marginal utility, law of diminishing marginal utility, law of equi –marginal utility. Indifference curves- meaning, properties, marginal rate of substitution, consumers, equilibrium, law of demand, elasticity of demand.

Unit-II

Production, cost and revenue analysis- law of return so scale, cost and revenue concepts and their relationship with o/p, economies and diseconomies of scale.

Theory of price: Equilibrium of the firm and industry- price and output determination under perfect competition, monopoly and monopolistic competition.

Unit-III

National Income: Concept, significance and measurement of national income

Money and Credit : Concept and features of inflation, demand pull and cost push inflatin, measures to control inflation and measures to control it; stagflation. International Trade and balance o payments and their relation nship, measure against alance of payment disequilibrium.

Unit –IV

Part B: Buisness Environment (30 marks)

Buisness Environment-An Overview : The concept and relevance of business environment; government failure and market failure, market guidance V. State regulation.

Indian Economy: Salient features of Indian economy-a mixture of market forces and government regulation; roles assigned to public and private sectors. Role of government in the area of (i) infrastructure; (ii) industrial policy; (III) labour and industrial relations (iv) foreign trade, balance of payments and foreign investment and (v) taxation and subsidies.

PAPER-IV : FINANCIAL ACCOUNTING

Unit-I

An overview of basics of book keeping and accountancy: Theory and practice pertaining to recording of transactions in an integrated manner right from basic rules to final accounts.

Accounting concept and conventions and relevant Accounting standards.

Accounting policies and their disclosure

Consignment accounts.

Unit-II

Description accounting including methods thereof.

(Straight line method, reducing Balance metod, Annuity metod, Dep.fund Investement Method, dep.fund insurance policy method)

Accounting for Hire purchase and Installement.

Unit-III

Partenership Accounts: Amaigamation of Partnership firms, conversion of partnership firms into a limited company. Receipts and payments account and Income & extenditure account and balancesheet including accounts of professional concerns.

Unit –IV

Branch Accounts including Foreign Branch

Accounts of Co-operative Societies:

• Preparation of cash Book

• Final Accounts of C0-Operative Societies (as per Maharastra co-op. societies Act,1960)

BCCA -B.Com Computer Application Part 1 Computer Group

B. COMPUTER GROUP

PAPER-V: INFORMATION SYSTEM

Unit-I

Block diagram of Computer, Functioning of computer, generations of computer, classification of computers, characteristics advantages & limitation of computer.charcteristics advantages & limitation of computer. Computer organization,Central processing Unit-speed of processor, computer memory, primary & Secondary , types of primary memory, registers, storage devices: floppy disk, hard disk, magnetic tapes, optical disk( CD /DVD), solid state storage( flash memory cards,pen drive etc.) input devices: keyboard,mouse, joystick, lightpen, scanners, OCR,MICR

Unit-II

Software and programming languages

Introduction types of softwares, characteristics of good program, development of programming language-machine language, assembly language, high level language.

Data representation: Binary, decimal, octal, hexadecimal number, systems, features & conversation. BCD, EBCID & ASCII codes.Computer communication, Wirelesss communication, need for networks, forms of data communication-analog, digital,data transmission modes,dta transmission media (twisted pair, co-axial, fibre optic, microwave, satellite communication), bandwidth, protocols, modems & multiplexers, Type of network-LAN,WAN, MAN, concept of network toplology, types of toplologies, advantages & limitations.

Unit-III

System software VS application software, operating System, definition, Need, functions, Types of operating system, Simple batch system, multiprogramming, time system, multiprocessing, on-line and off-line processing, multitasking.

Introdction to Disk Operating system(DOS)

File Type, Directory structure, booting-warm and cold;Internal and External commands; introduction to autoecec and config files; directory commands: DIR, MD,CD, RD, TREE, PATH< SUBST etc; Commands to related to File management-Copy, DEL, ERASE, REN, ATTRIB, XCOPY, BACKUP and Restore commands, general commands-TYPE, DATE, TIME, PROMPT etc., batch commands, wild card charcter & its use.

Unit-IV

Introduction to windows Operating System, advantages of windows operating System, Using Different Windows applications.simultaneously, operating with windows, gui, use of help features, starting an application, essential accessories, creating shortcuts, windows explorer, control panel, my computer, my documents, recycle bin, finding folders and files, changing system settings, system tools, use of run command, setting peripherals, drivers, editing graphics in windows, new features in windows, Xp/ vista versions.

Paper-VI : INFORMATION TECHNOLOGY

Unit-I : Word Processing

Introduction, starting word, creating document, structure of ms-word window and it’s application, mouse & keyboard, operation s, designing a document, formataing – selection, cut, copy, paste, Toolbars, operating on Text, printing & saving, opening, closing of document, creating a template, tables, borders, textbox, operations, spelling and grammer check.

Mailmerge, envelope and label, protection of document, change the view of document.

Unit-II spreadsheet package

Introduction to Ms-excel,navigating, excel toolbars and operations, formatting features- copying data, between worksheets,entering and Editing cell entries, cereation of charts, editing and formatting charts, goalseek, auditing, liking, workbook, database in excel(auto filter, advanced filter, sort, form), mathematical, statistical and financial functions in ms-excel.

Unit-III : powerpoint presentation

Working with powerpoint windows, standard toolbars, formatting toolbars,drawing Toolbars, moving the frame, inserting clip art, picture, Slide, Textstyling, send to Back, entering data to graph, organization chart, table, design, template, masterslide, animation setting, saving and presentation, auto content wizard, package for CD (Pack & Go features)

Unit-IV: Ms- Access

Intoduction to database management System, DBMS vs RDBMS. Database administrator (DBA) and its role. Introduction to micrsoft access.Creating adatabase in acess, Using database wizard and blank database, creating table, dtanbase view and desin view, creating queries, forms, reports and macros in ms- access.

(A) COMMERCE GROUP

PAPER-1 : COST & MANAGEMENT ACCOUNTS

UNIT-I

Meaning, importance and scope of cost accounting, distinction between financial accounting and cost accounting, methods of costing.Elements of cost and allocation thereof, single and output costing, cost sheet and tender.

Reconciliation of profit shown by financial accounts and cost accounts.

Unit-II

Contract costing –one or two contacts for one year only.placement of important items in the balance sheet of contractor s.process costing –simple process costing & sales of byte product.

Unit-III

Meaning, objects, advantages, importance, tools and techiniques of management accounting . Distinction between financial accounting, Cost accounting and management accounting. Ratio analysis- Meaning, nature, analysis, significance & limitation s of ratio analysis. Ratio as tools of interpretation of financial statements.

Computation of ratios- Gross profit ratios, net profit, net profit ratio, operating net profit ratio operating, ratio, expenses ratio stocks, turn over ratio, current ratio, liquidity ratio, debetors turn over ratio, creditors, turn over ratio, fixed assets turn over ratio, debt equity ratio, earning per share.

Break even analysis – Meaning, need, importance & limitation

Computation – profit volume ratio, break even point, margin of safety, estimate sales for requires profit & estimated profit for given sales.

Unit-IV

Fund flow statement –meaning, concepts, importance & limitations, preparation of fund flow statement

Buisness budgets and Budgetory control-Type of budgets and its utility, preparation of cash & flexible budgets.

PAPER-II : STATISTICS & QUANTITATIVE TECHNIQUES.

Statistical Techniques

Unit-I

Descriptive statistics- functions, scope, distrust and limitation of statistics.

Statistical data collection- Primary and Secondary data, method of collecting primary data sources and secondary data, censual and sample investigation.

Presentation of statistical data- classification, tabulation, frequency distribution; diagram & graphs.

Unit –II

Statistical average –importance and requisites of agood statistics average, type of averages- arithmetic mean, mediam, mode geometric mean and harmonic mean, weighted average relationship amongst different averages,

Dispesin –meaning and significance of dispersion , methods of measuring dispersion- meaning and significance of dispersion – range, auartile, mean deviation, standard deviation, co-efficient of skewness, Lorenz curve.

Unit-III

Correlation and Regression (simple)

Index number ( Fisher’s Ideal Index number, Dorbish and Bowles Method, pasche method, lasprey’s method.)

Unit-IV

Mathematics of finance – Simple and compound interest, annuity sinking fund, present value of an annuity/ amortization, present value concept in capital expenditure, leasing and bonds.

Quantitative Techniques- an Introduction : Classification of Quantitativee; apllicatins of Quantitative techniques to business and industry; limitations of quantative techniques.

(B) COMPUTER GROUP

PAPER-III : MIS AND SYSTEM ANALYSIS

UNIT-I

System concept, definition, system , approach, characteristics, system elements- i/p, o/p, environment, boundry interface, feedback, control. Types of systems, Buisness as system. Data vs information, information and decision making, value of information, quality of information, introduction to MIS, definition, need, objectives, benefits, functions, characteristics, structure of MIS, information requirements at various level s of management activities. MIS vs data processing. Type of MIS: TPS, OAS, DSS, EXERT SYSTEM (Organization, Features & Advantages)

Functional MIS for marketing, finance, human resource, prodcton & service industry.

UNIT-II

System development life cycle(SDLC) concept & stages. Need identification, determining user’s information requirement s, information gathering –sources & methods( interviews, questionares, observation, document analysis). System analysis, planning, approach elements, objectives, constraints, feasibility study, tools of data recording, DFd’s data dictionary, decision tree, decision table, cost benefit analysis.

Unit-III

Output input design, form design, process design, process specification,file design, program design, module integration, storage requirement, selection of hardware and software, Software controls, system flow chart, user view of processing, modeling input, output data, procedure design, design documentation, user feedback, project planning & control.

UNIT-IV

Testing and Implementation

Testing : Code tesing, specification testing, types of tests, verification and validation systems security and privacy, control measures, disaster recovery plane, system audit, documentation:, user’s System, operation manual, Role and qualities of System analyst as a change agent . Implementation- methods of change over, transition and conversion, change management, user training, post implementation, maintainance and review.

PAPER-IV: E-COMMERCE  &  WEB DESIGNING

UNIT- I: E – commerce

Introduction, Definition, benefits of E-comerce, ilmpact of e-commerce on business models, traditional Commerce o business models, traditional commerce Vs E-commerce, Advantages and dis dvantages of e-commerce, electronic Commerce and trade cycle.

Electronic Market : Usage, Advantages and disadvantages and its future.

Electronic data Interchange (EDI): Introduction, benefits, trade cycle and example.

Internet commerce: Introduction, internat trade Cycle and example. Internet Security: Secure itransaction , prvacy issues, computer crimes and it’s type. Security Issues:security threats like damage to data, loss of data and unauthorized use of data.Security procedure: firewall, encryption , password, acess control list, digital certificate.

UNIT-II: Creating static web pages with html

Indroduction, designing web site, advantages and disadvantages of HTML, flow of Web information, role of web browser and web servers, process of ewb publishing.

Creating a simple  stastic web page: About HTML, basic elements:

Atlanta Computer Institute Nagpur conducts Tuition Classes for BCCA First Year (Part 1), BCCA Second Year (Part 2 ) and BCCA Final Year (Part 3) for all universities in India. The Following syllabus is of Nagpur University. Final Year Projects Training is also given to. BCCA Students.to physical and logical tags path Relative and absolute path, comments, special characters, text Formatting tags, (center Adding Links, images, BAckaground and Table : Hyperlinks , creating links to web pages and URL, Crating, links within the same page, various types of URLs that can be used in links, Image tage and eheir related attributes, Inline images, Links to images, Using inline images as hyperlinks, Popular images formats for internet and html.

Tables : Basic tables tags and their related attributes.

UNIT – III

Frame And Embedding Multimedia

Frames, Image map and web font creator : Frames and their creation the tags, Frame linking , Floating or Inline Frames, image Maps and tags, client sides and server side image maps.

Form designs, form controls, Text controls, password fields, radio buttons, checkboxes, reset and submit buttons, checkboxes, reset and submit buttons, form control selection, option processing and textarea.

Embedding Multimedia: Introduction, embedding Multimedia, inserting sount / audio formats, video file formats.

UNIT – IV

Cascading style sheets (CSS) and XML CSS : Defining style sheets, features, adding style to documents, linking to a single sheet, embedding style sheet, using inline style, style sheet properties, font properties, color and backgournd properties, Text properties, box properties.

XML :Introduction, XML and SGML, Design goals of XML, Application of XML : Document application Data application, XML software : Browsers, Editors, Parsers, Processor, XML tags, structure of XML documents, XML documents, Xml elements tags, element markup attribute markup HTML document, adding scripts, Data types in XML, XML  Namespace : Qualified name and Unqualified names, Namespace scope, default name space working with text and font : font, font size font style text alignment text indent, line height, color and Background Properties : Foreground color, Background color, Border color, Background image, working with DTD : Introduction, HTML and DTD, Benefits and of the DTD, Structure e of DTD, Declarations of variable inDTD: element name occurrence indicatior,sconnectors.

PROGRAMMING SKILLS (C PROG)

UNIT – I

PROGRAMMING LOGIC : Problem analysis, process analysis conceptual development of solution. Development tools : Algorithm & Flowchart Translator : Interpreter, computer introduction to C : History of C language, C character set, Data types, constants & Variables, type casting type Modification operations in C input output function in C

UNIT – II

Control Statement: If, If else, while, Do While, For goat switch case, break, continue, exit statement

Array : Array Definition One dimensional array, two dimensional array, searching, sorting, inserting, deletion, process in arrays, addition & multiplication of two dimensional array, storage class : automatic, Register, static External storage class.

UNIT – III

String Handling : String library function, Structure and Union : Introduction to structure and union, Declaration, Initializing structure, accessing structure elements, array of structure. Function : Library functions, user defined functions, function prototype, types of user defined function, function witharrays, function with structure.

UNIT – IV

Pointers : introduction to pointers, Arithmetic operations on pointer variables. Pointer with array. Pointer with structure, function call value and call by reference.

File Processing : introduction stream and files, opening and closing files, file opening modes, text mode, binary mode, more on file handling functions.

PAPER – VI COMPUTERISED ACCOUNTING

TALLY

UNIT – I

Introduction to Accounting, advantages of Accounting Books of accounts, Classification of Accounts, Financial, Statements, Inventory management, Computerized Accounting, Advantages of Computerized accounting, Manuals Computerized accounting Need of computerized accounting, ac counts organization, accounts group, Loans, Liabilities, assets and budget.

UNIT – II

Accounting software, introduction to Tally software, Features of tally, tally screen company information creating new Company, Gateway, Selection of Company Selection of Options, buttons at Gateway, Working with multiple companies, company features, configuration General, numeric symbols, voucher Entry, Invoice order entry, Printing.

UNIT – III

Account info menu, account groups – create new group creation of primary group Normal and advance Information, Ledger Accounts, cost Categories, Cost Centers.  Creation of Budget, types of budget, voucher – Voucher entry, creation of voucher screen, types of voucher, selection of voucher types, post dated voucher, printing of vouchers, cheque printing, advance features of account voucher.

UNIT – IV

Inventory info Features of inventory info Configure – inventory info, balance sheet, audit trial ratio analysis. Display – accounting Report display, inventory report display, and MIS Report display. Printing reports, export of Data Maintenance – Bank reconciliation, House Keeping, Data Maintenance, security – users and password, security controls, Types of security, Creation new security levels and tally audit.

PRACTICALS

TALLY SOFTWARE – All accounting problems Viz Balance sheet, profit & Loss, cash book, Loans, cost accounting, voucher, budget, sales and Purchase, assets & liabilities, inventory management, financial statements, books of accounts, ledger, etc.

BCCA Part 3 Business Laws

Paper 1

BUSINESS LAWS

UNIT – INDIAN CONTRACT ATC 1872 – Offer, acceptance, Essentials of valid contract. Company Laws- formation of company, memorandum of association, articles of association, Prospectus, shares, debentures & other sources of finance, company meeting. Partnership act salient features, types of partners, duties and liabilities of partnership, dissolution of partnership.

UNIT – CYBER LAW – introduction, defining cyber law Legal Identity Bedizen Private International Law in Cyber Space. It Law – History of Information technology act 2000 About IT Law, History of Information Technology Act 2000, About It Law, IT Act and E-mails, Business Classification of Internet Business o deals, E-Business Classification of Internet Business models, E-business models, E-commerce and security, Online payment facilities.

UNIT – III : Electronic contract – E Agreement and Web Surfing, Terms of Service Contracts, General Precaution, Cyber Contracts. Privacy Policy Protecting Privacy Policy for an E-Commerce site, Privacy Law and Problems, Personal Data Protection mark, Issue of Piracy.

UNIT – IV : Copyright & Trademark Law in Cyber Space – Digital Content Rights, Copyright Infringements, Steps to protect the content on WWW, software patents, Domain Name System and Trademarks, Emergence of cyberspace Trademark law, Issue of Copyright Patent and Trade Mark in IT Act 2000. Age of Cyber Crime the Interface, Establishing the nature of offence, strategy to combat Cyber crime

BCCA Part 3 Auditing and Income Tax

Paper 2

AUDITING & INCOME TAX

UNIT – I :

Auditing: nature of auditing, meaning & definition, objective, advantages, scope, and limitations. Types of Auditing – Continuous Audit Annual, Periodical, Audit, Internal audit – definition objectives advantages basic principle of internal audit, internal audit and auditor(check).

Audit planning & documentation : commencement of new audit, Preparation for audit program, objectives, types of audit program, advantages & disadvantages of audit program, principles of auditing & audit Techniques, Routine checking and vouching Test checking vouching, need for vouching, procedure of vouching, vouching of cash Book, vouching of subsidiary Book, vouching of ledgers.

UNIT – II

Feature of company Audit :

Appointment of auditors, remuneration, removal, rights and duties of company auditors, audit committee, audit of items of financial statements.

Audit Report & certificate : Distinction between reports and certificates contest of audit report, qualifications of auditors, audit reports of companies, special audit of Banking & insurance companies, nature and significance of cost audit, tax audit and management audit.

UNIT - III

Definition, concept of income

Residential states (theory)

Distinction between capital and Revenue receipts.

Deduction under chapter VI – A U/S 80 C, 80 CCC, 80 CCD, 80 D 80 DD 80 DDB, 80E, 80G, 80GG 80U.

Income from salaries, computation of taxable income from salary.

UNIT – IV

Income Exempt from tax

Income from House property

Income from other sources

Pan and tax (Meaning)

BCCA Part 3 Software Product and Project Management

SOFTWARE PRODUCT AND PROJECT MANAGEMENT

PROJECT MANAGEMENT

The Management Sp0ectrum, The people, the Product, the Process, The project.

Project Manager – Role & Responsibilities

Project Estimation – Introduction, Decomposition Techniques – Software sizing, Problem Based E estimation LOC, Based, FP Based estimation

Project Scheduling – Basic Concepts, project scheduling, Basic principles, the relationship between people & effort, Effort Distribution, Defining a Task network – CPM / pert, Gantt Chart.

UNIT – II

SOFTWARE TESTING STRATEGIES

A strategic approach to software testing – Verification & Validation, Organizing for software testing.

Test strategies for conventional software – unit Testing, Integration testing.

Test strategies for object-oriented software – Unit testing, integration testing.

Validation testing – test criteria, configuration review, alpha & beta testing.

System testing – recovery security, stress & performance testing.

The art of Debugging – the debugging process, psychological consideration, debugging strategies, correcting the errors.

UNIT – III

RISK MANAGEMENT

Introduction

Software Risk

Risk identification – assessing overall risk, risk components & drivers

Risk projection – developing a risk table, assessing risk impact

Risk Refinement.

Risk Mitigation, Monitoring and Management

The RMMM Plan

UNIT – IV

QUALITY MANAGEMENT

Quality concepts – Quality, quality control, quality assurance, cost of quality.

Software quality assurance = Background issues, SQA activities.

Formal Technical Reviews –The Review Meeting, review reporting & record keeping, review guideline

Statistical software quality assurance – a generic example, six sigma for software engineering.

Software reliability – measure of software reliability & ISO 900 quality standard

BCCA Part 3 Front End Development

PAPER – 4 FRONT END DEVELOPMENT

Introduction to Visual Basic, Event driven programming, Programming constructs variables, types of variables, Data types scope of variables, constants, system defined functions, operators (precedence and associatively), Creating User interface VB controls (label, text book, Command button, frame check box, option button, list box, combo box, timer, drive list box, directory list box file list box, horizontal and vertical scrollbars, image picture box, shape, line data OLE container), Microsoft windows common controls (tab, strip, tool bar, status bar, progress bar, tree view, list view image list, slider, date picker, month view), adding controls to a form, adding controls at run time.

UNIT – II

Working with procedure, Function and Modules (form, class, standard modules)

Scope of procedures, calling procedures, calling functions, passing arguments.

Control structures : If then, If then-else, select case, loops structure : do-while, while-wend, for – next, for-each, with-end with.

Arrays: Declaring an array types of array (fixed arrays, single-dimensional arrays, Multidimensional arrays, Dynamic arrays), control arrays.

Menus: Creating menus, adding Menu Items, adding code for the menus, modifying menu  at run time, creating pop-up menus.

UNIT – III DATABASE PROGRAMMING IN VISUAL BASIC

Use of data control, creating database using visual data manager validating data bound controls.

Comparative study of Data assess Techniques: DAO, RDO, ADO, ODBC, Data access object:

DAO architecture, database connectively through data access object. Type of records, setting properties and record editing & updating, searching records.

UNIT – IV Active X data object

ADO architecture, setting data source through active X data objects, use of ADO control connecting ADODC to bound controls. Use of different data bound controls. Use of different data bound controls, Editing, Updating & searching through ADO.

Data Reports, Data Environment designer adding connection & commands data reports controls creating & printing reports.

Error handling : types of errors, Debugging, tools for debugging, break mode, break points, watch window, immediate window. Handling runtime errors.

BCCA Part 3 DBMS and Oracle

PAPER – 5 DBMS AND ORACLE

Unit – I database environment data processing, Traditional and DBMS environment, Database system types of database centralize, distributed, Database management system, components of DBMS, DBMS elements, Database approach – objectives, benefits, characteristics, advantages of DBMS, The three tire architecture, three level architecture, database administration – Roses, functions and responsibilities of DBA.

UNIT – II The E-R model – Data models, entities, attributes and relationship, Logical and physical database development life cycle. Integrity constrains. Transforming ERR diagram into relations, tree structure and hierarchical. Normalization cods 12 rules, hierarchical database structure, network database structure, Relational database structure, RDBMS.

UNIT – III Introduction to ORACLE as RDBMS, History & standardization of SQL elements of SQL : Database objects, reserved words, keywords, variables, Data types, operators.

Types of SQL : DDL, DML, DCL, create table, alter table, create view drop table, grant revoke, commit, delete, insert, lock table, rollback save point, update, select statement where clauses. Functions: Arithmetic & characters comparison, logical set like function, Group function, Data Functions.

UNIT – IV : PL/SQL : Introduction to PL/SQL, Variables, Initialization of variables, Dynamic data types, control loop statements, PL/SQL Cursor : Declare cursor, Fetch, Open cursor, Close cursor, Triggers : Concepts, trigger definition, trigger type, enabling, disabling & dropping triggers.

BCCA Part 3 Project

PAPER – 6 PROJECT

The project work constitutes a major component in most of the professional programmers and it is to be carried out with de care and executed with due care and executed with seriousness by the students.

Type of project :

As majorities of the students are expected to work out a project in some industry/research and development laboratories/educational institutions/software export companies, it is suggested that the project is to be chosen which should have some direct relevance in day today activities of the candidates in his/her institution. Students are encouraged to work in the area listed at the end. The list of applications area in which project must be – financial/marketing database management system/ Relational dataset management system/e-commerce/internet manufacturing/web designing etc.

Group project may be allowed (Not more than three students in a group)

Project Proposal (synopsis):

The project proposal should be prepared in consultation with the guide. The project guide must be a person having minimum qualification MCM. M.Sc. (computers)/ M.Sc. (Maths /Electronics /statistics /physics + post B.Sc. Dip. In comp Sc. & Appl )/ MCA with minimum 2 years Experience. The project proposal should clearly state the objectives and environment of the proposed project to be undertaken. It should have full details in the following form.

1.Title of the project

2. Objectives of the Project

3. Project Category (DBMs/ RDBMS / OOPS Web Designing / Internet etc).

4. Tools / Platform Languages to be used

5. A complete Structure of the program :

Analysis

1. Numbers of Modules

2. Data Structure or tables

3. Processes Logic

4. Types of Report Generation

6. Scope of future Application

Project Report Formulation :

1. Title Page

2. Certification Page

3. Declaration Page

4. Acknowledgment Page

5. Index or content page

6. Documentation.

1.  Introduction/Objective
2.  Preliminary system Analysis.

• Identification of need
• Preliminary investigation
• Feasibility study
• Need of new system
• Flaws in present system

3.  Project category
4.  Software Requirement specification
5.  Detailed system analysis

• Data flow diagram
• Numbers of modules and Process Logic
• Data Structure and Tables
• System chart or structure Chart Entity-Relationship Diagram

6.  System design

• Source code
• Input screen & output screen

7.  Validation checks
8.  Implementation, Evaluation and Maintenance.
9.  Security Measures taken
10. Reports
11. Future scope of the project
12. Bibliography.