Showing posts with label Semester 5. Show all posts
Showing posts with label Semester 5. Show all posts

Thursday, January 29, 2009

ERP Systems - Detailed Syllabus

ERP Systems is one of the elective subjects for semester 5 of bscit and following is the detailed syllabus for the subject :

1) Introduction To ERP
Evolution of ERP, What is ERP? Reasons for the growth of ERP, Secnario and Justification of ERP in India, Evaluation Of ERP, Various Modules
Of ERP, Advantage of ERP.

2) An overview of Enterprise, Integrated Management Information, Business Modelling, ERP for Small Business, ERP for make to order companies, Business Process Mapping for ERP Module Design, Hardware Enviornment and its Selection for ERP Implementation.

3) ERP and Related Technologies, Business Process Reengineering (BPR), Management Information System (MIS), Executive Information System (EIS), Decision support System (DSS), Supply Chain Management (SCM)

4) ERP Modules, Introduction, Finance, Plant Maintainance, Quality Management, Materials Management

5) ERP Market, Introduction, SAP AG, Baan Company, Oracle Corporation, People Soft, JD Edwards World Solutions Company, System Software Associates, Inc. (SSA)
QAD, A Comparative Assessment and Selection of ERP Packages and Modules.

6) ERP implementation lifecycle, issues in implementing ERP packages, pre-evaluation screening, package evaluation, project planning phase, gap analysis, reengineering,
configuration, implementation, team traning, testing, going live, end-user training, post implementation (Maintainance mode).

7) Vendors, Consultants and users, In-House Implementation - pors and cons, vendors, consultants, end user.

8) Future Directions in ERP, New markets, new channels, faster implementation methodologies, business modules and BAPIs, convergence on windows NT, Application platform,
new business segments, more features, web enabling, market snapshot.

Read more...

Wednesday, January 28, 2009

Advanced Java - Detailed Syllabus

Advanced Java is one of the Elective subjects for Semester 5 of B.Sc.it and following is the detailed syllabus for the subject :

1) Introduction to SwingJapplet, Icons and Labels, Text Fields, Buttons, Jbutton Class, Check Box, Radio Buttons, The Container, Panel, Windows,and Frame Classes, Combo Box, Tabbed Panes, Scroll Panes, Trees, Tables, Custom Rendering of Jlist Cells.

2) JDBC
i) JDBC Fundamentals
ii) Establishing Connectivity and working with connection interface
iii) Working with statements
iv) Creating and Executing SQL statements
v) Working with Result Set Object & Result Set Meta Data

3) Servlets
i) Introduction to Servlets (Life cycle of servlets, Java Servlets Development Kit, creating, Compiling and running servlet)
ii) The servlet API : javax.servlet package
iii) Reading the servlet Parameters, Reading Initialization parameter
iv) The javax.servlet.http.Package
v) Handling HTTP Request and Response (GET / POST Request) vi) Using Cookies, Session Tracking

4) introduction To Java Beans
i) What is Java Bean?, Advantage
ii) Installing / Starting / Using BDK ( Bean Development Kit)
iii) JAR Files
iv) Using the Java Beans API

5) JSP
i) Advantage of JSP technology (Comparision with ASP / Servlet)
ii) JSP Architecture, JSP Access Model
iii) JSP Syntax Basic (Directions, Declarations, Expression, Scriplets, Comments)
iv) JSP Implicit Object, Object Scope
v) Synchronization Issue
vi) Exception Handling
vii) Session Management

Read more...

Tuesday, January 20, 2009

SQL 2 - Detailed Syllabus

SQL 2 is one of the subjects for Semester 5 of B.Sc.-IT and following is the detailed syllabus for the subject :

1) Introduction to SQL: The SQL language, role of SQL, SQL features & benefits
Microsoft commitment (ODBC & ADO) , Internet database access , Java integration
(JDBC)

2) SQL & DBMS: Brief history of SQL , SQL Standards (ANSI / ISO Standards,
other SQL standards, ODBC & the SQL access group) , SQL & networking (centralized architecture, file server architecture , client/server architecture, multi-tier architecture)

3) RDBMS: Data models (File management systems, hierarchical databases,
network databases), relational data model (Keys, tables, relationships), Codd's 12 rules

4) SQL Basics: statements, names (table & column names), data types , constants
(numeric, string, date & time, symbolic constants), expressions , built-in functions, missing data (NULL values)

5) Simple queries: The SELECT statement , query results, simple queries, duplicate rows, row selection, search conditions, sorting query results, rules for single table query processing

6) Multi-table queries : Simple joins , Non equi-joins, SQL considerations for multi table queries (table aliases, qualified column names, all column selections , self joins) , multi table query performance , the structure of the join (table multiplication, rules for multi-table query processing) , outer joins.

7) Summary Queries : column functions, grouped queries, group search conditions.

8) Sub queries & query expressions : using sub queries, sub query search
conditions, sub queries & joins, nested sub queries , correlated sub queries, sub queries in the HAVING clause, advanced queries in SQL2 .

9) Database updates : adding data to the database , deleting data from the
database, modifying data in the database

10) Data integrity : meaning of data integrity, required data, simple validity checking (column check constraints, domains), entity integrity (other uniqueness constraints, uniqueness & NULL values) , referential integrity (referential integrity problems, delete & update rules, cascaded deletes & updates, referential cycles, foreign keys & NULL values) , trigger advantages & disadvantages, triggers & SQL standards.

11) Transaction Processing : Meaning (COMMIT, ROLLBACK), transaction log,
transaction & multi user processing, locking (locking levels, shared & exclusive locks, deadlocks, advanced locking techniques)

12) Creating a database : DDL, creating database , table definitions, constraint
definition, aliases & synonyms, indexes, managing other database objects, database structures (single database architecture, multi- database architecture, multi-location database architecture)

13) Views : meaning, creating a view (horizontal, vertical, row/column subset,
grouped , joined views), updating a view, dropping a view

14 ) SQL security : SQL security concepts (user-ids, security objects, privileges) , views & SQL security, granting privileges , revoking privileges

Read more...

Monday, January 19, 2009

Visual Basic 6.0 (VB) - Detailed Syllabus

Visual Basic 6.0 is one of the subjects for Semester 5 of B.Sc.-IT and following is the detailed syllabus for the subject :

1) Introduction to Visual Basic
Introduction Graphical User Interface (GUI), Programming Language (Procedural,
Object Oriented, Event Driven), The Visual Basic Environment, How to use VB
complier to compile / debug and run the programs.

2) Introduction to VB Controls
Textboxes, Frames, Check Boxes , Option Buttons, Images, Setting a Border &
Styles, The Shape Control, The line Control, Working with multiple controls and their properties, Designing the User Interface, Keyboard access, tab controls, Default & Cancel property, Coding for controls.

3) Variables, Constants, and Calculations
Variables, Variables Public, Private, Static, Constants, Data Types, Naming
rules/conventions, Constants, Named & intrinsic, Declaring variables, Scope of
variables, Val Function, Arithmetic Operations, Formatting Data.

4) Decision & Conditions
If Statement, If ?then-else Statement, Comparing Strings, Compound
Conditions(And, Or, Not), Nested If Statements, Case Structure ,Using If statements with Option Buttons & Check Boxes, Displaying Message in Message Box, Testing whether Input is valid or not.
Using Call Statement to call a procedure.

5) Menus, Sub-Procedures and Sub-functions
Defining / Creating and Modifying a Menu, Using common dialog box, Creating a
new sub-procedure, Passing Variables to Procedures, Passing Argument ByVal or
ByRef, Writing a Function Procedure,

6) Multiple Forms
Creating , adding, removing Forms in project, Hide, Show Method, Load, Unload
Statement, Me Keyword, Referring to Objects on a Different Forms,

7) List, Loops and Printing
List Boxes & Combo Boxes, Filling the List using Property window / AddItem Method, Clear Method, List box Properties, Removing an item from a list, List Box/ Combo Box, Do/Loops, For/Next Loops, Using MsgBox Function, Using String Function, Printing to printer using Print Method,

8) Arrays Single-Dimension Arrays, Initializing an Array using for Each, User-Defined Data Types, Accessing Information with User-Defined Data Types, Using List Boxes with Array, Two dimensional arrays.

9) OOP in VB
Classes, Creating a new Class, Creating a new object using a class, choosing when to create New Objects, The Initialize & Terminate events.

10) Data Files
Opening and Closing Data Files, The Free File Function, Viewing the data in a file, Sequential File Organization (Writing Data to a sequential Disk File, Creating a sequential data file, Reading the Data in a sequential file, Finding the end of a Data file, Locating a file). Trapping Program Errors, The Err Object, Random Data File Opening a random file, Reading and writing a random file(Get, Put, LOF, Seek).

11) Accessing Database File
Creating the database files for use by Visual Basic ( Using MS-Access
), Using the Data Control ,setting its property, Using Data Control with forms,
navigating the database in code ( the recordset object using the movenext,
movepreviouse, movefirst & movelast methods , checking for BOF & EOF, using
listboxes & comboboxes as data bound controls, updating a database file ( adding, deleting records ) .

12) Advanced data handling
Displaying data in grids ( grid control, properties of grid ) , displaying the record no & record count, opening the database, validation & error trappings ( locking text boxes, trap errors with On Error, file open errors ) , Recordset , searching for a specific record ( findfirst, findnext, findlast, findprevious,) , seek method, working with database fields, creating a new dynaset.

Read more...

Saturday, January 17, 2009

Internet Security (IS) - Detailed Syllabus

Internet Security is one of the subjects for Semester 5 of B.Sc.-IT and following is the detailed syllabus for the subject :

1)Introduction
Why require a security Picking a Security Policy , Strategies for a Secure Network ,
The Ethics of Computer Security, Security Threats and levels, Security Plan (RFC
2196)

2) Classes of Attack
Stealing Passwords.
Social Engineering.
Bugs and Backdoors.
Authentication Failures.
Protocol Failures.
Information Leakage.
Exponential Attacks?Viruses and Worms.
Denial-of-Service Attacks.
Botnets.
Active Attacks

3) Computer Security
What are viruse, Trojan Horse, Worms How to protect the computer against virus
What is the Structure of virus?

4) Firewalls and Proxy Servers
Kinds of Firewalls.
Packet Filters.
Application-Level Filtering.
Circuit-Level Gateways.
Dynamic Packet Filters.
Distributed Firewalls.
What Firewalls Cannot Do
Filtering Services.
Reasonable Services to Filter.
Digging for Worms.
Packet Filtering
Implementing policies (Default allow , Default Deny ) on proxy

5) Cryptography
Introduction to Basic encryption and Decryption,
Diffie ? Hellman Key Exchange
Concept of Public key and Private key
Digital Signatures

Read more...

Saturday, December 27, 2008

B.Sc.IT Semester 5 Subjects and Books.

Following are the Subjects and Reference Books for B.Sc. IT ( Mumbai University ) Third Year - Semester V:

1.) Internet security
Reference Books :
- Firewalls and Internet Security: Repelling the Wily Hacker , Second Edition Addison Wessly

2.) Visual Basic 6
Reference Books :
- Programming in VB 6 by Julia case Bradley , Anita C. Millspaugh, TMH.
- Visual Basic 6.0 Programming by Content Development Group, TMH.
- The Complete Reference Visual Basic 6 by Noel Jerke , TMH.

3.) SQL 2
Reference Books :
- The complete reference SQL by James R. Groff & Paul N. Weinberg TMG.
- SQL a complete reference by Alexis Leon & Mathews Leon TMG.

4.) Elective I (Select one of the following)
a.) Multimedia
b.) Embedded Systems and Programming
c.) Web Design and Internet based applications
d.) Advanced Java

5.) Elective II (Select one of the following)
a.) ERP Systems (Enterprise Resource Planning)
b.) GIS (Geographic Information System)
c.) Management information Systems
d.) BPR (Business Process Re-engineering)

Read more...

  © Blogger templates Psi by Ourblogtemplates.com 2008

Back to TOP