SARDAR PATEL UNIVERSIT`Y
BCA Semester-IV S E M E S T E R -IV TITLE Core Courses
Foundation Courses Elective
US04CBCA01 : Relational Database Management Systems-II US04CBCA02 : Object Oriented Programming Through Java US04CBCA03 : Operating Systems US04CBCA04 : Practicals US04FBCA01 : Computer Based Numerical and Statistical Methods US04EBCA01 : E-Commerce US04EBCA02 : Enterprise Resource Planning Total Credits
NO. OF CREDITS 4 4 4 6 4 2 24
Course: US04CBCA01 (Relational Database Management Systems-II) Effective from June - 2011 Credits Lectures per week
All units carry equal weightage. 1. Relational Database Design − Consequences of poor database design − The process of database normalization − Functional dependencies − Lossless joins and dependency preservation − 1st Normal Form, 2nd Normal Form, 3rd Normal Form, Boyce-Codd Normal Form − Examples of normalization − 2. Basics of PL/SQL − PL/SQL - Introduction and advantages − Understanding PL/SQL Block structure − Fundamentals of PL/SQL Language - data types (BOOLEAN, CHAR, NUMBER, DATE, VARCHAR2), variables, constants and expressions (CASE expression) − Operators − Conditional statement – IF and CASE statements − Controlling loop iterations – LOOP, EXIT, EXITWHEN, WHILE, FOR − Sequential control statement – GOTO and NULL 3. Cursors and Exception Handling − SELECT..INTO statement − Working with cursor : introduction, types, attributes and processing (i.e. declaring, opening, fetching and closing), using parameterized cursor, using cursor FOR loop − Error Handling : introduction, advantages of exceptions, types of exceptions − Working with user-defined exceptions – declaration, RAISE_APPLICATION_ERROR, Pragma EXCEPTION_INIT, SQLCODE and SQLERRM − 4. Stored Subprograms, Database Triggers and Packages − Stored procedures – introduction, creating, modifying, executing and dropping procedures − Stored functions – introduction, creating, modifying, executing and dropping functions − Database triggers – introduction, creating, modifying and dropping triggers, types of triggers − Packages – meaning, advantages, creating, modifying and dropping MAIN REFERENCE BOOKS : 1. An introduction to Database Systems : Bipin C. Desai, Galgotia Poblications Pvt. Ltd. 2. Ivan Bayross : SQL, PL/SQL The programming language of Oracle, 3rd revised edition, BPB Publications 3. Kevin Loney, George Koch, Orale9i The Complete Reference , Oracle Press 4. Buluksu Lakshman : Oracle9i PL/SQL : A developer’s guide, Apress, edition 2003
BOOKS FOR ADDITIONAL READING : 1. Understanding Database Management Systesm : S. Parthsarthy and B.W.Khalkar, First edition – 2007, Master Academy 2. P. S. Deshpande : SQL/PLSQL for Oracle9i, dreamtech press, reprint edition 2009
Course : US04CBCA02 (Object Oriented Programming Through Java) Credits Lectures per week
All units carry equal weightage. 1. Introduction − History of Java, features, the Java environment, the Java Virtual Machine (JVM) − Structure of a Java program, a simple Java program, implementing a Java program − Tokens, comments, constants, variables and data types − Scope of variables, type casting − Operators: arithmetic, relational, logical, assignment, increment/decrement, conditional, ternary operator & special operators − Decision making: if statement, if…else statement, nesting of if…else, the else if ladder, switch statement − Looping: while, do…while, for, for each loop jumps in loops, labeled loops − Arrays: one, two dimensional arrays 2. Classes, Objects, Interfaces and Inheritance − Defining a class, members of a class: variables and methods, creating objects, constructors, accessing class members − Static members v/s instance members − Introduction to inheritance, super keyword − Interfaces: introduction − Final variables, methods and classes, abstract methods and classes − Introduction to method overloading and overriding 3. Exception Handling, I/O Management and Packages − Managing errors & exceptions: introduction, types of errors, exceptions, syntax of exception handling construct, multiple catch statements, the finally clause, defining and throwing user-defined exceptions, the throw statement − Managing I/O files : introduction, concept of streams, Character stream classes − Introduction to the concept of package, Java API packages, using the System package − Using java.lang (String, Math) 4. Applet Programming and JDBC − Applet architecture and skeleton − java.awt package (Button, CheckBox, CheckBoxGroup, Choice, Color, Label, List, TextArea, TextField) − HTML applet tag, display techniques (DrawString, Lines, Rectangle, Ellipses, Circles, Arcs, Polygons, Color) − Introduction to event handling − Introduction to JDBC, types of drivers − java.sql package − Retrieving, inserting, deleting and updating data though Java
MAIN REFERENCE BOOKS : 1. Programming with Java- A Primer by E. Balaguruswami, 3rd Edition, TMH Publication 2. The Complete Reference – Java 2 7th Edition Herbert Schildt. TMH Publication BOOKS FOR ADDITIONAL READING : 1. Saba Zame , Handbook of Object technology, CRC Press, Washington DC, 1999 2. Mary Campion and Kathy Walrath, Java tutorial, Second Edition, Addison Wesley Pun. 1998. 3. Java 2 Programming Black Book, Steven Holzner
Course : US04CBCA03 (Operating Systems) Credits Lectures per week
All units carry equal weightage. 1. Introduction and Scheduling − Introduction to Operating System, Functions of OS − Different types of Operating Systems: Real time, Multi-user, Time sharing − OS Structure – Monolithic, Layered, Virtual Machine, Client-Server − CPU Scheduling: Introduction to process, process control block, process scheduling − FCFS Scheduling, SJF scheduling, Priority scheduling, Round Robin scheduling 2. Memory Management − Memory Management: Concept, Basic memory management techniques:, Swapping, Virtual Memory System, Demand Paging a) The Optimal Page Replacement Algorithm b) The NRU Page Replacement Algorithm c) The FIFO Page Replacement Algorithm d) The second change Page Replacement Algorithm e) The clock Page Replacement Algorithm 3. Process Synchronization, Deadlocks and Introduction to Linux - Introduction to Cooperating process − Process Synchronization, − Critical Section Problem − Two process solution, Multiple process solution − Deadlock and characterization − Introduction to Linux System & History − Features of Linux − Introduction to File System & Memory Management 4. Basic Linux commands − Basic Commands: login, logout, date, man, pwd, who, whoami, dir, ls, cd, mkdir, rmdir − Use of Wild card characters and introduction to vi editor − Introduction to environment variable like HOME, PATH, PS1 − Types of FAP, use of chmod command − Basic commands like cp, mv, rm, rev, file redirection, − grep, cut, paste, find sort commands with example − Introduction to shell script: execution of it, shell script variable, expr, test commands − Control structure: if, if..else, case structure − Iteration: while, for construct, break, continue, exit commands MAIN REFERENCE BOOKS : 1. Andrew S. Tanenbaum: Operating System deign & Implementation, Prentice Hall International 2. James Peterson and Abraham Silberschatz: Operating System Concept, Addition Wesley 3. Linux Commands Instant reference – Bryan Pfaffenberger, BPB Publication 4. Advanced Linux Programming – Samuel, Techmedia Publications
Course : US04CBCA04 (Practicals)
No. of laboratory hours per week
Part-I : Weightage-50% • Practical based on US04CBCA01 : Relational Database Management Systems-II (Questions based on cursors, database triggers, database object creations (e.g. stored procedures, functions) may be asked. Part-II : Weightage-50% •
Practical based on US04CBCA02 : Object Oriented Programming using Java (Questions based on Java programming concepts may be asked)
Course : US04FBCA01 (Computer Based Numerical and Statistical Methods) Credits :4 Lectures per week :4 All units carry equal weightage. Unit-1. Computer Arithmetic & Iterative Methods - Absolute, Relative and Percentage error - The method of successive bisection, an algorithm of bisection method to find a root and examples - The method of false position - The method of iterative procedure - Secant method, illustration and algorithm - The method of successive approximations, illustrations and algorithm Unit-2. Interpolation with Equal and Unequal Intervals - Interpolation with equal intervals-finite difference table - The Gregory- Newton formula for forward and backward interpolation corresponding algorithms and examples - Interpolation for unequal intervals using Newton's formula for divided differences - Lagrange interpolation - Central difference formulae - Extrapolation and corresponding examples Unit-3. Differentiation and Solution of Simultaneous Linear Equations - Definition and examples of differentiation - Higher order derivative of standard functions up to second order - The Matrix inversion method - The Gauss-Seidel iterative method - Comparison of direct and iterative methods Unit-4. Time Series and Forecasting - Utility of Time Series Analysis - Components of Time Series - Secular trend, Seasonal variation, Cyclical variation and Irregular variation - Methods on measurement of components - The moving average method - merits and limitations - Forecasting models and methods MAIN REFERENCE BOOKS : 1. Sastry S. S. : Introductory Methods of Numerical Analysis, Prentice Hall of India Pvt. Ltd., 1986(2) 2. Salaria R S : Computer Oriented Numerical Methods, Khanna Book Publishing Co. Ltd., 2000(3) 3. Fundamentals of statistics by S.C. Gupta, Himalaya Publishing House.(6)
OTHER REFERENCE BOOKS : 1. Rajaraman V. : Computer Oriented Numerical Methods, Prentice Hall of India Pvt. Ltd., 1983 2. Murray R Spiegel : Theory and Problem of Statistics, McGraw-Hill Schaum's Outline Series,1981. 3. A text book of Calculus with an introduction to differential Equation by Dr. Dinesh J. karia, Mahendra L. Patel, Roopal Prakhashan Vallabh Vidyanagar.
Course : US04EBCA01 (E-Commerce) Credits Lectures per week
All units carry equal weightage. 1. Introduction To E-Commerce − Definition, communication perspective, business process perspective, service perspective − Classification by nature of transaction : B2B, B2C, C2C, C2B, Non business EC, Intrabusiness EC − Classification of EC Applications: electronic market, inter organizational system, customer services − Benefits to organizations, consumers, and society − Limitations of EC, framework of EC, future of EC 2. E-Commerce Business Models − Introduction, eight key ingredients of a business model, major B2C and B2B business models, Introduction to M-Commerce. 3. Electronic Marketplaces − Marketspace components, types of electronic markets (electronic storefronts, electronic malls, types of stores and malls) − Portals and their types, role of intermediaries in E-markets, E-market success factors, competitive factors, impact of E-Market on organizations (marketing, HR, manufacturing, finance and accounting) 4. Customer Relationship Management (CRM) − CRM : meaning, types of CRM, benefits and limitations of CRM, issues in CRM implementation, classifications of CRM applications, one-to-one marketing (personalization, collaborative filtering, customer loyalty, trust) MAIN REFERENCE BOOKS : 1. Electronic Commerce : A managerial Perspective Efraim Turban, Jae Lee, David King, H Michael Chung (Pearson Education.) 2. E-Commerce – Business, Technology, Society Kenneth C Laudon, Carol Guercio Traver (Pearson Education)
Course : US04EBCA02 (Enterprise Resource Planning) Credits Lectures per week
All units carry equal weightage.
1. Introduction − Enterprise Resource Planning (ERP) : introduction, history, advantages − Enterprise : introduction, business modeling, integrated data model, integrated management information − Basic concepts of ERP − Risks and benefits of ERP 2. ERP and Related Technologies − Introduction to MRP, MRP-II and ERP − Business Process Reengineering (BPR) − Data warehousing, data mining and Online Analytical Processing (OLAP) − Product Life Cycle Management (PLM), Supply Chain Management (SCM), Customer Relationship Management (CRM) 3. ERP Marketplace and Functional Modules − Marketplace : overview, dynamics, changing ERP market − Indian ERP Scenario − Functional modules of ERP software − Integration of ERP, SCM and CRM 4. ERP – Selection and Implementation − ERP package selection − ERP Implementation basics, ERP Implementation Life Cycle MAIN REFERENCE BOOKS : 1. Alexis Leon : Enterprise Resource Planning, Tata McGraw-Hill, New Delhi 1st and 2nd editions. 2. Internet based resource.