Tuesday, February 1, 2011
Wednesday, November 4, 2009
LYRICS FOR RAVI
Summer has come and passed
The innocent can never last
wake me up when September ends
like my father's come to pass
seven years has gone so fast
wake me up when September ends
here comes the rain again
falling from the stars
drenched in my pain again
becoming who we are
as my memory rests
but never forgets what I lost
wake me up when September ends
summer has come and passed
the innocent can never last
wake me up when September ends
ring out the bells again
like we did when spring began
wake me up when September ends
here comes the rain again
falling from the stars
drenched in my pain again
becoming who we are
as my memory rests
but never forgets what I lost
wake me up when September ends
Summer has come and passed
The innocent can never last
wake me up when September ends
like my father's come to pass
twenty years has gone so fast
wake me up when September ends
wake me up when September ends
wake me up when September ends
The innocent can never last
wake me up when September ends
like my father's come to pass
seven years has gone so fast
wake me up when September ends
here comes the rain again
falling from the stars
drenched in my pain again
becoming who we are
as my memory rests
but never forgets what I lost
wake me up when September ends
summer has come and passed
the innocent can never last
wake me up when September ends
ring out the bells again
like we did when spring began
wake me up when September ends
here comes the rain again
falling from the stars
drenched in my pain again
becoming who we are
as my memory rests
but never forgets what I lost
wake me up when September ends
Summer has come and passed
The innocent can never last
wake me up when September ends
like my father's come to pass
twenty years has gone so fast
wake me up when September ends
wake me up when September ends
wake me up when September ends
Monday, November 2, 2009
Sunday, November 1, 2009
Extra Practical List for Practice in VC++
1. Print Hello World! at top-left corner of the window using MDI
Application.
2. Change the color of Ellipse when the user presses the left mouse
button while the mouse pointer is inside the rectangle that bounds
the ellipse using MDI Application.
3. Change the color of Ellipse when the user presses the left mouse
button while the mouse pointer is inside the ellipse using MDI
Application.
4. Create Dialog based Application with command button and MessageBox()
(Use all Parameters) to print the message whenever user clicks on
command button.
5. Create Dialog based Application with command button and MessageBox()
(Use all Parameters) to print the message and to count the no. of
clicks on command button.
6. Create Dialog based Application with Five command buttons (First
two have the caption Disable & Hide accordingly). If user presses
the Disable button the rest of the three buttons (Left, Center &
Right) should disable and the Caption is changed to Enable. Apply
the same thing for the Hide button. Hide the buttons and change the
Caption to Show.
7. Create a dialog based Application with Radio Buttons to display the
message with the place user selected along with hotel type (Luxury,
Standard & Economy).
8. Create a Dialog based Application with Static Texts to get the
information like Computer Name, Total Memory, Free Memory and Total
Load on processor.
9. Create a Dialog based Application with Edit Boxes to give the
effect of first text box into second as user changes the text in
first.
10. Write a program that sorts strings stored in an object of
CStringList class.( Use Win32 Console Application)
11. Write a program to create chessboard like boxes (8 X 8) in the
client area. If the window is resized the boxes should also get
resized so that all the 64 boxes would be visible at all times.
12. Write a program to draw a circle, a polygon and a rectangle in the
client area. Create your own pen and brush. Each shape should be
drawn with different pen and brush.
13. Draw a graph . Take suitable points to draw the graph. Draw the lines representing x and y-axis in blue color. Draw rectangles with blue pen and yellow brush.
14. Write a program to draw three rectangles of suitable size using
following three brushes to fill the insides of the rectangle:
- Solid brush of yellow color
- Hatch brush of green color and a suitable pattern
- Pattern brush of blue color with the pattern showing small
dots.
15. Write a program to draw two lines, a vertical and a horizontal, so
that they intersect each other in the center of the window. Draw a
circle having the point of intersection of lines as the center and
radius as 100. Make a provision that if size of the window is
changed the lines and circle should get readjusted accordingly.
16. Write a program to draw 10 successive circles starting from the
smallest to biggest. All the circles must be visible.
17. Write a program through which the user would be able to draw a
rectangle interactively having a border of red color and thickness
5 pixels. One corner of the rectangle would be chosen by clicking
the left mouse button, whereas, for selecting the other corner the
user must be able to drag the mouse. As the mouse is dragged the
size of the rectangle must change.
18. Write a program such that when the user clicks left mouse button in
the client area then a string Hello should get displayed at the
point where the mouse has been clicked. Also make a provision that
every time the user clicks, the string should get written with
different font. Every time the font should be selected randomly.
19. Write a program to draw a freehand drawing.
20. Write a program that displays an animated cursor for the client
window.
21. Write a program that displays four graphical images in the view
window. When a user clicks on any one of the images other images
should be wiped off and the selected one should get enlarged so that
it covers the entire view window.
22. Write a program to display an image in the view window. Suppose the
image contains three colorspink, yellow and brown. If the user clicks
on the pink color a message box should pop up and display the red,
green and blue components of the color.
23. Create an application that provides a menu containing options like-
Color, Font, Attributes, Remove and Copy. On clicking a menu item a
common dialog related to the selected option should get displayed
from where user can make selections.
24. Create an application that would allow to set a different desktop
wallpaper, menu color, mouse double-click time, swap mouse buttons
etc.
25. Create an application for client-server communication (Chat
Application).
26. Create a FTP client which will allows you to download and upload
files on FTP Server.
27. Create a dialog-based application. On clicking Start button,
filenames should get displayed in the static control. The displaying
of filenames should stop the moment user click Stop button. The
window should get closed on clicking the Close. (Hint : Use
Multithreading).
28. Create a Web Browser. (Hint : Use SDI Application and derive the
class from CHtmlView class.
29. Create a line drawing Application using SDI Application and Document
View Architecture support. ( Hint : Derive class from CScrollView).
30. Create an ActiveX Control digital clock.
Courtesy by: Dhaval Thaker,Lecturer,Department of Computer Science,HNGU,Patan
Application.
2. Change the color of Ellipse when the user presses the left mouse
button while the mouse pointer is inside the rectangle that bounds
the ellipse using MDI Application.
3. Change the color of Ellipse when the user presses the left mouse
button while the mouse pointer is inside the ellipse using MDI
Application.
4. Create Dialog based Application with command button and MessageBox()
(Use all Parameters) to print the message whenever user clicks on
command button.
5. Create Dialog based Application with command button and MessageBox()
(Use all Parameters) to print the message and to count the no. of
clicks on command button.
6. Create Dialog based Application with Five command buttons (First
two have the caption Disable & Hide accordingly). If user presses
the Disable button the rest of the three buttons (Left, Center &
Right) should disable and the Caption is changed to Enable. Apply
the same thing for the Hide button. Hide the buttons and change the
Caption to Show.
7. Create a dialog based Application with Radio Buttons to display the
message with the place user selected along with hotel type (Luxury,
Standard & Economy).
8. Create a Dialog based Application with Static Texts to get the
information like Computer Name, Total Memory, Free Memory and Total
Load on processor.
9. Create a Dialog based Application with Edit Boxes to give the
effect of first text box into second as user changes the text in
first.
10. Write a program that sorts strings stored in an object of
CStringList class.( Use Win32 Console Application)
11. Write a program to create chessboard like boxes (8 X 8) in the
client area. If the window is resized the boxes should also get
resized so that all the 64 boxes would be visible at all times.
12. Write a program to draw a circle, a polygon and a rectangle in the
client area. Create your own pen and brush. Each shape should be
drawn with different pen and brush.
13. Draw a graph . Take suitable points to draw the graph. Draw the lines representing x and y-axis in blue color. Draw rectangles with blue pen and yellow brush.
14. Write a program to draw three rectangles of suitable size using
following three brushes to fill the insides of the rectangle:
- Solid brush of yellow color
- Hatch brush of green color and a suitable pattern
- Pattern brush of blue color with the pattern showing small
dots.
15. Write a program to draw two lines, a vertical and a horizontal, so
that they intersect each other in the center of the window. Draw a
circle having the point of intersection of lines as the center and
radius as 100. Make a provision that if size of the window is
changed the lines and circle should get readjusted accordingly.
16. Write a program to draw 10 successive circles starting from the
smallest to biggest. All the circles must be visible.
17. Write a program through which the user would be able to draw a
rectangle interactively having a border of red color and thickness
5 pixels. One corner of the rectangle would be chosen by clicking
the left mouse button, whereas, for selecting the other corner the
user must be able to drag the mouse. As the mouse is dragged the
size of the rectangle must change.
18. Write a program such that when the user clicks left mouse button in
the client area then a string Hello should get displayed at the
point where the mouse has been clicked. Also make a provision that
every time the user clicks, the string should get written with
different font. Every time the font should be selected randomly.
19. Write a program to draw a freehand drawing.
20. Write a program that displays an animated cursor for the client
window.
21. Write a program that displays four graphical images in the view
window. When a user clicks on any one of the images other images
should be wiped off and the selected one should get enlarged so that
it covers the entire view window.
22. Write a program to display an image in the view window. Suppose the
image contains three colorspink, yellow and brown. If the user clicks
on the pink color a message box should pop up and display the red,
green and blue components of the color.
23. Create an application that provides a menu containing options like-
Color, Font, Attributes, Remove and Copy. On clicking a menu item a
common dialog related to the selected option should get displayed
from where user can make selections.
24. Create an application that would allow to set a different desktop
wallpaper, menu color, mouse double-click time, swap mouse buttons
etc.
25. Create an application for client-server communication (Chat
Application).
26. Create a FTP client which will allows you to download and upload
files on FTP Server.
27. Create a dialog-based application. On clicking Start button,
filenames should get displayed in the static control. The displaying
of filenames should stop the moment user click Stop button. The
window should get closed on clicking the Close. (Hint : Use
Multithreading).
28. Create a Web Browser. (Hint : Use SDI Application and derive the
class from CHtmlView class.
29. Create a line drawing Application using SDI Application and Document
View Architecture support. ( Hint : Derive class from CScrollView).
30. Create an ActiveX Control digital clock.
Courtesy by: Dhaval Thaker,Lecturer,Department of Computer Science,HNGU,Patan
Posted by Kapil Shukla at 11:59 PM 
Tuesday, October 27, 2009
Tuesday, October 13, 2009
1
Saurashtra university
Re-Accredited Grade B By NAAC
(CGPA – 2.93)
Syllabus
For
Master of Science (Information Technology & Computer Application)
M.Sc. (IT & CA)
(2 Years Full Time: 4 Semesters Programme)
Effective from June - 2008
URL: www.saurashtrauniversity.edu
2
Master Degree in Science (Information Technology & Computer Application)
(M.Sc. (IT & CA))
(2 Years Full Time Course)
Ordinance:
O. M.Sc. (IT & CA)– 1: Candidates for admission to the Master of Science (Information
Technology & Computer Application) must have a Bachelor's degree of minimum three
years duration in any discipline among B.C.A., B.Sc. (I.T. & C.A.), B.Sc. (Computer
Science / Applications), B.Sc. (Information Science / System), BE (IT), BE (CE/CS) with
at least second class or graduate with PGDCA with at least second class in both.
O M.Sc. (IT & CA)– 2: The duration of the course will be full time two academic years.
The examination for the Master of Science (Information Technology & Computer
Application) course will be conducted under the semester system. For this purpose the
academic year will be divided into two semesters. No candidate will be allowed to join any
other course simultaneously.
O. M.Sc. (IT & CA)– 3: Candidates who have passed an equivalent examination from any
other university or examining body and is seeking admission to the M.Sc. (IT&CA) course
shall not be admitted without producing the eligibility certificate from the Saurashtra
University.
O. M.Sc. (IT & CA)– 4: No candidates will be admitted to any semester examination for
Master of Science (Information Technology & Computer Application) unless it is certified
by the Head, Department of Computer Science.
"That he has attended the courses of study to the satisfaction of the Head, Department of
Computer Science."
O. M.Sc.(IT & CA)– 5: Candidates desirous of appearing at any semester examination of
the M.Sc.(IT & CA)Course must forward their application in the prescribed form to the
Registrar, through the Head, Department of Computer Science on or before the date
prescribed for the purpose under the relevant ordinances.
O. M.Sc. (IT & CA)– 6: No candidate will be permitted to reappear at any semester
examination, which he has already passed.
O. M.Sc. (IT & CA)– 7: To pass the whole M.Sc. (IT & CA) Examination, student should
clear all the four semester examinations within a period of four years from the date of his
Registration. He shall be required to register himself as a fresh candidate and keep the
attendance and appear and pass in the four semester examinations afresh from first semester
onwards in order to obtain the Degree of Master of Science (Information Technology &
Computer Application)
3
O. M.Sc. (IT & CA)– 8: There shall be an Examination at the end of each four semesters
to be known as First semester Examination, Second semester Examination respectively, at
which a student shall appear in that portion of papers practical and Viva- Voce if any, for
which he has kept the semester in accordance with the regulations in this behalf.
A candidate whose term is not granted for whatsoever reason shall be required to keep
attendance for that semester or terms when the relevant papers are actually taught at the
department.
O. M.Sc. (IT & CA)– 9: A candidate failing at any semester examination will be promoted
to the subsequent semester according to the following scheme:
(a) A candidate failing in any number of subjects/courses in the first semester will be
permitted to prosecute his studies up to the third Semester.
(b) A candidate failing in not more than two subjects up to the second semester will be
prosecute the study of third Semester but will not be permitted to go to the Fourth
Semester until he has cleared all the courses of first through the third semester.
O. M.Sc. (IT & CA)– 10: No candidates will be allowed to reappear in a Course in which
he has already passed.
R. M.Sc. (IT & CA)– 1: Standard of passing: The standard of passing the M.Sc.(IT &
CA) degree examination will be as follows: (i) To pass any Semester Examination for the
M.Sc.(IT & CA) Degree, a candidate must obtain at least 40% marks in the University
Examination separately in each course of theory, Practical and project work. (ii) Those of
the successful candidates who obtain 50% or more marks in the aggregate of all the
Semester taken together will be placed in the Second Class and those who obtained 60% or
more marks in the aggregate of all Semesters taken together will be placed in the First
Class. The successful candidates who obtained 70% or more marks in the aggregate of all
the Semester taken together will be declared to have passed the examination in the First
Class with Distinction. (iii) A candidate failing in a subject clears the subject in subsequent
examination will have his subject marks for carry forward for the award of class in the final
semester.
R. M.Sc. (IT & CA)– 2: The following are the courses and the scheme of examination for
the M.Sc. (IT & CA) Degree Examination.
4
A Scheme of Instruction and Examination
M.Sc.(I.T. & C.A.) Syllabus and Teaching Scheme
Subject Name Theory Internal Practical Total Theory Lab Total
Sem – I
P 101 Object Oriented
programming Using
Visual C ++
70 30 50 150 4 6 10
P102 Web Technology
Concepts
70 30 50 150 4 6 10
P 103 RDBMS & Advanced
Database
Administration
70 30 50 150 4 6 10
P 104 O.S. and Network
management
70 30 50 150 4 6 10
P 105 Project – 1 100 100 0 3 3
Sem-2
P201 Linux administration
& Linux Networking
70 30 50 150 4 6 10
P 202 E-Governance
applications and
services
70 30 0 100 4 0 4
P 203 Geo Graphical
Information system
70 30 50 150 4 6 10
P 204 Group Paper – 1 70 30 50 150 4 6 10
P 205 Project - 2 100 100 0 3 3
Sem-III
P 301 Data warehousing and
data mining
applications
70
30
50
150
4
6
10
P 302 Advanced software
engineering
70 30 100 4 4
P 303 Mobile computing 70 30 100 4 10
P 304 Group Paper – 2 70 30 50 150 4 6 10
P 305 Project-3 100 100 3 3
Sem-IV
P 401 Industrial project
work and viva voice
300
Note
(1) Total internal marks must be divided equally in
(a) Presence, Discipline and Regularity of student
(b) Result of local examinations (minimum two in each semester for each
subject)
(c) Participation and performance in class room seminars and term work
(2) it is compulsory for the institute to keep and maintain regular record of above for
each student during the semester, it can be monitored any time by the University
5
GROUPS
Group 1 Group 2 Group 3 Group 4
.Net Java Multimedia Netwoorking
Paper – 1
(Semester -II)
.Net Framework
and C#
Core Java Fundamentals of
Graphics and
Multimedia
Networking
Fundamentals
Paper – 2
(Semester – III)
Programming
with ASP.N ET
Advanced
Java
programming
in J2EE
Multimedia animation
and programming using
FLASH
High
performance
computing
clusture
service
computing
Note
(1) From second semester, student must have to select any one group from above
(2) From second semester onwards students have to study the papers of selected group
(3) Once a group is selected, student will not be allowed to change group in any
subsequent semesters.
6
Semester - 1
Paper -101 Object Oriented Programming using Visual C++
(1) Introduction to OOP
(2) Basic OOP concepts & Applications
(3) Introduction of VC++
(4) Controls usages in Application
(5) Mouse and Keyboard integration
(6) Dialog based Application
(7) Message Handling mechanism
(8) Multiple dialog handling
(9) Documents, views, and the single document interface
(10) Scroll views, HTML views, and other view types
(11) Menu environment
(12) Test and fonts handling
(13) Incorporating graphics, drawing and bitmaps
(14) Device contest and GDI Objects
(15) Single document interface application
(16) Multiple documents and multiple views
(17) C Archive and C File classes
(18) Database handling using ODBC
(19) Database handling using DAO
(20) Database handling using OLEDB
(21) Error Detection and Exception Handling
(22) Toolbars, Status Bars, and Rebars
(23) Serialization
(24) Creating DLLs (COM) using ATL & App Wizard
(25) ActiveX Controls integration in VC++ application
(26) Creating ActiveX controls
Reference:
(1) Mastering VC++, BPB Publication
(2) Practical VC++, PHI Publication
(3) VC++ Unleashed, Techmedia Publication
(4) Programming VC++, Microsoft press publication
7
Paper 102 Web technology concepts using PHP
(1) PHP Basics
(1.1) How PHP works
(1.2) The PHP .ini File
(1.3) Basic PHP syntax : PHP tags, PHP statements and whitespace comments,
PHP functions, hello world!
(1.4) Variables: Variable types, variable names (identifiers, type strength Hello
variables!, variable scope, superglobals, constants, variable – testing and
manipulation functions)
(1.5) First PHP script
(1.6) PHP operators
(1.7) Creating Dynamic pages: Single Quotes Vs. Double Quotes, Passing
variables on the URL, passing variables via the Query String
(2) Flow Control, Arrays
(3) PHP and HTML Forms
(3.1) HTML Forms, how HTML Forms work, processing form input
(4) String Manipulation
(4.1) Formatting Strings, /Concatenation, String Manipulation Functions,
Examples of string functions, working with string manipulation functions,
magic quotes
(5) Reusing Code and Writing Functions
(5.1) including files, require, require_once, auto_prepend_file and
auto_append_file, user functions, defining and calling functions, default
values, variable scope, by reference vs.. by value, form processing code
organization, code organization, conclusion
(6) Managing Data
(6.1) querying a database, inserting, updating deleting, searching records mysql
functions
(6.2) Regular expressions
(6.3) Regular Expression Syntax
(6.4) Start and End (^$)
(6.5) Number of occurrences (? +*{})
(6.6) Common Characters (.\d\D\w\W\s\S)
(6.7) Grouping ([])
(6.8) Negation (^)
(6.9) Subpatterns(())
(6.10) Alternatives(|)
(6.11) Escape Character (\)
(6.12) Form validation functions with regular expressions
(7) Session Control and /Cookies
(7.1) Sessions
(7.2) Configuring Sessions
(7.3) Session Functions
(7.4) Cookies
(7.5) Authentication with Session Control
(8) Sending Email with PHP
(8.1) mail(), shortcomings of mail(), PHPMailer,Sending a password by Email
(9) File System Management
(9.1) Opening a file, fopen(), Reading from a file, fgets(), writing to a file,
fwrite(), writing to a file, file locking, flock(), uploading files via an HTML
8
form, getting file information, more file functions, directory functions
getting a directory listing, creating a resume management page.
Advanced PHP
(10) PHP XML Support
(10.1) Simple XML Objects
(10.2) executing X path Queries
(10.3) DOM Interoperability
(10.4) Using X path
(10.5) Installing and Configuring LIBXSL
(10.6) Applying server side XSL Transformations
(10.7) Using XML in N-Tier Architecture
(10.8) Mixing PHP Objects and XML
(11) PHP Web Services
(11.1) Web service Technology Stack
(11.2) SOAP Soup
(11.3) Web services with PHP
(11.4) Installing NuSOAP
(11.5) Building a SOAP SERVER
(11.6) Consuming a Web service
(11.7) Generating WSDL Dynamically
(11.8) Understanding Generated WSDL
(11.9) WSDL and SOAP Proxies
(12) Ajax with PHP
(12.1) Ajax overview
(12.2) Ajax Technology Stack
(12.3) Ajax Implementations
(12.4) Installing and configuring HTML Ajax Pear Module
(12.5) Ajax Server
(12.6) Ajax Client
(13) Smarty templates
(13.1) Smarty overview, installing and configuring smarty Pear Module, Setting up
a Template, passing data to the template, smarty for template, designers,
smarty for programmers, smarty in N-Tier Architecture
Reference Books
(1) PHP Bible, 2nd Edition :Tim Converse, Joyce Park
(2) PHP manual
9
Paper – 103 DBMS & Advanced Database Administration
(1) Introduction to RDBMS
(2) Basic RDBMS Concepts
(3) Database Administration with SQL Server
(4) Introduction SQL Server
Overview of SQL Server 2000, features, components, relational database engine,
replication, DTS, analysis Services, English Query, SQL server Meta Data Services,
Database Architecture, Relational Database Engine Architecture, Administration
Architecture
(5) SQL Server Programming Tools
SQL query analyzer, overview of Transact-SQL, Transact-SQL syntax elements,
identifiers, variables, functions, Data types, expressions, control-of-flow language
elements, batches, stored procedures and triggers, transact- SQL scripts
(6) SQL Server Database
Components of a SQL server database, files and filegroups, transaction logs,
environment, SQL server installation, security, creating and managing a SQL
server database, data types system-suppplied data types, user-defined data types,
column data types, creating and managing tables, creating tables in a SQL server,
database, and managing tables in a SQL server database
(7) Data Integrity
Enforcing Data integrity, types of data integrity, PRIMARY KEY Constraints,
UNIQUE Constraints, FOREIGN KEY Constraints, CHECK Constraints. Adding.
(8) Accessing and Modifying Data
SELECT, INTO, FORM Clause, WHERE, GROUP BY HAVING And ORDER
BY Clause, using joins to retrieve Data defining subqueries, inserting modifying,
deleting data into a SQL Server Database
(9) Managing and Manipulating Data
Importing and Exporting Data, using the bcp utility and the BULK, INSERT
Statement. Introduction to cursors, fetching and scrolling, controlling cursor
behavior, cursor locking
(10) Implementing Views, stored Procedures, Triggers
Creating, executing, modifying, and deleting stored Procedures, Parameters and
variables, RETURN statement and Error Handling, Nesting Procedures. Cursors,
creating and Managing Triggers, viewing, dropping, and disabling triggers, inserted
and deleted pseudo tables, trigger syntax, system commands, and functions,
creating, modifying, and deleting views, viewing data through views. Modifying
data. Index architecture, index creation and Administration, choosing to index,
index performance
(11) SQL Server Transactions and Locks
Transaction and locking architecture, managing SQL server transactions managing
SQLserver locking configuring transaction properties
(12) SQL Server 2000 Security, Server Monitoring and Tuning
10
Overview of SQL Server 2000security, designing a database security plan.
Database security implementation and Administration, SQL monitoring databases
with SQL profiler, index tuning and Database Partitioning
Database Administration with ORACLE
(13) Managing the Database
Parameter File:INIT.ORA, The oracle SID, crating a new database, startup and
shutdown, the data dictionary, Redo Logs, Control Files, Trace and Alert Files,
database Modes
(14) Managing Disk Space
Oracle blocks in the database files, ROWID, Storage clause, Rollback segments
Tablespaces, temporary segments, analyzing storage, estimating storage for a
table
(15) Managing Users
User Analysis, minimum, maximum level of Access the User, constraints, user
authentication methods, password, operating system authentication, user
configuration setup, profiles, default table space, temporary table space Resource
management, using profiles, defining profiles, creating modifying deleting profiles,
using the default profile, quotas, enforcing tablespace quotas, assigning unlimited
tablespace quotas, user database accounts creating, deleting user accounts, changing
user passwords, working with INIT.ORA parameters, special account
considerations, setting up a generic database administrator, setting up a generic
applications administrator
(16) Backup and Recovery
Importance of Backups, Redo Logs, Archive Logs, Requirements for Backups,
Control Files, Database files, Redo Log Files, Types of Backups, control file
Backups Operating system copy mirrored control files, backing up control files
(online) Backup to trace, Redo Log file Backups, Mirrored Online Redo Logs,
adding members, dropping Redo Log groups, dropping members from Redo Log
Groups, shutting down the instance, steps in performing backup, alternative backup
methods, tablespace offline copy, export, types of database failure tablespace,
control file, Redo Logs Archive Logs, recovery methods, full database recovery,
time-based recovery Cancel-based recovery, sample database backup scripts
(17) Database Tuning
Applications tuning database tuning. Operating system tuning, performace tools
Viewing SGA and parameter settings, tunning database SGA, database Block size
Database buffer cache, shared pool size, rollback segment contention, Redo Log
contention, checkpoints, Database objects, tables and indexes.
(18) Database Security
Authentication, password Authentication, Privileged Accounts, Access Rights
Defined system privileges, grants to PUBLIC, Protected Object Ownership Schema
Capacity planning requirements, defining database roles, system privilege roles
Database auditing
Reference Books
(1) Oracle Complete Reference
(2) Oracle unleashed
(3) SQL Server 2000, Microsoft Press
11
Paper 104 O.S. And Network Management
(1) Overview of Operating System Tasks
(1.1) Operating system types
(1.2) OS functions
(1.3) GUI/Non GUI operating system
(1.4) Comparison of various OS
(2) Essentials of Network Operating System
(2.1) Understanding Requirements of NOS
(2.2) Understanding different file systems (NTFS,VFS, NFS etc)
(2.3) Installation and configuration of Windows 2003 server
(3) Working with Windows 2003 server
(3.1) Essential commands and utilities
(3.2) Administration tools
(3.3) adding/removing O.S. Components
(3.4) Managing file systems
(4) Understanding Network
(4.1) Establishing LAN. Dial up and wire less network, VPN
(4.2) Connectivity with Other computers and devices like cell phone, iPode,
Webcam
(4.3) Sharing managing other users and components of network
(4.4) DNS configuration with Active Directory (overview, understanding
deployment, administration)
(4.5) IIS configuration
4.5.1. Overview
4.5.2. Running Web application
4.5.3. FTP service configuration
4.5.4. mail service configuration
Reference Books
(1) Learning Windows Server 2003 – O’Reilly
(2) Windows 2003 Server – Microsoft Certification Books
Paper 105 Project 1
12
Semester - 2
Paper 201 Linux administration & Linux Networking
(1) Linux Basics & Shell Programming
(1.1) Introduction to linux shell
(1.2) Introduction to shell commands & Practice
(1.3) Introduction to Text Editors – vi, pico
(1.4) Linux file system navigation
(1.5) Printing with linux
(1.6) Using shell commands & scripts
(1.7) Introduction to the process
(1.8) Decision control statements
(1.9) Looping statements
(1.10) The sh command
(1.11) Export exporting shell variables
(1.12) The command
(1.13) Shell functions
(1.14) exec statement
(1.15) eval: Evaluating Twice
(1.16) Introduction to X window system
(1.17) Introduction to Hard Link& Soft Link
(2) Linux system administration
(2.1) Root: The system administrator’s Login
(2.2) Disk Management
(2.3) fdisk L command overview
(2.4) Handling DOS diskettes
(2.5) File system mounting
(3) Linux System configuration
(3.1) System environment
(3.2) Add & remove software packages with package manager
(3.3) Configuring a modem & fax service
(3.4) Configuration of internet service
(3.5) E-mail service
(3.6) Configuration of FTP server
(3.7) Telnet & Internet Relay chat
(4) Linux Networking
(4.1) Networking Environment
(4.2) Basic network client services
(4.3) Basic concepts of DNS
(4.4) Configuration of DNS
(4.5) Basic concepts of DHCP
(4.6) DHCP-Server/clinet setup
(4.7) NFS – Network file system
(4.8) NIS – Network information system
(4.9) Apache Web server
(4.10) Samba server
(4.11) Mail server
(4.12) Proxy server
(4.13) Working with GUI tools
13
(5) Linux Advanced Administration
(5.1) Advanced samba administration
(5.2) Clustering on linux
(5.3) Concurrent versions system
(5.4) Dynamic DNS
(5.5) Introduction to Kernel Concepts
(5.6) RPM Management
(5.7) MySQL & PHP on linux
Reference:
(1) Using Linux, Ball, Que PHI
(2) Linux complete, sybex BPB
(3) UNIX – Concepts & Application, Sumitabh Das, BPB
(4) Professional PHP, Wrox
14
Paper 202 E-Governance Applications and Services
(1) E-Governance
(2) Introduction to E-governance
(3) Role of ICT’s in e-governance
(4) Need, importance of E-governance
(5) Categories of E-governance
(6) Key Issues of E-Governance
(6.1) Technology
(6.2) Policies
(6.3) Infrastructure
(6.4) Training
(6.5) Copyrights
(6.6) Consulting
(6.7) Funds
(7) Major areas of E-governance Services
(7.1) Public Grievances: Telephone, Ration card, transportation
(7.2) Rural services: Land Records
(7.3) Police: FIR registration, Lost and found
(7.4) Social services: Death, domicile, school certificates
(7.5) Public information: employment, hospitals, railway
(7.6) Agricultural sector: Fertilizers, Seeds
(7.7) Utility payments: Electricity, water, telephone
(7.8) Commercial: income tax, custom duty, excise duty
(8) prototyping e-Government applications
(9) E-Governance and laws
(10) Challenges against E-governance
(11) Study of E-gobvernance initiatives in Indian states
(11.1) Gujarat
(11.2) Andharapradesh
(11.3) Maharashtra
(11.4) Kerala
(11.5) Karnataka etc
(12) GIS – GPS –RS
(12.1) Introduction to GIS
(12.2) GPS Introduction/GPS for GIS
(12.3) Remote sensing introduction
Reference:
(1) E-governance concepts & case studies – PHI publication
(2) Geo-information international publications
(3) E-governance projects, PHI publication
15
Paper 203 Geographical Information systems
GEOGRAPHIC INFORMATION SYSTEM (GIS)
(1) Introduction
(2) GIS – Perspective for insights and growth
(3) Project domain of GIS
(4) Real world representation through GIS
(5) Mapping concepts, features and properties
(6) Types of Information in a digital map
(7) Map Analysis
(8) Spatial Concepts
(9) Vector and Raster format in GIS
(10) Functionality available within GIS
(11) Data display and querying
(12) 3-D analysis
(13) Network analysis
(14) The benefits of using GIS
(15) The applications of GIS
(15.1) Environmental resources management
(15.2) Emergency planning and routing
(15.3) Provision of health, education or retail services
(15.4) Facility management for the utilities
(15.5) Highway maintenance and accident monitoring
(15.6) Market analysis
(15.7) Population analysis and prediction
THE GOLOBAL POSITIONING SYSTEM (GPS)
(16) Introduction
(17) Need of GPS
(18) How it works
(19) Accuracy of GPS
(20) The GPS satellite system
(21) Components and basic facts of GPS
(22) Components of a GPS
(22.1) The control segment
(22.2) The space segment
(22.3) The user segment
(23) Surveying with GPS
(23.1) Methods of observations
(23.1.1) Absolute positioning
(23.1.2) Relative positioning
(23.1.3) Differential GPS
The reference station
The mobile station
Data link
(23.1.4) Kinematics GPS
(23.2) GPS Receivers
(23.2.1) Navigation Receivers
(23.2.2) Surveying receivers
(23.2.3) Geodetic Receivers
16
(23.3) Computation of coordinates in GPS
(23.3.1) Transformation from global to local datum
(23.3.2) Geodetic coordinates to Map coordinates
(23.3.3) GPs Heights and Mean Sea Level heights
(23.4) Factors that affect GPS
(23.5) Reference station in GPS
(23.6) Real use of GPS
(23.7) Future of GPS technology
(23.8) GPS in INDIA
REMOTE SENSING
(24) Fundamentals of Remote Sensing
(24.1) Introduction to remote sensing
(24.2) Electromagnetic radiation
(24.3) The electromagnetic spectrum
(24.4) Interactions with the atmosphere
(24.5) Radiation – rarget interactions
(24.6) Passive vs. Active sensing
(24.7) Characteristics of images
(24.8) Satellites & sensors
(24.9) Data reception, transmission, and processing
(24.10) Remote sensing applications
(24.10.1) Agriculture
(24.10.2) Forestry
(24.10.3) Geology
(24.10.4) Hydrology
(24.10.5) Sea ice
(24.10.6) Land cover & land use
(24.10.7) Mapping
(24.10.8) Oceans & coastal monitoring
(25) Practical exercise using ArcView
References:
(1) The GIS Book – George Korte
(2) A to Z GIS – Shelly Somer
(3) GIS for Everyone – Davis, David E.
(4) Principles of GIS – Burrough, P.A.
17
Group – 1
Paper 204 .Net Framework and C#
(1) MS .Net Introduction, features, advantages
(1.1) Ms. Net framework and architecture
(1.2) Ms. Net platform
(1.3) Microsoft .Net and Windows DNA, Microsoft .Net architecture Hierarchy
(1.4) Features of the .Net platform
(1.5) Multilanguage development, platform and processor independence
(1.6) Automatic memory management, easy deployment, distributed architecture,
interoperability with unmanaged code security performance and scalability
(1.7) components of the .Net architecture
(1.8) MS .Net runtime, managed/unmanaged code, intermediate language
(1.9) Common type systems, MS.net base class library (BCL), assemblies
Metadata, assemblies and modules, assembly cache, reflection, just in Time
compilation, garbage collection
(2) MS .Net Programming with C#
(2.1) Introduction to C# .Net language
(2.2) Creating your first C# program
(2.3) Compiling and executing, defining a class, declaring the main() method
(2.4) Organizing libraries with Namespaces, using the “using” keyword, adding
comments
(2.5) introducing data types
(2.6) value types (Primitive Data types) and reference types, boxing and
unboxing, types and aliases, casting between types, common language
specification (CLS)
(2.7) Operators
(2.8) Operator Precedence and Associativity
(2.9) Classes and Structure
(2.10) Defining classes, creating object, class members, access modifiers. The main
method, constructors, constants vs. Read-only fields, Inheritance. Defining
Structs in C#
(2.11) Methods
(2.12) Value and reference parameters, method overloading, variable method
parameters, virtual methods, static methods
(2.13) Properties, arrays, and indexers
(2.14) Properties as smart fields
(2.15) Arrays (Single-Dimensional Array, multidimensional arrays jagged arrays)
(2.16) Accessing lists with indexers
(2.17) Attributes
(2.18) Introducing attributes, defining attributes (class Attributes, method
Attributes, field attributes), Attribute parameters, the attribute Usage
attribute, single-use and multiuse attributes, specifying inheritance attribute
rules attribute identifiers, predefined attributes (obsoleteattribute,
CLSCompliant attribute, Dlllmport and stuctLayout attributes, assembly
attributes), context attributes
(2.19) Interfaces
(2.20) Declaring interfaces, implementing interfaces, explicit interface member
name qualification, interfaces and inheritance, combining interfaces
(2.21) Using Delegates and Events
18
(2.21.1) Delegates: single cast, multicast, Events
(2.22) Explaining control structures
Using the if statement, using the if-else statement. Using the switch case
statement, using the for statement, using the while statement, using the do
while statement, using the break statement, using the continue statement,
using the return statement, using the goto statement
(2.23) Using Exception Handling
Using the try Block, using the catch block, using the finally block, using the
throw statement
(2.24) Understanding inheritance, polymorphism
(2.25) File I/O with streams
Stream classes (filestream, streamreader and streamwriter, string readers and
writers, file system classes (directory and directoryinfo, file and fileinfo,
parsing paths), nonconsole use of streams (openfile dialog, reading web
pages), serialization (Binaryformatter, soapformatter, xmlserializer,
implementing iserializable))
(2.26) Multithreading
Getting started with threads, managing thread lifetimes, destroying threads,
scheduling threads, communicating data to a thread
(3) Windows form and Controls
(3.1) General Controls
Label, text box, button, list box, combo box, check box, radio button picture
box, date time picker progress bar, timer. Status strip, user defined controls
(3.2) Containers
Group box, panel, split container, tab control, tab layout panel, flow layout
panel
(3.3) Menu and Tools Bars
(3.4) Menu strip, context menu strip, status strip, tool strip
(3.5) Dialogs
Color dialog, folder browser dialog, font dialog, open file dialog, save file
dialog
(4) Report
(4.1) Different type of reports
(4.2) Standard, cross-tab, mail label
(4.3) Report sections
(4.4) Report header, report footer, page header, report footer, details, group
header, group footer
(4.5) Using report in application
(4.6) Report objects formatting
(4.7) Page setup
(4.8) Record filtering
(4.9) Formula
(4.10) Special fields
(4.11) Summary
(4.12) Sub report
Reference Books
(1) Inside C# by Tom Archer, MS Press
(2) visual Studio .Net Programming Black Book –dreamtech press
(3) Beginning C#, Wrox publication
19
(4) professional crystal reports for visual studio .Net 2nd edition by David Mcamis,
wrox
(5) crystal reports 10: the complete reference by George Peck, MGH
20
Group – 2
Paper 204 Core Java
(1) Introduction
(1.1) Introduction – what is java, importance of java, java implementation
application of java
(1.2) java buzzwords (simple, secure, portable, object-oriented, robust
multithreaded, architecture – natural, interpreted, high performance,
distributed dynamic)
(1.3) object oriented programming
(1.4) three OOP principals (encapsulation, inheritance, polymorphism)
(1.5) sample program & compilation
(1.6) using block of code
(1.7) lexical issues (White space, identifiers, literals, comments, separators,
keyword)
(1.8) java class library
(2) Data type, operators, control structures
(2.1) variables, constants, declaration, literals, scope of variable, type casting
(2.2) arithmetic operators, relational operators, logical operators, assignment
operators, increment –decrement operators, conditional operators, bit wise
operators, interface of operators, dot operators
(2.3) if-else, statement, loops (while, do-while, for break, goto, continue return)
switch statement, operator
(2.4) arrary –declaration, creation, initialization, length
(2.5) two-dimensional arrays
(2.6) string-string arrays, string methods, stringbuffer class
(3) introduction of classes, objects and methods
(3.1) What is class, object & method
(3.2) defining class, adding variables, adding methods, creating objects
(3.3) constructors THIS key word, garbage collection, finalize() method
(3.4) accessing class members, methods overloading static members, nesting of
methods
(3.5) vactors and wrapper classes
(3.6) inheritance, subclasses, subclass constructor, multiple inheritance,
hierarchical inheritance overriding methods
(3.7) final variables and methods, final classes, finalizer methods, abstract
methods and classes
(3.8) visibility control – public access, friendly access, protected access, private
protected access, rules of thumb
(3.9) method overloading, object as parameters, argument passing, returning
objects, recursion, access control, static, final
(3.10) Nested & inner classes
(3.11) String class
(3.12) Command-Line arguments
(4) Inheritance
(4.1) Inheritance, Member access, super class
(4.2) creating multilevel Hierarchy
(4.3) Method over loading & overriding
21
(4.4) Abstract class, method
(4.5) Using final to prevent overriding & overloading
(4.6) The object class
(5) Packages and Interfaces
(5.1) Defining packages, understanding CLASSPATH
(5.2) Access protection
(5.3) importing packages
(5.4) defining interfaces
(6) exception handling
(6.1) exception types
(6.2) uncaught exceptions
(6.3) multiple catch clauses
(6.4) nested try statements
(6.5) throw
(6.6) throws
(6.7) finally
(6.8) java’s built-in exceptions
(6.9) creating your own exception subclasses
(7) Multithreaded programming
(7.1) creating threads, run()method, new thread, thread class, stopping & blocking
threads
(7.2) life cycle of thread- newborn, runnable, running, blocked, dead, waiting
sleeping, suspended, blocked
(7.3) using thread methods, thread exceptions, thread priority, synchronization
(7.4) implementing the Runnable interface
(8) Applet
(8.1) what is an applel
(8.2) applet lifecycle
(8.3) applet class
(8.4) applet context class
(8.5) passing parameters to applet
(8.6) use of java .awt graphics class and its various methods in an applet
(9) Event Handling
(9.1) Event delegation model or event class hierarchy
(9.2) all classes and interfaces of event delegation model, programmes related to
event handling covering all types of events
(10) I/O files in java
(10.1) Concept of streams, difference between characterstreams and bytestreams
(10.2) characterstreams (reader, writer, bufferedreader,inputstreamreader,
filereader, bufferwriter, outputstreamreader, filewriter, printwriter)
(10.3) Bytestreams (inputstream, fileinputstream, filterinputstream,
bufferedinputstream, datainputstream, outputstream, fileoutputstream,
filteroutputstream, bufferedoutputstream, dataoutputstream, printstream)
(10.4) Other classes (randomaccessfile, stream tokenizer, file)
(11) Graphical user interface
22
(11.1) Layout managers (flowlayout, borderlayout, cardlayout gridbaglayout,
gridlayout)
(11.2) AWT controls (labels, buttons,s canvases, checkboxes, checkboxgroup,
choices, textfields, textareas, lists, scrollbars, panels, windows, frames,
menus, menubars)
(12) Java Swing
Working with JFrame, JApplet, Jpanel, JTextfield, JPasswordField, Jbutton,
Jcheckbox, Jradiobutton, Jlist, Jscrollpane, Jcombobox, Jmenu, Jmenubar,
JMenultem, JpopupMenu, JTree, JTable
Reference Books
(1) SCJP Sun certified programmer for Java 5 study guide (Exam 310-055) by
Katherine sierra and Bert Bates
(2) Java: the CR, 7th Edition by Schildt, Herbert, TMH publication
23
Group – 3
Paper - 204 Fundamentals of Graphics and Multimedia
(1) Application of Computer Graphics
Computer-aided design, presentation graphics, computer art entertainment,
education and training, visualization, image processing graphical user
interfaces
(2) Overview of Graphics systems
Videodisplay devices, refresh cathode-ray tubes, raster-scan displays randomscan
displays, color CRT monitors, direct-view storage tubes flat- panel displays,
three-dimensional viewing devices, stereoscopic and virtual- reality, systems
raster-scan systems, input devices keyboards, mouse, trackball and spaceball,
joysticks, data glove digitizers, image scanners, touch panels, light pens, voice
systems.
(3) Two-Dimensional Geometric Transformation
Basic transformations, translation, rotation, scaling, matrix representations, and
homogeneous, coordinates, composite transformations, translations, rotations,
scallings, general pivot point rotation, general fixed-point scaling general scaling
directions concatenation properties, genral, composite transformations, and
computational efficiency, other transformations, reflection shear
(4) TWO DIMENTIONAL VIEWING
The viewing pipeline, viewing coordinate reference frame, window-to-viewport
coordinate, transformation, two-di;mensional viewing functions clipping
operations, point clipping, line clipping, cohen-sutherland line clipping, liangbarsky
line clipping, nicholl line clipping polygon clipping, Sutherlandhodgernan
polygon clipping
(5) Three-Dimensional Concepts
Three-Dimensional display methods, parallel projection, perspective projection
depth cueing, visible line and surface, identification, surface rendering exploded and
cutaway views, three-dimensional and stereoscopic view.
(6) Three-Dimensional Object Representations.
Polygon surfaces, polygon tables, curved lines and surfaces, quadric surfaces,
sphere, ellipsoid, torus, superquadrics, superellipse superellipsoid, blobby objects,
spline representations, interpolation and approximation, splines, parametric
continuity, conditions, spline specifications, Bezier curves and surfaces, Bezier
curves, properties of Bezier curves, B-Spline curves and surface, B-spline curves
(7) Three-Dimensional Geometric and Modeling Transformations
Translation, rotation, coordinate-Axes Rotations, General Three-dimensional
rotations, scaling, other transformations, reflections, shears, composite
transformations
(8) illumination models and surface-rendering methods
Light sources, basic illumination models, ambient light, diffuse reflection
secularreflection and the phong model, combined diffuse and specular, reflections
with multiple light, sources, intensity, attenuation, color considerations,
24
transparency, shadows, displaying light intensities, assigning intensity levels,
gamma correction and video, lookup tables, displaying continuous–tone, images,
Ray-tracing methods, basic ray-tracing algorithm
(9) Video
Digitizing video, video standards, video compression techniques, digital video
editing and post-production, streamed video and video conferencing
(10) Animation
Captured animation and image sequences, ‘digital cel’ and sprite animation key
frame animation, 2D animation
(11) Sound
The nature of sound, digitizing sound, processing sound, compression formats,
MIDI, combining sound and picture
(12) Distributed multimedia system
Introduction to DMS, main features of DMs resources management of DMS
networking multimedia operating system, distributed multimedia servers,
distributed multimedia application
(13) Multimedia Data Compression
Data compression terminology, a classification of data compression
terminology, data compression technology, compression standards
Reference Books
1. Digital Multimedia, 2nd edition by Dr. Nigel Chapman, Jenny by wiley
publication
2. Computer graphics by Donald Hearn and M.Pauline Baker – Pearson
Education
25
Group – 4
Paper – 204 Networking fundamentals
(1) The development of Network computing
The mainframe environment, the PC revolution. The development of local area,
network(LANs), Cooperative Networking, peer-to-peer networking client/server
networking, master/slave networking. The development of wide area networks
(WANs), intranets, internet overview. The internet and extranets
(2) Physical Networks – Components, Standards and Structure
Basic physical network components network adapter cards, network card
configuration, coaxial, cabling, types of coaxial cabling: Thinnet (10 Base2)
cabling, Thinnet connectors and terminators, Thicknet (10 Base5) cabling coaxial
cabling considerations, Twisted Pair Ethernet cabling, Twisted pair connectors,
cable categories, fibre optic cabling structured cabling, remote connectivity,
modems leased lines, public switched telephone networks (PSTNs). Integrated
services data network – ISDN, integrated services digital network (ISDN) terminal
adapters, comparison of ISDN and PSTN, Network interface Layer, LAN
Technologies, Ethernet, Ethernet Implementations, Ethernet frame formats,
Ethernet limitations, faster Ethernet standards, token ring FDDI, FDDI Fault
Tolerance, CDDI, other LAN technologies, wide area network technologies –
introduction, point-to-point, Tunnelling protocol (PPTP). The X.25 Model, frame
Relay operatio, Asynchronous Transfer mode (ATM). The need for routing,
intermediate nodes, routing vs Bridging, Layer 3 Protocols, Metrics, Network,
infrastructure, LAN interconnections, Repeaters, Hubs, switched Hubs, bridges,
transparent bridging, problems with transparent bridging – loops, spanning tree
algorithm, transparent bridge network after running STA, Source Route Bridging,
Routers, Brouters, Gateways
(3) Networking Protocols
The need for network standards, international organization for standadisation (ISO),
the OSI 7-layer reference model, protocol data unit (PDU), service access point
(SAP), the physical Layer, the Data Link Layer -1. the data link layer -2, the
network layer, the network layer and packet routing, the transport layer, the session
layer, the presentation layer, the application layer, network protocols, the TCP/IP
protocol suite, comparison of TCP/IP and OSI, Novell NetWare protocols,
AppleTalk protocols, NetBIOS extended user interface (NetBEUI)
(4) Internet Protocol (TCP/IP) Suite
Introduction, the history of TCP/IP, TCP/IP standards, architecture, architecturecontinued,
comparison with OSI architecture. Network interface layer, internet
layer, internet control message protocol (ICMP), Internet group management
protocol (IGMP), internet protocol (IP), Transport Layer, User Datagram protocol
(UDP), TCP/IP for windows 2000 – new features, IP addressing, IP addressing,
classes of IP address, subnet masks, subnet masks – continued, subnetting,
supernetting, dynaic v/s manual configuration of TCP/IP hosts, dynamic
configuration DHCP Mechanisms, IP lease renewal, DHCP implementation, name
to address resolution, name resolution, locatl name resolution text files problems
with static host name resolution, NetBIOS names, NetBIOS name discovery
methods, primary and secondary WINS servers, NetBIOS name discovery methods,
primary and secondary WINS Servers, NetBIOS name release. Name resolution by
26
broadcast, Microsoft name resolution methods. TCP/IP node types, the LMHOSTS
file, Windows internet naming service 9WINS0, WINS name registration, renewal
and release WINS implementation introduction to the domain name system, domain
name system (DNS) DNS name space, zones of authority, DNS name server roles,
DNS name resolution, IP address Resolution, integration of Active Directory and
DNS configuring an Active Directory Integrated Zone. Configuring the dynamic
update service for DNS, Testing and troubleshooting the DNS server service
Reference Books
(1) Principles of Netowkr and system Administration – Wiley
(2) Computer Networks and Internets – Douglas E. Comer
27
Semester - 3
Paper 301 Data warehousing and data mining applications
(1) Introduction of Data Warehouse
(1.1) Operational and Informational systems,
(1.2) OLTP and DSS systems
(1.3) Characteristics of Data Warehouse
(1.4) Data Warehouse software and hardware architecture
(1.5) Basic steps to develop data warehouse architecture
(1.6) Architectural components of data warehouse
(1.7) Data warehouse system architecture (Two-Tiered and Three-Tiered)
(2) Data Marts
(2.1) Data Mart structure
(2.2) Usage of Data Mart
(2.3) Security in Data Mart
(2.4) Data warehouse and Data Mart
(3) Online Analytical Transactional Process
(3.1) OLTP and OLAP systems
(3.2) Types of OLAP (MOLAP, ROLAP and HOLAP) with advantages and
(3.3) Disadvantages
(4) ETL
(4.1) Extraction of Data
(4.2) Transformation of Data
(4.3) Loading of Data
(4.4) Practical study of popular ETL tools
(5) Introduction of Data Mining
(5.1) Foundation of Data Mining
(5.2) Data Mining Process (Data Understanding, Data Preparation,
Creating
(5.3) database for data mining, Exploring database, preparation for creating for
(5.4) data mining model, building a data mining model, evaluating a data mining
(5.5) model, deployment of data mining model)
(6) Data Mining Techniques
(6.1) Statistics (Point Estimation, Model based summarization, Bayes theorem,
(6.2) Hypothesis testing, Correlation and regression)
(6.3) Machine Learning
(6.4) Decision Trees
(6.5) Neural Networks
(6.6) Genetic Algorithms (Cross-over techniques, Mutation Function,
Fitness
(6.7) Function)
(6.8) Association Rules (Apriori Algorithm, Sampling Algorithm, Partitioning
(6.9) algorithm, Pincer-Search algorithm, FP-Tree Growth algorithm)
(6.10) Clustering (Hierarchical algorithm, Agglomerative algorithm, Divisive
(6.11) clustering, K- Means, Nearest Neighbor, clustering large database)
28
(7) Practical study in WEKA Environment
(7.1) Implementation of data set into WEKA
(7.2) Rules generated using charts
(7.3) Analysis of data using WEKA
(7.4) Comparison of various algorithms
(8) Practical study of data mining algorithms using SQL Server 2008
(9) Practically development and implementation of Data mining models in following
areas
(9.1) Insurance
(9.2) Financial services
(9.3) Healthcare and medicine
(9.4) Telecommunications
(9.5) Transportation and logistics
(9.6) Government
(9.7) Education
Books
(1) Data mining Explained, A manager's guide to customer centric business intelligence
Rhonda Delmater Monte Hancock Digital Press
(2) Data mining, Pieter Adriaans Dolf Zantinge
(3) Data warehousing in the real world- A practical guide for business DSS Sam
Anahory Dennis Murray
29
Paper 302 Advanced software engineering
(1) Object Oriented Concept And Principles
(1.1) Object Oriented Paradigm
(1.2) Object Oriented Concepts
(1.3) Identifying the elements of an object model
(1.4) Management of Object Oriented software projects
(2) Object Oriented Analysis
(2.1) Object Oriented Analysis Concepts
(2.2) Domain Analysis
(2.3) Generic components of Object Oriented analysis model
(2.4) Object Oriented analysis process
(2.5) Object Relationship model
(2.6) Object behavior model
(3) Object Oriented Design
(3.1) Design of Object Oriented System
(3.2) The System Design Process
(3.3) Object Design Process
(3.4) Design Patterns
(3.5) Object Oriented Programming
(4) Object Oriented Testing
(4.1) Broadening the view of Testing
(4.2) Testing Object Oriented Analysis and Object Oriented Design Models
(4.3) Object Oriented Testing Strategies
(4.4) Test case design for Object Oriented Software
(4.5) Testing methods applicable at the class level
(4.6) Interclass test case design
(5) Technical metrics for Object Oriented Systems
(5.1) The intent of Object Oriented Metrics
(5.2) The distinguishing Characteristics of Object Oriented Metrics
(5.3) Metrics for Object Oriented Design Model
(5.4) Class Oriented Metrics
(5.5) Operation Oriented Metrics
(5.6) Metrics for Object Oriented testing
(5.7) Metrics for Object Oriented Projects
(6) Clean Room Software Engineering
(6.1) The clean room approach
(6.2) Functional specification
(6.3) Clean room specification
(6.4) Clean room design
(6.5) Clean room testing
(7) Component Base Software Engineering
(7.1) Engineering of component based systems
(7.2) The component based software engineering process
30
(7.3) Domain engineering
(7.4) Component based development
(7.5) Classifying and Retrieving Components
(8) Case studies of all above Books
Books
(1) Software Engineerin, A practicenor's approach Roger S. Pressman
(2) Object Oriented Analysis and Design, Gooch
31
Paper 303 Mobile Computing
(1) Introduction to wireless networks and mobile computing
(2) Wireless Transmission
Frequencies, signals, antennas, signal propagation, Multiplexing (SDM, FDM,
TDM, COM), modulation(ASK, FSK, PSK), spread spectrum, cellular system
(3) Medium Access Control
Hidden/exposed terminals, near/far terminals, SDMA, FDMA, TDMA, CDMA
(4) Wireless LANs
Infra red vs. radio transmission, infrastructure vs. ad-hoc networks, IEEE 802.11
architecture, MAC layer,Synchronization, power management, roaming, IEEE
802.11 802.11b, 802.11a, new developments, Bluetooth overview
(5) Mobile IP
Overview, network elements, packet delivery, agent discovery, registration unneling
and encapsulation, optimization, IPV6, IP micro-mobility support, DHCP and
mobile IP
(6) Mobile Transport Layer
Traditional TCP and implications on mobility, indirect TCP, snooping
TCPDiscussion of project ideas Mobile TCP, fast retransmit/fast recovery, selective
retransmission, and transaction oriented TCP TCP over 2.5/3G networks,
performance-enhancing proxies
(7) Mobile Computing
File systems and WWW architectures for mobile computing WAP - architecture,
protocols ( WDP, WTLS, WTP, WSP ) WAP - Wireless Applications Environment,
WML, Push architecture, push/pull services, push-pull based data acquisition,
WAP1.X stacks, l-mode, WAP 2.0
(8) Wireless Telecomm Networks
Evolution of wireless telecomm networks : GSM, GPRS IS-95, CDMA-2000, WCDMA
(9) Messaging Services
Short Message Services (SMS) Multimedia Message Services(MMS) Multimedia
transmission over wireless
(10) Wireless Location Determination Technologies
Routing and location independent information access
(11) Pervasive computing and information access Application framework, Architecture,
and Development
(12) Distributed caches in mobile computing environment
(13) Distributed wireless sensor networks
(14) Resource sharing in wireless distributed systems
32
Group – 1
Paper 304 Programming with ASP.NET
(1) Building ASP.NET Pages
(1.1) ASP.NET and the .NET Framework
(1.2) Introducing ASP.NET Controls
(1.3) Adding Application logic to an ASP.NET Page
(1.4) The structure of an ASP.NET Page
(2) Building Forms with Web Server Controls
(2.1) Building Smart Forms
(2.2) Controlling Page Navigation
(2.3) Applying Formatting to Controls
(3) Performing Form Validations with validation controls
(3.1) Using client side validation
(3.2) Requiring fields: The RequiredFieldValidator control
(3.3) Validating expressions: The RegularExpressionValidator Control
(3.4) Comparing Values: The CompareValidator Control
(3.5) Checking for a Range of values: The RangeValidator Control
(3.6) Summarizing Errors: The ValidationSummary Control
(3.7) Performing Custom Validation: The CustomValidator Control Disabling
Validation
(4) Advanced Control Programming
(4.1) Working with View State
(4.2) Displaying and Hiding Content
(4.3) Using Rich Controls
(5) Introduction to ADO.NET
(5.1) An Overview of ADO.NET
(5.2) Performing Common Database Tasks
(5.3) Improving Database Performance
(5.4) Advanced Database Topics
(6) Binding Data to Web Controls
(6.1) Overview of Data Binding
(6.2) Building a Server Control to a Data Source
(6.3) Creating Master/Detail Forms
(6.4) Data Binding without Data Binding Expressions
(7) Using the DataList and DataGrid Controls
(7.1) Overview of the DataList and DataGrid controls
(7.2) Using the DataList Control
(7.3) Using the DataGrid Control
(8) Working with DataSets
(8.1) Understanding DataSets
33
(8.2) Understanding DataTables
(8.3) Understanding DataViews
(8.4) Using DataSets with ASP.NET Pages
(9) Working with XML
(9.1) Overview of the XML
(9.2) Classes Using XML with DataSets
(9.3) Transforming XML with XSL Stylesheets
(9.4) Using the ASP.NET XML Control Using the XslTransform Class Using
Strongly Typed DataSets
(10) Using ADO.NET to Create a Search Page
(10.1) Using SQL Server Full Text Search
(10.2) Using the Microsoft Indexing Service
(11) Creating ASP.NET Applications
(11.1) Overview of ASP.NET Applications
(11.2) Using Application State
(11.3) Using the Web.config File
(11.4) Using HTTP Handler and Modules-
(12) Tracking User Sessions
(12.1) Using Browser Cookies
(12.2) Using Session State
(12.3) Using Cookieless Sessions
(13) Caching ASP.NET Applications
(13.1) Using Page Output Caching
(13.2) Using Page Fragment Caching
(13.3) Using Page Data Caching
(14) Application Tracing and Error Handling
(14.1) Responding to Errors
(14.2) Tracing and Monitoring Your Application
(14.3) Logging Events
(14.4) Using the Debugger
Books
(1) ASP.NET UNLEASHED,Stephen Walther Pearson Edition
(2) ASP.NET BLACK BOOK
34
Group – 2
Paper 304 Advanced Java Programming in J2EE
(1) Introducing J2EE
(1.1) J2EE Introduction
(1.2) J2EE Platform Technologies At a Glance
(1.3) Sun Java Application Server
(2) Installation Of J2EE
(2.1) Downloading J2EE
(2.2) Installing J2EE
(2.3) Uninstalling J2EE
(3) Introduction To Web Application
(3.1) Web Application Architecture
(3.2) Collecting data
(3.3) Sending the web server request
(3.4) Executing server side program/script
(3.5) Developing Server Applications
(4) Java Servlets
(4.1) Servlet Introduction
(4.2) Architecture of a Servlet
(4.3) Servlet API
(4.4) Servlet Life Cycle
(4.5) Servlet in Web Application
(4.6) Compiling and Buildling Servlet Application
(4.7) Deploying Web Application
(4.8) Undeploying Web Application
(4.9) Cookies in Servlet: Types of Cookies, Advantages of Cookies, Creating
Cookies using Servlet
(5) Sessions
(5.1) Life cycle of HttpSession
(5.2) Methods of Session Tracking
(5.3) Session API for creating, deleting and managing sessions
(6) JDBC
(6.1) JDBC Introduction
(6.2) JDBC Architecture
(6.3) Types of JDBC Drivers
(6.4) JDBC API and Objects
(6.5) Database Connection Statement PreparedStatement, CallableStatement
(6.6) Connecting with Databases
(6.6.1) MySQL
(6.6.2) Access
(6.6.3) Oracle
(6.6.4) Performing Database Operations
(7) Java Server Pages
(7.1) Introduction
35
(7.2) JSP vs. Servlet J
(7.3) SP Architecture J
(7.4) SP Lifecycle
(7.5) JSP Elements: Directive Elements, Scripting Elements, Action
(7.6) Elements JSP Implicit Objects
(7.6.1) Request
(7.6.2) Response
(7.6.3) Out
(7.6.4) Session
(7.6.5) Application
(7.6.6) Config
(7.6.7) PageContext
(7.6.8) Page
(7.6.9) Exception
(7.7) JSP Scope
(7.7.1) Application Scope
(7.7.2) Session Scope
(7.7.3) Request Scope
(7.7.4) Page Scope
(8) Enterprise Java Beans
(8.1) Enterprise Bean Architecture
(8.2) Benefits of Enterprise Bean
(8.3) Types of Enterprise Bean
(8.3.1) Session Beans
(8.3.2) Entity Beans
(8.3.3) Message Driven Beans
(9) Working with Session Beans
(9.1) Stateless Session Beans
(9.2) Stateful Session Beans
(9.3) Demo Application for Session Beans
(10) Working with Message Driven Beans
(10.1) Use of Message Driven Beans
(10.2) Demo Application for Message Driven Bean
(11) Working with Entity Beans
(11.1) Java Persistence
(11.2) Entity Class
(11.3) Persistent Fields and Properties
(11.4) Demo Application for Entity Beans
Books
(1) Java Server Programming For Professionals, Ivan Bayross, Sharanam Shah, Shroff
publication
(2) Java Server Programming Black Book, Dreamtech Publications
36
Group – 3
Paper 304 Multimedia Animation and script programming using Flash
(1) Basic Introduction of Animation and script programming
(1.1) Create still or animated text on your Web page.
(1.2) Use Flash tools to create your own graphics for your Web page or to import
graphics.
(1.3) Animate graphics and make objects appear and disappear by using the
transparency feature.
(1.4) Create Web page buttons that not only lead your viewers wherever you want
them to go but also change shape or color at the same time.
(1.5) Add sound or video to your movie.
(1.6) Create menus that viewers can use to navigate your site.
(2) Getting Start with Flash
(2.1) Flash Menus, panel and toolbar.
(2.2) The Timeline window
(2.3) The Use of Flash Help window.
(2.4) Creating drawings
(2.5) Making graphics move (Animation - I)
(2.6) Publishing your first animation on Web browser
(2.7) Setting the Stage, adding metadata, Library, Using Template
(3) Animation on objects and text
(3.1) Selecting and Manipulating objects (moving, copying, and deleting)
(3.2) Use of Motion and shape tweening effect
(3.3) Reshaping shapes, Working with fills, Transferring properties to objects
(scaling, rotating, skewing, and flipping)
(3.4) Combining, Grouping and ungrouping, Breaking apart objects
(3.5) Creating, editing, and formatting text using text effects, Hyper linking text,
(3.6) Creating input and dynamic text
(4) Layer Effects, Symbols
(4.1) Creating layers
(4.2) Modifying layers
(4.3) Using guide layers
(4.4) Creating holes with mask layers
(4.5) Types of symbols
(4.6) Making symbols
(4.7) Creating instances
(4.8) Buttons and Scripting
(4.9) Making simple buttons
(4.10) Testing your buttons
(4.11) Adding sound, movie clip to button
(4.12) The Timeline window effects
(4.12.1) Animation frame by frame
(4.12.2) Adding labels and comments
(4.12.3) Reversing animation
(4.12.4) Using onion skins
(4.12.5) Breaking movie into scene
(4.13) Adding action to timeline
37
(4.14) Controls through script on Buttons
(4.14.1) Add a button that acts on text input (interactive control)
(4.14.2) Using Behavior, Action Events
(4.14.3) Browser/Network action commands
(4.14.4) Built in Methods, External Scripting
(5) Development of small application of Publishing Web Application using Flash
Books:
(1) Flash 8 Bible,IDG Book India Reinhardt, Robert
(2) Macromedia Flash 8 for Dummies, Wiley Publishing Gurdy Leete and Ellen
Finkelstien
(3) Flash 4: Magic, TechMedia Darnell Rick
38
Group – 4
Paper 304 High Performance Computing, Cluster Server Computing
(1) High Performance Computing
(1.1) The Demand for High Performance Computing
(1.2) Parallel Processing -An introduction
(1.3) Classification of computer architecture by Flynn
(1.4) Shared memory multiprocessing architecture model
(1.5) Distributed memory multiprocessing and its important
(1.6) Parallelism in Sequential Machines
(1.7) Abstract Model of Parallel Computer
(1.8) Architectural Features of Messages - Passing Multi computers
(1.9) Basics of Message-passing Programming
(1.10) Pipelined Computations
(1.11) Synchronous Computations
(1.12) Algorithms and Applications
(1.13) Parallel Programming Languages
(1.14) Scalar vs. Vector pipelining
(1.15) Architecture of PVM
(2) Cluster Server Computing
(2.1) Introduction to Clusters
(2.2) Definition, Distinctions and Initial Comparisons
(2.3) Symmetric Multiprocessors
(2.4) Basic Programming Models and Issues
(2.5) Commercial Programming Models
(2.6) Cluster Design and Networking concepts
(2.7) Cluster Installation and Administration Issues
(2.8) Comparisons of Different Open Source Architectures
(2.9) Advantages of Cluster Server
Books
(1) Introduction to Parallel Processing M. Sasikumar, PHI
(2) Building your own cluster O'reilly
(3) Parallel Programming
(4) Prentice Hall, Barry Wilkinson and Michael Alien
305 - Project – III
39
Semester - 4
Paper 401 Industrial Project and Viva-Voce
Note:
(1) Institute/College/Department has to make arrangement for the students for project
development in various software development organizations in industry.
(2) Project work must be developed at the industrial organization
created by :Ritesh Patadia
Subscribe to:
Posts (Atom)
