SARDAR PATEL UNIVERSITY

SARDAR PATEL UNIVERSIT‘Y BCA ... Handbook of Object technology, CRC Press, Washington DC, ... Advanced Linux Programming Samuel,...

0 downloads 5 Views 142KB Size
SARDAR PATEL UNIVERSIT`Y

BCA

Proposed Syllabus under CBCS (effective from June 2010) 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) Credits Lectures per week

:4 :4

All units carry equal weightage. Theory Units: 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 3. Control Flow Constructs and Cursors − Conditional statement – IF and CASE statements − Controlling loop iterations – LOOP, EXIT, EXITWHEN, WHILE, FOR − Sequential control statement – GOTO and NULL − 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 4. Exception Handling − Error Handling : introduction, advantages of exceptions, types of exceptions − Working with user-defined exceptions – declaration, RAISE_APPLICATION_ERROR, Pragma EXCEPTION_INIT, SQLCODE and SQLERRM 5. Stored Procedures and Functions − Stored procedures – introduction, creating, modifying, executing and dropping procedures − Stored functions – introduction, creating, modifying, executing and dropping functions 6. Database Triggers and Packages − 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, 3 rd 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

:4 :4

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, definition, extending, implementing & accessing − Final variables, methods and classes, abstract methods and classes 3. Method Overloading, Overriding and Exception Handling − Introduction to method overloading and overriding − 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 4. I/O Management and Packages − Introduction to the concept of package, Java API packages, using the System class, user defined packages − Using java.lang (String, Math), java.util (Calendar, Date, ArrayList) packages − Managing I/O files : introduction, concept of streams, character stream classes 5. Applet Programming − 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

6. JDBC − Introduction to IDE, features of NetBeans, application development with NetBeans − 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

:4 :4

All units carry equal weightage. 1. Introduction − 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 2. Scheduling − CPU Scheduling: Introduction to process, process control block, process scheduling − FCFS Scheduling, SJF scheduling, Priority scheduling, Round Robin scheduling 3. 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 4. Process Synchronization and Deadlocks - Introduction to Cooperating process − Process Synchronization, − Critical Section Problem − Two process solution, Multiple process solution − Deadlock and characterization 5. Introduction to Linux - I − Introduction to Linux System & History − Features of Linux − Introduction to File System & Memory Management − Basic Commands: login, logout, date, man, pwd, who, whoami, dir, ls, cd, mkdir, rmdir − Use of Wild card characters and introduction to vi editor 6. Introduction to Linux - II − 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) Credits :6 No. of laboratory hours per week : 12 University examination duration

: 4 Hours

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 Lectures per week

:4 :4

All units carry equal weightage. 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, algorithm of the method of iterative procedure, the secant method, illustration and algorithm, the method of successive approximations, illustrations and algorithm 2. Differentiation − Definition, examples − Higher order derivative of standard functions up to second order. 3. Interpolation with Equal Intervals − Interpolation with equal intervals-finite difference table, The Gregory- Newton formula for forward and backward interpolation, corresponding algorithms and examples 4. Interpolation with Unequal Intervals − Interpolation for unequal intervals, Newton's formula for divided differences, Langrange interpolation, Central difference formulae, Extrapolation, corresponding examples 5. Solution of Simultaneous Linear Equations − The Matrix inversion method, the Gauss-Seidel iterative method − Comparison of direct and iterative methods 6. 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. Rajaraman V. : Computer Oriented Numerical Methods, Prentice Hall of India Pvt. Ltd., 1983 2. Sastry S. S. : Introductory Methods of Numerical Analysis, Prentice Hall of India Pvt. Ltd., 1986 3. Salaria R S : Computer Oriented Numerical Methods, Khanna Book Publishing Co. Ltd., 2000 4. Murray R Spiegel : Theory and Problem of Statistics, McGraw-Hill Schaum's Outline Series,1981. 5. 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

:2 :2

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, Intra-business 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

:2 :2

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.