Bangalore University Study Materials

Bangalore North University Bcom 2nd Sem Previous Year Question papers and Study Materials

Book Free Classes

Bangalore North University 2nd Sem BCOM Study Materials (New Syllabus)

Download free BCOM 2nd sem module wise notes, latest solved question papers, previous 5 years question paper till 2021, model question papers, easy notes, exam-oriented notes are available on this website of Bangalore North University

Bangalore North University BCOM syllabus 2021

New Syllabus




The objective of this course is to help the students acquire knowledge, skills and acumen of  accounting treatment in respect of different categories of business undertakings and special type of  business activities 

UNIT 1: BRANCH ACCOUNTS 14 HOURS Meaning of Head Office, Branch, Branch Accounts and Branch Accounting-Objectives and  Advantages of Branch Accounting Types of Branches – Meaning and features of Dependent Branches, Independent Branches and Foreign Branches-Methods of maintaining books of  accounts by the Head Office – Meaning and Features of Debtors System, Stock & Debtors  System, Wholesale Branch System and Final Account System-Methods of ascertainment of  Profit or Loss of Branch under Debtors System – Cost Price Method and Invoice Price  Method. Problems on preparation of Branch A/c in the books of Head Office under Cost  Price Method and Invoice Price Method 

UNIT 2: CONSIGNMENT ACCOUNTS 10 HOURS Meaning, Definitions and Features of Consignment-Parties in Consignment – Consignor  and Consignee-Differences between Consignment and Ordinary Sale-Special terminologies  in Consignment Accounts – Proforma Invoice, Invoice Price, Account Sales, Non-recurring  Expenses, Recurring Expenses, Ordinary Commission, Overriding Commission, Del  Credere Commission, Normal Loss, Abnormal Loss. Small Problems on Commission and  Valuation of Closing Stock-Consignment Accounts in the books of Consignor – Problems  on preparation of Consignment A/c, Consignee A/c and Goods Sent on Consignment A/c in  the books of Consignor. 

UNIT 3: JOINT VENTURE ACCOUNTS 08 HOURS Meaning, Definitions and Features of Joint Venture-Differences between Joint Venture and  Partnership-Accounting for Joint Ventures – Preparation of Joint Venture A/c, Joint Bank  A/c and Co-Venturer’s A/c 

UNIT 4: ROYALTY ACCOUNTS 12 HOURS Meaning and Definition of Royalty-Special terminologies in Royalty Accounts – Landlord, Tenant, Output, Minimum Rent/Dead Rent, Short Workings, Recoupment of  Short Workings. Methods of Recoupment of Short Workings – Fixed Method and  Floating Method-Problems on Ascertainment of Royalty Payable - Preparation of  Analytical Table including adjustment for Strike Period. 

UNIT 5: HIRE PURCHASE ACCOUNTS 12 HOURS Meaning and Definition of Hire Purchase System-Meaning and Definition of Instalment  Purchase System-Differences between Hire Purchase and Instalment Purchase System Special terminologies in Hire Purchase Accounts – Hire Vendor, Hire Purchaser, Cash  Price, Down Payment, Hire Purchase Price, Principal Component, Interest Component-


Need for segregation of Instalment Amount into Principal Component and Interest  Component-Problems on accrual method only-segregation of Instalment Amount into  Principal Component and Interest Component when (i) Interest component is not  included in the instalment amount (ii) Interest component is included in the instalment  amount (iii) Rate of interest is not given and (iv) Cash price is not given.  


  1. Draft a chart showing types of branches 

  2. Develop branch accounts E-contents for a firm 

  3. Develop E-content for a Consignment Agreement 

  4. Develop E-content for a Joint Venture Agreement 

  5. Develop E-content for Royalty Agreement 


  1. Dr. S.N. Maheswari: Financial Accounting, Vikas Publications New Delhi 2. S P Jain and K. L. Narang: Financial Accounting- I, Kalyani Publishers  3. Radhaswamy and R.L. Gupta: Advanced Accounting , Sultan Chand  

  2. Dr.Janardhanan: Financial Accounting, Kalyani Publishers 

  3. Jawaharlal & Seema Srivastava :Financial Accounting, HPH  

  4. Anil Kumar, Rajesh Kumar and Mariyappa, “Financial Accounting”, HPH 7. Srinivas putty Advanced financial Accounting-HPH 

  5. Saha et., al., Advanced Financial Accounting-VBH




The objective of this course is to enable students to acquire basic knowledge about the concept of  marketing management, consumer behaviour, market segmentation strategy and event management. 

UNIT 1: MARKETING MANAGEMENT AND ENVIRONMENT 12 HOURS Marketing Management: Meaning, Definitions and Features of Market, Marketer,  Marketing Concepts –Selling Concept, Marketing Concept and Societal Marketing Concept,  Marketing versus Selling, E-marketing and digital marketing meaning only, Marketing  Environment –Micro Environment –Suppliers, Competitors, Intermediaries, Customers and  Public Macro Environment – Demographic, Economic, Natural, Technological, Political  and Cultural Factors,  

UNIT 2: MARKETING MIX AND MARKET SEGMENTATION 10 HOURS Marketing mix-Meaning, components-4ps for goods marketing and 7ps for services  marketing, distinction between goods marketing and service marketing. MIS and marketing  research and marketing intelligence (meaning only), Market segmentation- Definition of  Market Segment -Objectives, Advantages, Limitations and Bases of Market Segmentation 

UNIT 3: CONSUMER BEHAVIOUR 10 HOURS Meaning, Definitions, Features and Importance of Consumer Behaviour- Customer versus  Consumer, Buyer versus User, Buyer versus Decision Maker, Factors influencing Consumer  Behaviour – Cultural, Social, Personal and Psychological Factors, Consumers Buying Roles  – Initiator, Influencer, Decider, Buyer and User, Buying Behaviour – Complex Buying  Behaviour, Dissonance Reducing Buying Behaviour, Habitual Buying Behaviour, Variety  Seeking Buying Behaviour, Steps in Buying Process – Need Recognition, Information  Search, Evaluation of Alternatives, Purchase Decision and Post Purchase Behaviour 

UNIT 4: EVENT MANAGEMENT 08 HOURS Event – Meaning, Definition, Characteristics, Types, Advantages and 5 C’s of events, Type  of Customers for Events-Event management – Meaning, Definitions, Essentials, Key  Drivers, Stages and Decision Makers in Event Management-Event Management Staff – Establishing Policies and Procedures of an Event, Role of Event Manager and the people  involved in conducting the event, Developing Record Keeping System in Event  Management 

UNIT 5: CONDUCT OF AN EVENT & PROCEDURE 12 HOURS Planning Schedule, Steps to Organize an Event, Assignment of Responsibilities Communication in Events – Multichannel used for communication, Operational  Communication Tools for Events, Event Marketing and Communications Planning Process Budget of an Event – Basic Event Budgeting Rules, Typical Event Expenditure, Reasons for 


Budget of an Event, Fundamentals of Creating an Event Budget, Predicting the Financial  Outcome of an Event, Importance of Financial Control of an Event, Continual adjustment of  the Event Budget-Computer Aided Event Management – Use of Computer and Technology  from the start to End of Event, Event Planning Software, Roles and responsibilities of Event  manager for different Events-Checklist of an Event, Emergency plan checklist for an Event,  Sample event planning checklist-Event Proposal-Events Licenses and Permissions, permits  and license for events, Government Environment for Event. 


  1. Develop E-content for Marketing Mix components 

  2. Draft a chart of Marketing Environment 

  3. Make a diagrammatic presentation of buying process 

  4. Show different bases of market segmentation 

  5. Show steps for organizing an event 

  6. List out (together with relevant photographs) any 5 events that you have participated. . 



  1. S A Sherlekar & Sherlekar marketing management HPH

  2. Nair, S. R. Consumer Behaviour and Marketing Research: Text and Cases. Global Media 3. K Ramachandra and et.,al. Marketing Management t HPH

  3. Mark Sonderm CSEP -Event entertainment and production:publishers; wiley and sons, Inc 5. Annestephen; Event management, HPH. 

  4. K. Venkatramana -Event Management - SHBP. 

  5. K Ramachandra and Allabaksh Principles of Event Management HPH

  6. Rekha and Vibha Marketing management -VBH

  7. Nihaasif Event management-VBH



OBJECTIVE: The objective of this course is to enable the students to gain knowledge and skills of  managing human resources in various organisations.  

UNIT 1: HUMAN RESOURCE MANAGEMENT 12 HOURS Human Resources Management – Meaning, Definitions, Characteristics, Objectives,  Importance, Functions and Process, Challenges, Recent Trends -Human Resources Manager  – Duties and Responsibilities, Paradigms for Post Modern Managers-Meaning, Definitions,  Characteristics, Objectives, Importance, Functions and Process of Human Resources  Development-Differences between personnel Management and Human Resources  Development, difference HRM and SHRM, difference between HRM and IHRM 

UNIT 2: HUMAN RESOURCE PLANNING, RECRUITMENT & SELECTION 12 Hrs Human Resource Planning – Meaning, Importance, Benefits and Scope-Job Analysis, Job  Design, Job Description, Job enrichment and Job Evaluation. Recruitment – Meaning,  Definitions and Sources of Recruitment: Traditional and Modern sources of recruitment-E recruitment, Twitter, Blog, Instagram, Linkedin Walk in, talk in, Write in, Artificial  intelligence (Robots based) virtual discussion, Selection – Meaning, Definitions and Process  of Selection- identification of five dark qualities in an individual before selection process of  selection and Placement  

UNIT 3: HUMAN RESOURCE PRACTICES 12 HOURS  Induction and Orientation – Meaning, Definitions, Objectives and Purposes-Training – Meaning, Need, Benefits and Methods, Pros and Cons of each Method of Training Identification of Training & Development Needs-Human Resources Development of  Managers and Employees-Performance Management System (PMS) – Meaning,  Definitions, Objectives, Methods of Appraising the past performance and current  performance of the employee and executive, projecting future performance of an employee,  individual employee development difference and performance appraisal and performance  management system (PA vs PMS) 

UNIT 4: COMPENSATION AND REWARD SYSTEM 10 HOURS Compensation - Meaning, Definitions, Objectives and Importance-Wages and Salary  Perquisites, Fringe Benefits, Bonus and Incentives – Meanings only, incentives in sun rise  sector and sun set sector. Performance based pay, merit based pay, skill based pay, and  competency based pay, dual system of payment for the same job position. Promotion – Meaning, Definitions, Features, Methods of Promotion –seniority vs meritocracy 

UNIT 5: EMPLOYEE COACHING, COUNSELLING AND INDUSTRIAL RELATIONS 06 Hrs Employee Coaching - Meaning, Definitions, Objectives, Types. Employee Counselling Meaning Definitions, Objectives, Skills and Techniques Industrial. Relation-meaning,  definition and Actors in IRs



  1. Develop the offer letter and appointment order to given to new recruit 2. Develop E- contents for 5 dark qualities of an individual 3. List out the examples for sunrise sector and sun set sectors 4. Develop E-content for the role of artificial intelligence in HR functions 5. Develop the E-Content for employee performance management System 


  1. Dr. K Aswathappa -Human resource Management Tata Mcgraw Hills 2. Shashi K Gupta and Rosy Joshi Human Resource Management  3. Managing Human Resources by Wayne F Cascio 

  2. Subba Rao Human resource management-HPH 

  3. K Ramachandra and et.,al. Human Resource Management HPH 6. Rekha and Vibha Human Resource management VB




The objective of this course is to enable students to acquire basic knowledge of analysis and  interpretation of data for use in the decision making process in a business entity.  

UNIT 1: INTRODUCTION TO STATISTICS 08 HOURS  Introduction, Meaning, Definitions, Features, Objectives, Functions, Importance and  Limitations of Statistics -Important terminologies in Statistics – Data, Raw Data, Primary  Data, Secondary Data, Population, Census, Survey, Sample Survey, Sampling, Parameter,  Unit, Variable, Attribute, Frequency, Seriation,.- Individual, discrete and continuous.  Classification of Data.-Requisites of Good Classification of Data.-Types of Classification – Quantitative and Qualitative Classification (simple illustrations) 

UNIT 2: TABULATION AND PRESENTATION OF DATA 12 HOURS Types of Presentation of Data – Textual Presentation, Tabular Presentation, One-way Table,  Two-way Table,.-Important terminologies – Variable, Quantitative Variable, Qualitative  Variable, Discrete Variable, Continuous Variable, Dependent Variable, Independent  Variable, Frequency, Class Interval, Tally Bar. Diagrammatic and Graphical Presentation,  Rules for Construction of Diagrams and Graphs. Types of Diagrams – One Dimensional  Simple Bar Diagram, Sub-divided Bar Diagram, Multiple Bar Diagram, Percentage Bar  Diagram – Two Dimensional Diagram – Pie Chart, Graphs – Histogram, Frequency  Polygon, Ogives, curve– simple Problems on tabulation, diagrams and Histogram Only 

UNIT-3: MEASURES OF CENTRAL TENDENCY 12 HOURS  Meaning and Objectives of Measures of Tendency-Requisites of an Ideal Average, -Types  of Averages -Arithmetic Mean, Median and Mode- Problems on Calculation of Arithmetic  Mean, Median and Mode direct method only (including problems involving empirical  relationship between Mean, Median and Mode) 

UNIT 4: MEASURES OF DISPERSION & SKEWNESS 12 HOURS  Meaning and Objectives of Measures of Dispersion-Requisites of Good Measure of  Dispersion-Types of Measures of Dispersion –Range, Quartile Deviation, Mean Deviation,  Standard Deviation- and their Co-efficient problems on direct method only. Measures of  Skewness – Meaning, Absolute and Relative Measures – Karl Pearson’s Coefficient of  Skewness and Bowley’s Coefficient of Skewness – Problems 

UNIT 5: CORRELATION, REGRESSION & TIME SERIES ANALYSIS 12 HOURS  Meaning and Types of Correlation -Karl Pearson's Coefficient of Correlation, Spearman's  Rank Correlation Coefficient, -Correlation Coefficient through Regression Coefficient 


Meaning of Regression, Regression Lines, Regression Coefficients, Regression Equations – Problems-Meaning and Components of Time Series, Analysis of time series by Moving  Averages and Least Squares Method  


  1. Collect data from at least 5 friends about their monthly expenditure on Mobile Recharge,  Cosmetics, Chats and Other Expenses and present the same in a Tabular Form 2. Collect data from at least 5 friends about the percentage of marks obtained in SSLC and  PUC and present the same in a Bar Diagram Form 

  2. Collect data from at least 10 friends about the pocket money they receive in a month and  present the same in the form of a frequency distribution with class interval of Rs. 25, 50 etc 4. Collect data about marks scored in English subject in PUC from at least 30 students of your  class and calculate Arithmetic Mean 

  3. Collect the data about the age of at least 10 married couples and compute correlation  coefficient  


  1. Gupta, S. P. Statistical Methods. New Delhi: Sultan Chand 

  2. Vohra, N.D. Quantitative Techniques in Management. Tata McGraw Hill Publishing  3. Bhat B R, Srivenkataramana and K S MadhavaRao, Statistics for Beginners - New Age (P) 4. Beri, G. C.. Business Statistics . New Delhi: Tata McGraw Hill Educations Pvt Ltd.  5. Bowerman, Bruce, O'Connell, Richard, Murphree, Emilly Business Statistics in Practice by  McGraw-Hill Education  

  3. Chikodi & Pradad – Quantitative Method for Business - II  

  4. Sharma, J. K. Business Statistics . New Delhi: Pearson Publishers.  

  5. K Ramachandra and et.,al. Quantitative methods for Business HPH

9. Gurumurthy K H and et.,al. Quantitative analysis for Business decisions VBH

Bangalore North University 2nd Sem BCOM Study Materials (Old Syllabus)

Old Syllabus




The objective of this subject is to acquaint the students with the few accounting standards and make  them familiar with the accounting procedures for different types of business. 

Unit 1: INSURANCE CLAIMS 12 Hrs Introduction – Need – Loss of Stock Policy – Steps for ascertaining Fire insurance claim – Treatment  of Salvage – Average Clause – Treatment of Abnormal Items – Computation of Fire insurance claims.  

Unit 2: CONSIGNMENT ACCOUNTS 12 Hrs Introduction – Meaning – Consignor – Consignee – Goods Invoiced at Cost Price – Goods Invoiced at  Selling Price – Normal Loss – Abnormal Loss – Valuation of Stock – Stock Reserve – Journal Entries  – Ledger Accounts in the books of Consignor and Consignee.  

Unit 3: ACCOUNTING FOR JOINT VENTURES 12 Hrs Introduction – Meaning – Objectives – Distinction between joint venture and consignment – Distinction between joint venture and partnership – maintenance of accounts in the books of co venturers – maintaining separate books for joint venture – preparation of memorandum joint venture - problems. 

Unit 4: BRANCH ACCOUNTS 10 Hrs Introduction – Meaning – Objectives – Types of Branches - Dependent Branches – Features – Supply  of Goods at Cost Price - Invoice Price – Branch Account in the books of Head Office (Debtors  System Only).  

Unit 5 : DEPARTMENTAL ACCOUNTS 10 Hrs Meaning, Objectives, basis of allocation of expenses, Trading and Profit and Loss Account in  Columnar form – (Excluding Inter Departmental Transfers at invoice price)  


Preparation of a claim statement with imaginary figures to submit to Insurance Company. Collection of transactions relating to any branch and prepare a branch account. List out the basis of Allocation of Departmental Expenses. 

Preparation of Consignment account with imaginary figures 

Preparation of Joint accounts with imaginary figures 


  1. Arulanandam & Raman; Advanced Accountancy, HPH 

  2. Anil Kumar – Advanced Financial Accounting HPH 

  3. Dr. Alice Mani: Advanced Financial Accenting, SBH. 

  4. Dr. S.N. Maheswari, Financial Accounting, Vikas Publication  

  5. S P Jain and K. L. Narang, Financial Accounting, Kalyani Publication 

  6. Souandrajan & K. Venkataramana, Financial Accounting, SHBP. 

  7. A Bannerjee; Financial Accounting.  

  8. Radhaswamy and R.L. Gupta, Advanced Accounting , Sultan Chand 

  9. M.C. Shukla and Grewel, Advaced Accounting , S Chand




The objective is to enable students to acquire skills in Retail Management. 

Unit 1: INTRODUCTION TO RETAIL BUSINESS 10 Hrs. Definition – functions of retailing - types of retailing – forms of retail business ownership. Retail  theories – Wheel of Retailing – Retail life cycle. Retail business in India: Influencing factors – present  Indian retail scenario. International perspective in retail business.  

Unit 2: CONSUMER BEHAVIOUR IN RETAIL BUSINESS 12 Hrs. Buying decision process and its implication on retailing – Influence of group and individual factors,  Customer shopping behaviour, Customer service and customer satisfaction. Retail planning process: Factors to consider in preparing a business plan – implementation – risk analysis. 

Unit 3: RETAIL OPERATIONS 10 Hrs. Factors influencing location of Store - Market area analysis – Trade area analysis – Rating Plan  method - Site evaluation. Retail Operations: Stores Layout and visual merchandising, Stores designing, Space planning, Inventory management, Merchandise Management, Category  Management. 

Unit 4: RETAIL MARKETING MIX 16 Hrs. Introduction -Product : Decisions related to selection of goods (Merchandise Management revisited) – Decisions related to delivery of service. Pricing : Influencing factors – approaches to pricing – price  sensitivity - Value pricing – Markdown pricing. Place : Supply channel – SCM principles – Retail  logistics – computerized replenishment system – corporate replenishment policies. Promotion : Setting objectives – communication effects - promotional mix. Human Resource Management in  Retailing – Manpower planning – recruitment and training – compensation – performance appraisal Methods. 

Unit 5: IMPACT OF INFORMATION TECHNOLOGYIN RETAILING 08 Hrs. Non store retailing (e-retailing) - The impact of Information Technology in retailing - Integrated  systems and networking – EDI – Bar coding – Electronic article surveillance – Electronic shelf labels  – customer database management system. Legal aspects in retailing, Social issues in retailing, Ethical  issues in retailing. 


Draw a retail life cycle chart and list the stages 

Draw a chart showing a store operations 

List out the major functions of a store manager diagrammatically 

List out the current trends in e-retailing 

List out the Factors Influencing in the location of a New Retail outlet. 


  1. Suja Nair; Retail Management, HPH 

  2. Karthic – Retail Management, HPH 

  3. S.K. Poddar& others – Retail Management, VBH. 

  4. R.S Tiwari ; Retail Management, HPH 


  1. Barry Bermans and Joel Evans: "Retail Management – A Strategic Approach", 8th edition, PHI/02 

  2. A.J.Lamba, "The Art of Retailing", 1st edition, Tata Mc GrawHill, New Delhi, 2003. 7. Swapna Pradhan : Retailing Management, 2/e, 2007 & 2008, TMH 

  3. K. Venkataramana, Retail Management, SHBP. 

  4. James R. Ogden & Denise T.: Integrated Retail Management  

  5. A Sivakumar : Retail Marketing , Excel Books 

  6. Ogden : Biztantra, 2007 

  7. Levy & Weitz : Retail Management -TMH 5th Edition 2002 

  8. Rosemary Varley, Mohammed Rafiq-: Retail Management 

  9. Chetan Bajaj : Retail Management -Oxford Publication. 

  10. Uniyal &Sinha : Retail Management - Oxford Publications. 

  11. Araif Sakh ; Retail Management




The objective is to familiarize the students with the law and operations of Banking. 

Unit 1: NEGOTIABLE INSTRUMENTS 10 Hrs Introduction – Meaning & Definition – Features – Kinds of Negotiable Instruments: Meaning,  Definition & Features of Promissory Notes, Bills of Exchange, Cheques - Crossing of Cheques – Types of Crossing – Endorsements: Meaning, Essentials & Kinds of Endorsement. 

Unit 2: BANKER AND CUSTOMER RELATIONSHIP 10 Hrs Introduction – Meaning of Banker – Bank - Meaning of Customer – General & Special Relationships. 

Unit 3: BANKING OPERATIONS 18 Hrs Collecting Banker: Meaning – Duties & Responsibilities of Collecting Banker – Holder for Value – Holder in Due Course - Statutory Protection to Collecting Banker 

Paying Banker: Meaning – Precautions – Statutory Protection to the Paying Banker – Dishonor of  Cheques – Grounds of Dishonor – Consequences of wrongful dishonor of Cheques. 

Lending Operations: Principles of Bank Lending – Kinds of lending facilities such as Loans, Cash  Credit, Overdraft, Bills Discounting, Letters of Credit – NPA: Meaning, circumstances & impact – regulations of priority lending for commercial banks.  

Unit 4: CUSTOMERS AND ACCOUNT HOLDERS 12Hrs Types of Customers and Account Holders - Procedure and Practice in opening and operating accounts  of different customers including Minors - Meaning & Operations of Joint Account Holders,  Partnership Firms, Joint Stock companies, Executors and Trustees, Clubs and Associations and Joint  Hindu Undivided Family.  

Unit 5: BANKING INNOVATIONS 06 Hrs New technology in Banking – E-services – Debit and Credit cards. Internet Banking, ATM,  Electronic Fund Transfer, MICR, RTGS, NEFT, DEMAT. 


Collect and fill account opening form of SB A/c or Current A/c 

Collect and fill pay in slip of SB A/c or Current A/c. 

Draw specimen of Demand Draft. 

Draw different types of endorsement of cheques. 

Draw specimen of Travellers Cheques / Gift cheques / Credit cheques. 

List various customer services offered by atleast 2 banks of your choice. 


  1. Gordon & Natarajan: Banking Theory Law and Practice, HPH 

  2. S. P Srivastava ; Banking Theory & Practice, Anmol Publications 

  3. M. Prakhas, Bhargabhi R: Banking law & Operation, Vision Book House. 

  4. Tannan M.L: Banking Law and Practice in India, Indian Law House  

  5. Sheldon H.P: Practice and Law of Banking. 

  6. K. Venkataramana, Banking Operations, SHBP.  

  7. Kothari N. M: Law and Practice of Banking. 

  8. Neelam C Gulati: Principles of Banking Management. 

  9. Maheshwari. S.N.: Banking Law and Practice, Vikas Publication 

  10. Shekar. K.C: Banking Theory Law and Practice, Vikas Publication. 

  11. S. Vipradas & j. K Syan: Bank Lending 

  12. Gajendra & Poddar : Law and Practice of Banking 

  13. Dr. Alice Mani: Banking Law and Operation, SBH.




The objective is to provide basic knowledge of statistics and their application to business situations. 

Unit 1: INTRODUCTION TO STATISTICS 03Hrs Meaning and Definition – Functions – Scope – Limitations. 

Unit 2: CLASSIFICATION AND TABULATION OF DATA 08 Hrs Collection of data - census and sample techniques. Classification of data, preparation of frequency  distribution and tabulation of data.  

Unit 3: MEASURES OF CENTRAL TENDENCY 20Hrs Meaning and Definition Types of averages – Arithmetic Mean (Simple and Weighted), Median,  Mode (excluding missing frequency problems). Graphical representation of median and mode – Ogive– curve, histogram, smoothed frequency curve and frequency polygon. 

Unit 4: MEASURES OF DISPERSION AND SKEWNESS 15 hrs Meaning & Definition -Range, Quartile Deviation, Mean Deviation Standard Deviation and Co efficient of Variation. Skewness: Meaning, uses, and problems on Karl Pearson’s’ Co-efficient of  skewness. 

Unit 5: INDEX NUMBERS 10 Hrs Meaning & Definition – Uses – Classification – Construction of Index Numbers – Methods of  constructing Index Numbers – Simple Aggregative Method – Simple Average of Price Relative  Method – Weighted index method – Fisher’s Ideal method (including TRT & FRT) – Consumer Price  Index – Problems. 


Draw a blank table showing different attributes  

Collect marks scored 50 students in a examinations and prepare a frequency distributions table Collect data relating to prices of shares of two companies for ten days and ascertain which  companies shares prices is more stable 

Collect the run scored by the two batsmen in ten one day international cricket matches, find who  is better run getter and who more consistence.  

Select 10 items of daily-consumed products and collect base year quantity, base year price and  current year price. Calculate Cost of Living Index. 


  1. Anand Sharma : Statistics For Management, HPH 

  2. S P Gupta: Statistical Methods- Sultan Chand, Delhi 

  3. D.P Apte ; Statistical Tools for Managers.  

  4. Dr. B N Gupta: Statistics (Sahityta Bhavan), Agra. 

  5. S.C Gupta: Business Statistics, HPH 

  6. N.V.R Naidu : Operation Research I.K. International Publishers 

  7. Ellahance : Statistical Methods, Kitab Mehel. 

  8. Sanchethi and Kapoor: Business Mathematics, Sultan Chand 

  9. Veerachamy: Operation Research I.K. International Publishers 

  10. S. Jayashankar: Quantitative Techniques for Management. 

11.Chikoddi & Satya Prasad : Quantitative Analysis for Business Decision, HPH 12. Dr. Alice Mani: Quantitative Analysis for Business Decisions - I, SBH.

Quantitative Analysis for Business Decisions – I bcom 2nd sem chaloexam
Quantitative Analysis for Business Decisions – I

Book Now For Free Classes

Get It Now

Bangalore University Study Materials

Bangalore North University BCA 6th Semester Study Materials and Previous Year Question Paper

Total Teaching Hours : 60 No of Hours / Week : 04
Unit – I
Introduction to Finite Automata: The central concepts of Automata theory; Deterministic
finite automata; Nondeterministic finite automata. An application of finite automata,
Page 33 of 38
Finite automata with Epsilon transitions.
[ 12 Hours ]
Unit – II
Regular Expressions: Finite Automata and Regular Expressions Applications of Regular
Expressions. Regular languages; Proving languages not to be regular languages; Closure
properties of regular languages; Decision properties of regular languages; Equivalence
and minimization of automata.
[ 12 Hours ]
Unit – III
Context–free grammars: Parse trees; Applications; Ambiguity in grammars and
Languages. Definition of the Pushdown automata; the languages of a PDA; Equivalence
of PDA’s and CFG’s.
[ 12 Hours ]
Unit – IV
Deterministic Pushdown Automata:Normal forms for CFGs; The pumping lemma for
CFGs; Closure properties of CFLs. Problems that Computers cannot solve.
[ 12 Hours ]
Unit – V
The Turing machine:Programming techniques for Turing Machines. Undecidability, A
Language that is not recursively enumerable; An Undecidable problem that is RE; Post’s
Correspondence problem.
[ 12 Hours ]
Text Book:
1. John E. Hopcroft, Rajeev Motwani, Jeffrey D.Ullman: Introduction to Automata
Theory, Languages and Computation, 3rd Edition, Pearson Education, 2011.
Reference Books:
1. John C Martin: Introduction to Languages and Automata Theory, 3rd Edition,
Tata McGraw-Hill, 2007.
2. Daniel I.A. Cohen: Introduction to Computer Theory, 2nd Edition, John Wiley &
Sons, 2009.
3. Thomas A. Sudkamp: An Introduction to the Theory of Computer Science,
Languages and Machines, 3rd Edition,Pearson Education, 2006

Bangalore University Study Materials

Bangalore North University BCA 4th Semester Study Materials and Previous Year Question Paper

Bangalore North University 4th Sem BCA Study Materials

Download free BCA 4th sem module wise notes, latest solved question papers, previous 5 years question paper till 2021, model question papers, easy notes, exam oriented notes are available on this website of Bangalore North University

Bangalore North University BCA syllabus





Syllabus as per the one prescribed for science courses of Bangalore University. 


Syllabus as per the one prescribed for science courses of Bangalore University. 


Total Teaching Hours : 60 No of Hours / Week : 04 Unit - I 

Introduction to Visual Programming: The intergrated Development Environment – menu  bar, tool bar, from designer, project explorer , properties window , from layout window ,  The Visual Programing editor. The form object: Properties , events and methods pf  forms ; Properties – Name , Captain , Backcolor, Borderstyle , controlbox , maxbutton ,  minbutton, moveable, startup position , height, width , left, top, scalemode, window, state  ; Events –load ,unload , Clerk, Activate , Deactivate , Resize, methods – Show , hide , cls  , Unload ,print , Controls –Properties and events of different controls such as command  buttons , labels , textboxes image controls , timer, horizontal and vertical scroll bars ,  option buttons , check boxes , frames lists and combo boxes. Predefined Dialog Boxes – MsgBox and InputBO 

 [ 12 Hours ] Unit - II 

Programming: Data types, variables; declaration and scope arithmetic operations, Study  of form and code modules, private and public procedures , Main o procedure , Suba and  Functions. Mathematical and string Functions; Branching and Looping Statement ; If – Then , if –Then –Else and Nested If Statements; Select Case –different forms; For – Next  , While – Wend and Do – Loops statements ; Arrays- declaration . Static and dynamic  arrays. Array and Function, menus and toolbars-Creating menus and toolbars, Working  with the menu editor , Designing Multiple Document interface forms. Microsoft  common controls. 

[ 12 Hours ]

Page 23 of 38 

Unit - III 

OOP methods and properties of an object, class Modules , Encapsultation and Inheritance  characteristics Dynamic Link Libraries (DLLs) and Windows API ; Designing Help files  ; File handling – Sequential ,Random access and Binary files, Database connectivity – DAO and ADO Tables and Queries, ActiveX Data objects. 

 [ 12 Hours ] Unit – IV 

Visual C++ Programming: Objects-Classes-VC++Components – Resources-Event  Handling – Menus – Dialog Boxes – Importing VBX Controls – Files – MFC File  Handling – Document View Architecture – Serialization. 

 [ 12 Hours ] Unit – V 

Interfacing Other Applications – Multiple Document Interface (MDI) – Splitter Windows  – Exception Handling – Debugging – Object Linking and Embedding (OLE) – Database  Application – DLL- ODBC. 

 [ 12 Hours ] Text Books: 

  1. Gurumit Singh, “Visual Basic 6”, First Edition, Firewall Media, 2007. Reference Books: 

1.Charles Petzold, “Windows Programming”, 5th Edition, Microsoft Press, 1999. 2.Steve Holzner, “Visual C++ Programming”, Second Edition, PHI, 1994. 3.Go ttfried, “Programming with Visual Basic 6”, PHI, 2000. 


Total Teaching Hours : 60 No of Hours / Week : 04 Unit - I 

Introduction: History, salient features, Unix system architecture, Unix command format,  Unix internal and external commands, Directory commands, File related commands,  Disk related commands, general utilities. Unix File System: Boot inode, super and data  block, in-core structure, Directories, conversion of pathname to inode, inode to a new  file, Disk block allocation. Process Management: Process state and data structures of a  Process, User vs, kernel node, context of a Process, background processes, Process  scheduling commands, Process terminating and examining commands. 

[ 12 Hours ] 

Unit - II 

Secondary Storage Management: Formatting, making file system, checking disk space,  mountable file system, disk partitioning, file compression. Special Tools and Utilities:  Filters, Stream editor SED and AWK, Unix system calls and library functions, Processes,  signals and Interrupts, storage and compression facilities. 

 [ 12 Hours ] Unix - III 

Shell Programming: Vi editor, shell types, shell command line processing, shell script  features, executing a shell script, system and user-defined variables, expr command, shell  screen interface, read and echo statement, command substitution, escape sequence  characters, shell script arguments, positional parameters, test command, file test, string  test, numeric test. [ 12 Hours ] 

Unit – IV 

Conditional Control Structures-if statement, case statement Looping Control Structure while, until, for, statements. Jumping Control Structures – break, continue, exit. Shell  Programs covering the above concepts. [ 12 Hours ]

Page 24 of 38 

Unit – V  

Unix System Communication: Introduction, write, read, wall commands, sending and  handling mails. System Administration: Roles of a System Administrator, File System  Maintenance, System Startup and Shutdown, User Management, Backup and Restore,  Doemons, Domain Name System DNS, Distributed File System. 

[ 12 Hours ] 

Text Books: 

  1. M.G.Venkateshmurthy, “Introduction to UNIX & SHELL Programming”, First  Edition, Pearson Education, 2004. 

Reference Books: 

  1. Forouzan,“Unix and Shell Programming”, 1st Edition,2008 Cengage Learning  India 

  2. UNIX and Shell Programming, Archana Verma, Firewall Media. 


Total Teaching Hours : 65 No of Hours / Week : 05 Unit - I 

Linear Programming Problems: Origin and development of operations research, Linear  Programming Problem –formulation of Lenear Programming problem, Graphical  solution. Theory of simplex method. Use of artifical variables and their solution. [ 13 Hours ] 

Unit - II 

Transportation Problem: Mathematical formulation of transportation problem, Initial  basic Feasible solution, North West corner rule, Matrix minima method, Vogel’s  approximation method, MODI method to find optimal solution. 

[13 Hours ] 

Unit - III 

Assignment Problem: Mathematical formulation of an Assignment problem, Assignment  algorithm, Hungarian Method to solve Assignment Problem. 

[ 13 Hours ] 

Unit - IV 

Network Analysis: Basic components of Network, Rules for drawing Network diagram  Time calculation in Networks. Critical Path Method and PROJECT Evaluation and  Review Techniques. Algorithm and flow chart for CPM and PERT. 

[ 13 Hours ] 

Unit - V ` Theory of Games: Two –person Zero –sum Games, the maximin and Minimax principle,  Saddle point and value of the Game. Game without saddle points, mixed strategies,  solution for 2X2 games, Graphical method Dominance property. 

 [ 13 Hours ] Text books

  1. Taha, “Operations Research”, 7th edition, Pearson Education, 2007. References Book: 

  2. Billey E. Gillett, “Introduction to Operations Research” , Himalaya   Publishing House, Delhi, 1979. 

  3. Hamady A.Taha “Operations Research” , Collin Mac Millan, 1982.

Book Now For Free Classes

Get It Now

Bangalore University Study Materials

Bangalore North University BCA 2nd Semester Study Materials and Previous Year Question Paper

Bangalore North University 2nd Sem BCA Study Materials

Download free BCA 2nd sem module wise notes, latest solved question papers, previous 5 years question paper till 2021, model question papers, easy notes, exam-oriented notes are available on this website of Bangalore North University

Bangalore North University BCA syllabus





Syllabus as per the one prescribed for science courses of Bangalore University. 


Syllabus as per the one prescribed for science courses of Bangalore University. 


Total Teaching Hours : 60 No of Hours / Week : 04 Unit-I  

Introduction and Overview: Definition, Elementary data organization, Data Structures,  data structures operations, Abstract data types, algorithms complexity, time-space  tradeoff. Preliminaries: Mathematical notations and functions, Algorithmic notations,  control structures, Complexity of algorithms, asymptotic notations for complexity of  algorithms. String Processing: Definition, Storing Stings, String as ADT, String  operations, word/text processing, Pattern Matching algorithms.  

[ 12 Hours ] 


Arrays: Definition, Linear arrays, arrays as ADT, Representation of Linear Arrays in  Memory, Traversing Linear arrays, Inserting and deleting, Sorting: Bubble sort, Insertion  sort, Selection sort, Searching: Linear Search, Binary search, Multidimensional arrays, 

Page 12 of 38 

Matrices and Sparse matrices.  [ 12 Hours ] 


Linked list: Definition, Representation of Singly linked list in memory, Traversing a  Singly linked list, Searching a Singly linked list, Memory allocation, Garbage collection,  Insertion into a singly linked list, Deletion from a singly liked list; Doubly liked list,  Header liked list, Circular linked list.  

[ 12 Hours ] 


Stacks – Definition, Array representation of stacks, Linked representation of stacks,  Stack as ADT, Arithmetic Expressions: Polish Notation, Application of Stacks,  Recursion, Towers of Hanoi, Implementation of recursive procedures by stack. Queues  – Definition, Array representation of queue, Linked list representation of queues Types  of queue: Simple queue, Circular queue, Double ended queue, Priority queue, Operations  on Queues, Applications of queues. 

 [ 12 Hours ] Unit-V 

Graphs: Graph theory terminology, Sequential representation of Graphs: Adjacency  matrix, traversing a Graph. Tree – Definitions, Binary trees, Representing binary trees in  memory, Traversing Binary Trees, Binary Search Trees, Searching, Inserting and  Deleting in a Binary Search Tree. 

 [ 12 Hours ] TEXT BOOKS 

  1. Seymour Lipschutz, “Data Structures with C”, Schaum’s outLines, Tata  McGraw-Hill, 2011. 


  1. Mark Allen Weiss, “Data Structures and Algorithm Analysis in C”, Second  Edition, Pearson Education, 2013. 

  2. Robert Kruse, C.L.Tondo, Bruce Leung, Shashi Mogalla, “Data Structures and  Program Design using C”, Pearson Education, 2009. 

  3. Forouzan, “A Structured Programming Approach using C”, 2nd Edition, Cengage  Learning India, 2008. 


Total Teaching Hours : 60 No of Hours / Week : 04 Unit - I 

Introduction: Database and Database Users, Characteristics of the Database Approach,  Different people behind DBMS, Implications of Database Approach, Advantages of  using DBMS, When not to use a DBMS. Database System Concepts and architecture: Data Models, Schemas, and Instances. DBMS Architecture and Data Independence.,  Database languages and interfaces. The database system Environment, Classification of  DBMS.  

[ 12 Hours ] 

Unit - II 

Data Modelling Using the Entity-Relationship Model: High level conceptual Data  Models for Database Design with and example., Entity types, Entity sets, attributes, and  Keys, ER Model Concepts, Notation for ER Diagrams, Proper naming of Schema  Constructs, Relationship types of degree higher than two. Record Storage and Primary  File Organization: Secondary Storage Devices. Buffering of Blocks. Placing file Records  on Disk. Operations on Files, File of unordered Records (Heap files), Files of Ordered 

Page 13 of 38 

Records (Sorted files), Hashing Techniques, and Other Primary file Organization. [ 12 Hours ] 

Unit - III 

Functional Dependencies and Normalization for Relational Database: Informal Design  Guidelines for Relational schemas, Functional Dependencies, Normal Forms Based on  Primary Keys., General Definitions of Second and Third Normal Forms Based on  Primary Keys., General Definitions of Second and Third Normal Forms, Boyce-Codd  Normal Form. Relational Data Model and Relational Algebra: Relational Model  Concepts., relational Model Constraints and relational Database Schema, defining  Relations, Update Operations on Relations., Basic Relational Algebra Operations,  Additional Relational Operations., Examples of queries in the Relational Algebra.,  Relational Database design Using ER-to-Relational Mapping. 

[ 12 Hours ] 

Unit – IV 

Relational Database Language: Data definition in SQL, Queries in SQL, Insert, Delete  and Update Statements in SQL, Views in SQL, Specifying General Constraints as  Assertions, specifying indexes, Embedded SQL. PL /SQL: Introduction.  [ 12 Hours ] 

Unit - V 

Transaction Processing Concepts: Introduction, Transaction and System Concepts,  Desirable properties of transaction, Schedules and Recoverability, Serializability of  Schedules, Transaction Support in SQL, Locking Techniques for Concurrency Control,  Concurrency Control based on time stamp ordering. 

 [ 12 Hours ] Text book: 

  1. Remez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”,  5th Edition, Pearson Education, 2007. 


  1. Abrahamsi. Silberschatz, Henry. F. Korth, S. Sudarshan, “Database System  Concepts” 6th Edition, McGraw Hill, 2012. 

  2. C.J.Date, “Introduction to database systems”, Eight Edition, Addison Wesley,  2003. 


Total Teaching Hours: 65 No of Hours / Week : 05 Unit - I 

Floating-point representation and errors-Normalized floating-point forms, Errors in  representing numbers, Floating point machine number and machine epsilon, Loss of  significance and its avoidance. Roots of equations-locating roots of f(x)=0 Bisection  method, Newton’s method, Secant method. 

[ 13 Hours ] 

Unit - II 

Interpolation and numerical differentiation-polynomial interpolation, Lagrange and  Newton form of interpolating Polynomial, Divided difference and recursive property,  Inverse interpolation, First and Second derivative formulae via interpolation  Polynomials. Numerical integration-Trapezoidal, Simpson’s and adaptive Simpson rules. 

 [ 13 Hours ] Unit - III 

System of linear equations-Gaussian elimination and back substitution-partial and  complete pivoting, Doolittle, Cholesky and Crout LU decomposition methods, Jacobi and 

Page 14 of 38 

Gauss – Seidel iterative methods. Power (and inverse power) method of obtaining largest  (smallest) eigenvalue and corresponding eigenvector. Ordinary differential equations initial value problem, Picard’s, Taylor series, Runge-Kutta first, second and fourth order  methods.  

[ 13 Hours ] 

Unit – IV 

Basics concepts and definition of statistics. Mean, Standard deviation, coefficient of  Variation, skewness & kurtosis, Carl Pearson Correlation, Rank correlation and  illustrated examples. Probability: Basic concept and definition of probability, probability  axioms, Laws of Probability, Conditional probability, Bayes theorem , Problems and  application. 

[ 13 Hours ] 

Unit - V 

Random variable and Expectation: Discrete and continuous random variables,  expectation of random variables, theorems on expectation, illustrative examples. Probability Distribution: Probability function, Probability mass/density function,  Discrete Distribution – Bernoulli, Binomial Distribution, Continuous distribution – Normal Distribution, applications and problems. 

[ 13 Hours ] 

Text Books: 

  1. M.K.Jain, SRK Iyengar and R.K. Jain Numerical methods for Scientific and   Engineering Computation: Wiley Eastern. 

  2. Ronald E Walpole & Raymond H Meyers : Probability & Statistics for   Engineers and Scientists (Second Edition). 


  1. J.Medhi : Statistical Methods New Age Publications. 

  2. S.C.Gupta and V.K.Kapoor – Elements of Mathematics, Statistics,   Sultan Chand and Sons. 



  1. Write a menu driven C program to perform the following string operations without  using string functions: (i) String Length (ii) String Concatenation (ii) String  Reverse 

  2. Write a C program to search for an element in an array using Binary search 3. Write a C program to sort a list of N elements using Selection Sort Algorithm. 4. Write a C program to construct a singly linked list and perform insertion, deletion  and Display operations. 

  3. Write a C program to demonstrate the working of stack using liked list. 6. Write a C program for Towers of Hanoi problem.  

  4. Write a C program to find GCD of two numbers using recursion 8. Write a C program to convert infix arithmetic expression to post fix expression. 9. Write a C program to simulate the working of Circular Queue using an array.  10. Write a C program to create and traverse a binary search tree.  


During practical examination the External and Internal examiners may prepare exam  question paper related to theory syllabus apart from Part-A. (A minimum of 10  Programs has to be prepared). 

Note : 

Page 15 of 38 

  1. a) The candidate has to write two the programs One from Part-A and other from  Part-B and execute one program as of External examiner choice. 

  2. b) A minimum of 10 Programs has to be done in Part-B and has to be maintained in  the Practical Record. 

  3. c) Scheme of Evaluation is as follows: 

Writing two programs - 10 Marks 

Execution of one program - 10 Marks 

Formatting the Output - 05 Marks 

Viva - 05 Marks 

Record - 05 Marks 

Total - 35 Marks 



  1. The STUDENT detail databases has a table with the following attributes. The primary  keys are underlined. STUDENT(regno: int, name: string, dob: date, marks: int) i) Create the above table. 

  2. ii) Remove the existing attributes from the table. 

iii) Change the date type of regno from integer to string. 

  1. iv) Add a new attribute phoneno to the existing table. 

  2. v) Enter five tuples into the table. 

  3. vi) Display all the tuples in student table. 

  4. A LIBRARY database has a table with the following attributes. 

LIBRARY(bookid:int, title:string, author:string, publication:string, yearpub:int, price:real) i) Create the above table. 

  1. ii) Enter the five tuples into the table 

iii) Display all the tuples in student table. 

  1. iv) Display the different publishers from the list. 

  2. v) Arrange the tuples in the alphabetical order of the book titles. 

  3. vi) List the details of all the books whose price ranges between Rs. 100 and Rs. 300 3. The SALARY database of an organization has a table with the following attributes.  EMPSALARY(empcod:int, empnamee:string, dob:date, department:string, salary:real) i) Create the above table. 

  4. ii) Enter the five tuples into the table 

iii) Display all the number of employees working in each dapartment. iv) Find the sum of the salaries of all employees. 

  1. v) Find the sum and average of the salaries of employees of a particular department. vi) Find the least and highest salaries that an employee draws.

Page 16 of 38 

  1. Consider the insurance database given below. The primary keys are underlined and  the data types are specified. 

PERSON(driver-id-no: string, name: string, address:strong) 

CAR(regno: string, model: string, year: int) 

ACCIDENT(report-no: int, date: date, location: String) 

OWNS(driver-id-no: string, regno: string) 

PARTICIPATED(driver-id-no: string, regno: string, report-no: int, damage-amount: int) i) Create the above tables by properly specifying the primary keys and the foreign keys ii) Enter atleast five tuples for each relation. 

iii) Demonstrate how you 

  1. a) Update the damage amount for the car with a specific regno in the accident with  report no 12 to 25000. 

  2. b) Add a new accident to the database. 

  3. iv) Find total number of people who owned cars that were involved in accidents in 2002 v) Find the number of accidents in which cars belonging to a specific model were involved 5. Consider the following database of students enrollment in courses and books adopted  for each course. 

STUDENT(regno: string, name: string, major: strong, bdate: date) 

COURSE(course-no: int cname: string, dept: string) 

ENROLL(reg-no: string, course-no: int, sem: int, marks: int) 

BOOK-ADOPTION(course-no: int, sem: int, book-isbn: int) 

TEXT(book-isbn: int, book-title: string, publisher: string, author: string) i) Create the above tables by properly specifying the primary keys and the foreign keys ii) Enter atleast five tuples for each relation. 

iii) Demonstrate how you add a new text book to the database and make this book be  adopted by some department. 

  1. iv) Produce a list of text books (include Course-no, book-isbn, book-title) in the  alphabetical order for courses offered by the ‘Compute Science’ department that use  more than two books. 

  2. v) List any department that has all its adopted books published by a specific publisher. 6. The following tables are maintained by a book dealer  

AUTHOR(author-id: int, name: string, city: string, country: string) 

PUBLISHER(publisher-id: int name: string, city: string, country: string)

Page 17 of 38 

CATLOG(book-id: int, title : string, author-id: int, publisher-id: int, category: int, year:  int, price: int) 

CATEGORY(category-id: int, description: string) 

ORDER-DETAILS(order-no: int, book-id: int, quantity: int) 

  1. i) Create above tables by properly specifying the primary keys and the foreign keys. ii) Enter atleast five tuples for each relation. 

iii) Give the details of the authors who have 2 or more books in the catalog and the price  of the books is greater than the average price of the books in the catalog and the year  of publication is after 2010. 

  1. iv) Find the author of the book which has maximum sales. 

  2. v) Demonstrate how to increase price of books published by specific publisher by 10% 7. Consider the following database for BANK. 

BRANCH(branch-name: string, branch-city: string, assets: real) 

ACCOUNT(accno: int, banch-name: string, balance: real) 

DEPOSITOR(customer-name: string, accno: int) 

CUSTOMER(customer-name: string, customer-street: string, customer-city: string) LOAN(loan-no: int, branch-name: string, amount: real) 

ORROWER(customer-name: string, loan-no: int) 

  1. i) Create the above tables by properly specifying the primary keys and foreign keys. ii) Enter atleast five tuples for each relation. 

iii) Find all the customers who have atleast two accounts at the main branch. iv) Find all customer who have an account at all the branches located in a specific city. v) Demonstrate how t0 delete all account tuples at every branch located in specific city. 8. Consider the following database for ORDER PROCEESING. 

CUSTOMER(cust-no: int, cname: string, city: string) 

ORDER(orderno: int, odate: date, ord-amt: real) 

ORDER_ITEM(orderno: int, itemno:int, qty: int) 

ITEM(itemno: int, unitprice: real) 

SHIPMENT(orderno: int, warehouseno: int, ship-date: date) 

WAREHOUSE(warehouseno: int, city: string) 

  1. i) Create the above tables by properly specifying the primary keys and the foreign keys ii) Enter atleast five tuples for each relation. 

iii) List the order number and ship date for all orders shipped from particular warehouse.

Page 18 of 38 

  1. iv) Produce a listing: customer name, no of orders, average order amount v) List the orders that were not shipped within 30 days of ordering 


During practical examination the External and Internal examiners may prepare exam  question paper related to theory syllabus apart from Part-A. (A minimum of 8  Programs has to be prepared). 

Note :  

  1. a) The candidate has to write two the programs One from Part-A and other from Part-B  and execute one program as of External examiner choice. 

  2. b) A minimum of 8 Programs has to be done in Part-B and has to be maintained in the  Practical Record. 

  3. c) Scheme of Evaluation is as follows: 

Writing two programs - 10 Marks 

Execution of one program - 10 Marks  

Formatting the Output - 05 Marks 

Viva - 05 Marks 

Record - 05 Marks 

 Total - 35 Marks 

Book Now For Free Classes

Get It Now

Bangalore North University BCA previous year Question paper and Study materials

Bangalore North University
BCA Notes Previous Year Question Paper And Solved Question papers

Previous Year Solved Question papers, Model Question papers, Notes, And Videos are Upload on this Website of BCA In Bangalore University and Bangalore North University.
Click here to download BCASolved Question Paper of Bangalore University and Bangalore North University 2015, 2016, 2017, 2018, 2019, 2020, 2021, and other study material

Bangalore North University BCA syllabus 2020

Get All Semester Free Notes

1st Semester

Semester 1

BCA 1st Sem Study Materials

2nd Semester

Semester 2

BCA 2nd Sem Study Materials

3rd Semester

Semester 3

BCA 3rd Sem Study Materials

4th Semester

Semester 4

BCA 4th Sem Study Materials

5th Semester

Semester 5

BCA 5th Sem Study Materials

6th semester

Semester 6

BCA 6th Sem Study Materials

BU BCA WhatsApp Group

Get News, Free Notes, Time Table Etc..

We are providing

Solved Question Paper ChaloExam

Solved Question paper

Model Question Paper ChaloExam

Model Question paper

Learn from Anywhere on Any Time

Get Started Today!

Chaloexam App Store And Play store
Chaloexam Telegram Community

Join Our Telegram Community