minor
TRANSCRIPT
30
1. TnPMS
Introduction Need of TnPMS in Hamdard Definition of Problem
30
INTRODUCTION
The numbers of student use computer have increased manifold and the need to develop
student-friendly menu-driven software arose resulting in the advent of new era. Training and
Placement Management System (TnPMS) is a way towards it. TnPMS is a web application
intended to provide an online information management for the Training and Placement cell.
Earlier all the works in the Training and Placement cell at Jamia Hamdard was done
manually, so there was a strong need of this software enabling the T & P more easier,
manageable and quicker. The Training and Placement cell operates year round to facilitate
contacts between companies and college graduates.
This application is a tool in the hand of Training and Placement Officer (TPO) from which he
could manage all the information and data of the student very easily and also provide time to
time information to the students about the various placement opportunities. He could also
manage the statistics of the various students placed from various branches. This information is
also open to all where anyone could see the placement statistics.
This application consist of various modules which are as follows,
Student Interface
Student registration – The student registration portal provides an online registration form
from where any student could fill their data regarding their personal details, academic detail,
branch and other information and submit to the TPO.
Placement details- One could select the branch from the given list and could view the various
details of the placed students.
News flash- The news flash is made to provide latest information to student about the notice
posted by the TPO, visiting companies and its criteria, schedule for GD and PI, result of the
aptitude test conducted by the company and other relevant information.
Study material/guidelines for student – This section provides the study material like
question paper of various company and the technologies, Interview tips and other guidelines
to the student.
30
TPO Interface
Login – The login page provides the login to the TPO from where he could login and Insert,
update and delete the data of the students after his username and the password is validated. An
unauthorized user could not login to the system.
Edit, Update and delete account- Since the TPO is the administrator so he has been given
the power to update, insert and delete the various data of the student.
Need of the TnPMS in Jamia Hamdard
Origin of the Project (Problem identification)
Since the Training and the Placement cell of Jamia Hamdard manages data and all the
functions of the information sharing was done manually, so there was a strong need of the
software /application which could automate the functionality of T& P cell and the information
sharing could be easy and efficient. The TnPMS, provides student pertaining to achieve the
Placement in an organization of repute after their degree.
Definition of Problem
TnPMS is a tool in the hand of Training and Placement Officer (TPO) from which he could
manage all the information and data of the student very easily and also provide time to time
information to the students about the various placement opportunities. He could also manage
the statistics of the various student placed from various branches. This information is also
open to all where anyone could see the placement statistics. The present project will help in
achieving the main objective.
30
OBJECTIVES
IMMEDIATE OBJECTIVES
2. OBJECTIVES
Immediate Long Term
30
The main objective of this project is the computerization on the web for
various information sharing and interaction of the TPO with the student in an
easy and efficient manner.
To store data of the entire student from different branches.
To facilitate easy and efficient retrieval of data and information sharing between the
TPO and the Student.
To save time of student in terms of online registration.
To provide online information and different news updates for the proper
placement of student in their dreams organizations.
To provide the various guidelines and the preparation material for placement.
To provide the data of the student who all the being placed in the various
organizations.
LONG-TERM OBJECTIVE
To provide this facilities for various other branches like MBA, Pharmacy and Allied
Health science.
30
SYSTEM ANALYSIS
3. SYSTEM ANALYSIS
Identification of Need Preliminary Investigation Feasibility Study
30
System Analysis by definition is a process of systematic investigation for the purpose of
gathering data, interpreting the facts, diagnosing the problem and using this information to
either build a completely new system or to recommend the improvements to the existing
system.
A satisfactory system analysis involves the process of examining a business situation with the
intent of improving it through better methods and procedures. In its core sense, the analysis
phase defines the requirements of the system and the problems which user is trying to solve
irrespective of how the requirements would be accomplished.
Success of a system depends largely on how accurately a problem is defined, thoroughly
investigating and properly carried out to the choice of solution, analyze the phase in which the
requirements of new system are identified. System analysis is a detailed study of various
operations performed by a system and their relationships within an outside of a system. The
question is : What must be done to solve the problem? One aspect of analysis is defining the
boundaries of the system and determining whether or not a candid system should consider
other related system. During analysis data are collected on the available files, decision points
and transaction handle by a parent system. Data low diagrams, interviews, onsite
observations, questionnaires are used as a logical system model and tools to perform the
analysis.
Task that are performed by an analyst:
Gathers all facts about the present system.
Studies the requirement of system.
Determines “What” must be done to solve the problem.
Prepares a functional specification document.
In order to reduce the time there is need for computerized system that can retrieve data, insert
data, update existing data or deleting existing data. This website is developed with the aim of
reducing time, manpower, cost so that the records can be easily maintained. The volume of
work and complexity are increasing year by year. This system reduces workload and
complexity.
30
IDENTIFICATION OF NEED1) All the details about Training and Placement were being entered on paper manually
which was an extremely cumbersome as well as time consuming process.
2) Further it was inefficient as stacks of storage were required to maintain these records.
3) Since, the existing system (manual work) takes more time and manpower for
processing. Our system will deal with all the aspects of Students regarding the training
and placement.
PRELIMINARY INVESTIGATION
Before designing a system, the requirements of the system and users need have to be properly
determined. At the heart of systems analysts is a detailed understanding of all important facets
of the business area under investigation, (for this reason, the process of acquiring this
information is often termed as detailed investigation.) Analysts, working closely with
employees and managers, must study the business process to answer these key questions:
1. What is being done?
2. How is it being done?
3. How frequently does it occur?
4. How great is the volume of transactions or decisions?
5. How well is the task being performed?
6. Does a Problem Exist?
7. If a problem exists, how serious is it?
8. If a problem exists, what is the underlying cause?
To answer these questions, system analysts talk to a variety of persons to gather details about
the business process and their opinions Of why things happen as they do and their ideas for
changing their process. Questionnaires are used to collect this information from large group
of people who cannot be interviewed individually. Detailed investigations also require the
study of manual and reports, actual observation of work activities and sometimes, collection
of sample forms and documents to fully understand the process.
As the details are gathered the analysts study the requirements data to identify features the
new system should have, including both the information the system should produce and
operational features such as processing controls, response times , and input and output
methods.
30
Initial investigation is the first step in the development of the system. After making the initial
analysis, it is required to determine whether the planned system is feasible or not. The
feasibility study is test of a system proposal according to its workability, impact on the
organization, ability to meet users need and effective use of resources. During the feasibility
study, the problem definition is crystallized and aspects of the problem to be included in the
system are determined. To perform feasibility study, we need to consider the Economic,
Technical and Behavioral actor in the system development.
FEASIBILITY STUDY
A feasibility study determines whether the proposed solution is feasible based on the priorities
of the requirements of the organization. A feasibility study culminates in a feasibility report
that recommends a solution. It helps you to evaluate the cost-effectiveness of a proposed
system.
The feasibility study is carried out to test if the proposed system is worth being implemented.
Given unlimited resources and infinite time, all projects are feasible.
After performing a Preliminary Investigation, gathering and interpreting data and details
concerning the project, a Feasibility Check is done which involves a series of steps to check
the Technical, Financial and Operational feasibilities.
During this phase, various solutions to the existing problems were examined.
For each of these solutions the Cost and Benefits were the major criteria to be examined
before deciding on any of the proposed systems.
These Solutions would provide coverage of the following:
a) Specification of information to be made available by the system.
b) A clear cut description of what tasks will be done manually and what needs to be
handled by the automated system.
c) Specifications of new computing equipment needed.
A system that passes the feasibility tests is considered a feasible system. Let us see some
feasible tests in my project.
TECHNICAL FEASIBILITY
It is related to the software and equipment specified in the design for implementing a new
system. Technical feasibility is a study of function, performance and constraints that may
30
affect the ability to achieve an acceptable system. During technical analysis, the analyst
evaluates the technical merits of the system, at the same time collecting additional
information about performance, reliability, maintainability and productivity. Technical
feasibility is frequently the most difficult areas to assess.
The main technical issue raised during feasibility is the existence of necessary technology
and whether the proposed equipment has the capacity to hold required data. The technical
guarantee of accuracy, reliability, ease and data were also investigated.
In this part the aspects that are considered are, Can the work for the project be done with
the current equipment, existing software technology, and available personnel? If new
technology is required, what is the likelihood that it can be developed?
Since in the start-up meeting, it was found that the main need was for better response and
throughput from the system. The committee for technical feasibility study decided that the
problems of existing system were because of following reasons:
1. Not efficient for large data.
2. The existing systems were not user friendly and very much time consuming.
3. There was lot of bottlenecks in the existing software which delayed the
processing. Keeping in view with above problems , as desired in case of further
expansion, the study group gave the report to go in for more open type
system.
ECONOMIC FEASIBILITYEconomic feasibility, which is most commonly known as cost-benefit analysis determines the
adoption of a system can be cost justified. The aim of this step is to evaluate the effectiveness
of the new system and then compare it with the cost also includes the man-hours and time.
Economical feasibility determines whether there are sufficient benefits in creating to make the
cost acceptable, or is the cost of the system too high. On the behalf of the cost-benefit
analysis, the proposed system is feasible and is economical regarding its pre-assumed cost for
making a system.
During the economical feasibility test we maintained the balance between the Operational and
Economical feasibilities, as the two were the conflicting. For example the solution that
provides the best operational impact for the end-users may also be the most expensive and,
therefore, the least economically feasible.
30
We classified the costs of CCTS according to the phase in which they occur. As we know that
the system development costs are usually one-time costs that will not recur after the project
has been completed. For calculating the Development costs we evaluated certain cost
categories viz.
(i) Personnel costs
(ii) Computer usage
(iii) Training
(iv) Supply and equipments costs
(v) Cost of any new computer equipments and software.
COST- BENEFIT ANALYSIS
A cost-benefit analysis is necessary to determine economic feasibility. The primary objective
of the cost benefit analysis is to find out whether it is economically worthwhile to invest in the
project. If the returns on the investment are good, then the project is considered economically
worthwhile. Cost benefit analysis is performed by first listing all the costs associated with
the project cost which consists of both direct costs and indirect costs. Direct costs are those
incurred by buying software, hiring people, cost of consumable items, rent for
accommodation etc. Indirect costs include those involving time spent by user in
discussing problems with system analysts , gathering data about problem etc.
OPERATIONAL FEASIBILITY
Operation feasibility is a measure of how people feel about the system. Operational
Feasibility criteria measure the urgency of the problem or the acceptability of a solution.
Operational Feasibility is dependent upon determining human resources for the project. It
refers to projecting whether the system will operate and be used once it is installed. If the
ultimate users are comfortable with the present system and they see no problem with its
continuance, then resistance to its operation will be zero.
Behaviorally also the proposed system is feasible. A particular application may be technically and but may fail to produce the forecasted benefits, because the company is not able to get it to work. For the system, it is not necessary that the user must be a computer expert, but any computer operator given a little bit of knowledge and training can easily operate.
SOFTWARE ENGINEERING PARADIGM APPLIED
Software Engineering is a planned and systematic approach to the development of software. It
is a discipline that consists of methods, tools and techniques used for developing and
maintaining software. To solve actual problems in an industry setting, a software engineer or
30
a team of engineers must incorporate a development strategy that encompasses the process,
methods and tool layers and generic phases. This strategy is often referred to as a process
model or Software Engineering paradigm.
For developing a software product, user requirements are identified and the design is made
based on these requirements. The design is then translated into a machine executable language
that can be interpreted by a computer. Finally, the software product is tested and delivered to
the customer.
Iterative and Incremental development is a cyclic software development process. It starts
with an initial planning and ends with deployment with the cyclic interaction in between.
An iterative development model
The basic idea behind iterative enhancement is to develop a software system incrementally,
allowing the developer to take advantage of what was being learned during the development
of earlier, incremental, deliverable versions of the system. Learning comes from both the
development and use of the system, where possible key steps in the process are to start with a
simple implementation of a subset of the software requirements and iteratively enhance the
evolving sequence of versions until the full system is implemented. At each iteration, design
modifications are made and new functional capabilities are added.
The procedure itself consists of the initialization step, the iteration step, and the Project
Control List. The initialization step creates a base version of the system. The goal for this
initial implementation is to create a product to which the user can react. It should offer a
sampling of the key aspects of the problem and provide a solution that is simple enough to
understand and implement easily. To guide the iteration process, a project control list is
created that contains a record of all tasks that need to be performed. It includes such items as
30
new features to be implemented and areas of redesign of the existing solution. The control list
is constantly being revised as a result of the analysis phase.
The iteration involves the redesign and implementation of a task from the project control list,
and the analysis of the current version of the system. The goal for the design and
implementation of any iteration is to be simple, straightforward, and modular, supporting
redesign at that stage or as a task added to the project control list. The level of design detail is
not dictated by the interactive approach. In a light-weight iterative project the code may
represent the major source of documentation of the system; however, in a mission-critical
iterative project a formal Software Design Document may be used. The analysis of an
iteration is based upon user feedback, and the program analysis facilities available. It involves
analysis of the structure, modularity, usability, reliability, efficiency, & achievement of goals.
The project control list is modified.
30
4. TOOLS & PLATFORM
Hardware Specification Software Specification .Net Framework SQL Server 2005 Windows XP Professional
30
H/W AND S/W REQUIREMENT SPECIFICATION
Hardware Specification
Pentium II 1.5 GHz and Above
126 MB RAM or More
502 MB Server RAM
20 GB HDD
40 GB Server HDD
Software Specification
Windows XP Professional
SQL Server 2005
Asp.Net 3.5 with C#
ADO .NET for connectivity
CSS
Why we use .Net Framework?
The role of enterprise Information Technology (IT) continues to change at an accelerating
pace from a focus on cutting costs to a focus on cutting costs and helping drive revenue and
profits. This means an emphasis on quick, cost-effective integration with suppliers, partners,
and customers outside the corporate LAN, outside the firewall. In short, it means doing more
with less.
For example, the .NET framework provides the tools to allow developers to code solutions
once and have them work on multiple devices, such as smart phones and Windows powered
Pocket PCs.
This technical brief outlines the important elements of the Microsoft .NET platform for
enterprise application development, along with their benefits and technology requirements
from the CIO, Enterprise Architect, developer and IT Professional’s perspective. It is intended
to aid IT Pros in planning their infrastructure and application development environments.
30
Elements of the .NET Framework
The .NET Framework is the programming model of the .NET platform for building,
deploying, and running XML Web services and applications. It manages much of the
plumbing, enabling developers to focus on writing the business logic code for their
applications. The major elements of the .NET Framework are:
Common Language Runtime
.NET Framework Classes
ASP.NET
XML Web Services
NET Remoting
Windows Forms
Common Language Runtime
The common language runtime is the execution engine for .NET Framework applications. It
provides a number of services, including the following:
Code management (loading and execution)
Application memory isolation
Verification of type safety
Conversion of intermediate language to machine language
Access to metadata (enhanced type information)
Management of memory for managed objects
Enforcement of code access security
Exception handling, including cross-language exceptions
Interoperation between managed code (code that is written to target the services of the
common language runtime), Component Object Model (COM) objects, and
unmanaged code and data (pre-existing dynamic-link libraries [DLLs])
Automation of object layout
Support for developer services (such as profiling and debugging)
Common Language Runtime Elements
The common language runtime is responsible for runtime services such as language
integration, security enforcement, and memory, process and thread management. In addition,
it has a role at development time where features such as lifetime management, strong type-
naming, cross-language exception handling, and dynamic binding to reduce the amount of
code a developer must write to turn business logic into a reusable component.
30
The elements of the Common Language Runtime are shown in Figure 1.
The common language runtime supports a choice of over 20 languages. The languages
compile to intermediate language through a compiler, and it is this intermediate language
Code that is converted to machine language by a just-in-time (JIT) compiler optimized for the
specific system. This managed code then executes through the common language runtime on
the client device.
Benefits
The common language runtime provides a solid foundation for developers to build various
types of applications. Whether a developer writes an ASP.NET application, a Windows Forms
application, an XML Web Service, a mobile code application, a distributed application, or an
application that combines several of these application models, the common language runtime
provides the following benefits:
Simplified development
Integration of code written in various languages
Security with code identity
Deployment that eliminates DLL versioning issues, commonly referred to as "DLL
hell"
Versioning of reusable components
Reuse through implementation inheritance
Object lifetime management
Descriptions of objects
30
The common language runtime makes it easy to design components and applications whose
objects interact across languages. Objects written in different languages can communicate
with each other, and their behaviors can be tightly integrated. For example, a developer can
define a class, and then use a different language to derive a class from the original class, or
call a method on the original class. A developer can also pass an instance of a class to a
method of a class written in a different language. This cross-language integration is possible
because language compilers and tools that target the runtime use a common type system
defined by the runtime, and they follow the runtime's rules for defining new types, as well as
for creating, using, persisting, and binding to types.
Programs developed in any environment from notepad.exe to advanced Integrated
Development Environments (IDE) such as Visual Studio.NET. can use the common language
runtime.
Technology Requirements
The common language runtime must be installed for any .NET code to run on the server or, in
the case of Windows forms applications on the client machine. At the time of this writing the
common language runtime is installed as part of the .NET Framework software development
kit (SDK), and will be included in the Microsoft Windows® .NET Server family.
.NET Framework Classes
The .NET Framework includes classes, interfaces, and value types that expedite and optimize
the development process and provide access to system functionality. To facilitate
interoperability between languages, the .NET Framework types conform to the common
language specification (CLS) and can therefore be used from any programming language with
a supported compiler. This allows enterprise IT departments to retain and extend their existing
base of developers, and to begin immediate development of new .NET applications—or .NET
enhancements to existing applications with full interoperability. This decreases time to market
by increasing code re-use through cross-language inheritance.
The .NET Framework types are the foundation on which .NET applications, components, and
controls are built. The .NET Framework includes types that perform the following functions:
1. Represent base data types and exceptions
2. Encapsulate data structures
3. Perform input/output (I/O)
30
4. Access information about loaded types
5. Invoke .NET Framework security checks
6. Provide data access
7. Enable rich client-side Graphical User Interface (GUI) and server-controlled, client-
side GUI
The .NET Framework provides a rich set of interfaces, as well as abstract and concrete (non-
abstract) classes. Developers can use the concrete classes as is or, in many cases, derive
custom classes from them. To use the functionality of an interface, developers can either
create a class that implements the interface or derive a class from one of the .NET Framework
classes that implements the interface.
Benefits
Application features that used to be hard to implement, or required a 3rd-party component,
can now be added in just a few lines of code using the .NET Framework. The .NET
Framework offers over 4500 classes that encapsulate rich functionality like XML, data access,
file upload, regular expressions, image generation, performance monitoring and logging,
transactions, message queuing, SMTP mail, and much more.
For example, Release Services Manager (RSM) 2.0, an internally developed line of business
application, provides Microsoft with real-time access to product and release data and supports
the electronic delivery of product information to manufacturing vendors and business
partners. The design of RSM 2.0 is based on an n-tier architecture, the middle tier of which
consists of several XML Web services that communicate with the database by using a middle-
tier framework of classes. By building a smart client application through Windows Forms, a
very complex user interface was developed for RSM 2.0 with less effort than modifying the
Web-based user interface that existed in the previous version of RSM. Several .NET
Framework classes were used in manipulating files on the client computer. Background
processing and multithreading minimized the impact to performance.
Technology Requirements The .NET common language runtime must be installed on clients and servers running .NET
applications. The Framework Library and common language runtime are distributed as one
install package of approximately 21 MB. At the time of this writing this package can be
installed from the .NET Framework SDK.
30
ASP.NET
ASP.NET is a revolutionary programming framework that enables the rapid development of
powerful Web applications and services. It provides the easiest and most scalable way to
build, deploy, and run Web applications that can target any browser or device.
Benefits
The chief benefits of ASP.NET are as follows:
Easy Programming Model. ASP.NET makes building real-world Web applications
dramatically easier.ASP.NET server controls enable an HTML-like style of
declarative programming that lets developers create effective pages with far less code
than was previously necessary with Active Server Pages (ASP).Displaying data,
validating user input, and uploading files are all simple operations. ASP.NET pages
work in all browsers, including Netscape, Opera, AOL, and Microsoft Internet
Explorer.
Flexible Language Options. ASP.NET lets developers take advantage of their current
enterprise programmer language skills.Unlike classic ASP, which supports only
interpreted Microsoft Visual Basic Scripting Edition (VBScript) and JScript,
ASP.NET now supports more than 25 .NET-based languages—including built-in
support for Visual Basic .NET, C#, and JScript .NET giving developers flexibility in
their choice of language.
Enhanced Development Environment. Developers can harness the full power of
ASP.NET by using any text editor—even Notepad. However, Visual Studio .NET
adds the productivity of Visual Basic–style development to the Web. Now developers
can visually design ASP.NET Web Forms by using familiar drag-and-drop and
double-click techniques. Developers can also enjoy full code support, including
statement completion and color coding. Visual Studio .NET also provides integrated
support for debugging and deploying ASP.NET Web applications.
Improved Performance. The separation of code and content enables ASP.NET pages
to be dynamically compiled into managed classes for fast performance. Each incoming
HTTP request is delivered to a new page instance so that developers need not be
concerned about thread safety in their code.
Easier, Faster Deployment. ASP.NET uses the Microsoft .NET Framework
deployment model based on assemblies, and as a result benefits from features such as
xcopy deployment, side-by-side deployment of assemblies, and XML-based
configuration. ASP.NET also supports the deployment of a fully compiled application.
30
The benefit is that none of the source code is visible to the administrator of the Web
server, an important feature if another company hosts the application.
ASP.NET has an extremely simple deployment model, and to deploy an application, you just
copy all of the files that comprise the application into the appropriate directory. No
registration of objects or restarting of the application is required. All parts of an ASP.NET
application can be deployed in this fashion, including pages, XML Web Services, compiled
components (contained within DLLs), and even configuration data.
For tasks such as populating a list box after a post back, MS Contract database hits have been
cut by 30 percent with almost no coding effort on the part of developers.
ASP.NET moves the concept of traditional ASP application programming to the next level. A
Web site or Web application within a site can contain both ASP.NET pages and ASP pages.
Because both ASP and ASP.NET pages can be accessed from the same Web server, you are
not required to port your existing ASP pages over to ASP.NET-compatible pages. However,
Microsoft tests have shown that ASP.NET applications can handle two to three times the
requests per second as classic ASP applications.
New features like server controls and event handling in ASP.NET help developers build
applications more rapidly and in fewer lines of code. It is also easier than ever to separate
code from HTML content.
Technology Requirements
The ASP.NET model assumes stateless service architecture. Stateless architectures are
generally more scalable than state-full architectures. XML Web services can use the
ASP.NET state management services if they need to maintain state across requests. XML
Web services based on ASP.NET are managed applications executed by the common
language runtime, and so benefit from all the features of the common language runtime
and .NET Framework discussed earlier. Alternatively, you can have .NET managed code that
runs on the common language runtime without using ASP.NET at all.
C# (C Sharp)
C# (pronounced “C sharp”) is a simple, modern, object-oriented, and type-safe language that
enables programmers to quickly and easily build solutions for the .NET platform.
30
Benefits
Code Reuse. Components designed using C# can be easily converted into XML Web
Services, which can be invoked across the internet, from any language running on any
operating system.
Enhanced Performance. Garbage collection – No manual memory management.
Enhanced Reliability. Variables are automatically initialized and are type-safe.
Improved Developer Productivity. Versioning and scalability support.
Faster Time to Market. Better mapping between business process and
implementation – Developers can define domain-specific attributes and apply them to
any language element classes, interfaces etc. Once defined, the attributes of each
element can be programmatically examined.
Extensive Interoperability. Native support for COM and Windows-API.
C# was a critical part of the success Consensus 3.0—a Web-based application that allows
Microsoft users or groups to easily create, distribute, and manage electronic surveys in order
to obtain valuable feedback.
Using C# reduced the development and testing time without losing the object-oriented
approach. For this project, the C# language seemed to be the best fit for application design; in
fact, because of the support from the .NET Framework for core programming tasks, the team
found that using C# became easier than using Visual Basic.
Benefits Of SQL Server 2005
Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis
software that enables organizations to reliably manage mission-critical information and
confidently run today’s increasingly complex business applications. SQL Server 2005 allows
companies to gain greater insight from their business information and achieve faster results
for a competitive advantage.
SQL Server 2005 Features at a Glance
The following table provides an overview of several key enhancements in SQL Server 2005,
focusing on enterprise data management, developer productivity, and business intelligence. A
wider range of compared features is available at the SQL Server Developer Center.
30
High Availability
Failover clustering and database mirroring technology in SQL Server 2005 enables enterprises
to deliver highly reliable, available applications to employees, customers, and partners.
Management Tools
SQL Server 2005 introduces an integrated suite of management tools and management
application programming interfaces (APIs) to provide ease of use, manageability, and support
for operating large-scale SQL Server deployments.
Security Enhancements
SQL Server 2005 has been designed to help provide the highest level of security for enterprise
data through features such as database encryption, more secure default settings, password
policy enforcement, granular permissions control, and an enhanced security model.
Scalability
Scalability advancements in SQL Server 2005 include table partitioning, replication
enhancements, and 64-bit support.
Developer Productivity
Common Language Runtime (CLR) Integration
SQL Server 2005 introduces the capability to develop database objects using any
Microsoft .NET language.
Deep XML Integration
SQL Server 2005 delivers a new XML data type, enabling the storage of XML fragments or
documents in SQL Server databases.
Transact-SQL Enhancements
New query types and the capability to use error handling in transactions provide developers
with more flexibility and control in SQL Server query development.
30
SQL Server 2005 Compact Edition
Full integration of SQL Server 2005 Compact Edition with SQL Server 2005 and Visual
Studio 2005 provides a platform for developers to rapidly build applications that extend
enterprise data management capabilities to mobile devices.
Business Intelligence
Analysis Services
Analysis Services provides a unified and integrated view of all your business data as the
foundation for all of your traditional reporting, OLAP analysis, Key Performance Indicator
(KPI) scorecards and data mining.
Integration Services
SQL Server Integration Services (SSIS) is a next generation data integration platform that can
integrate data from any source. SSIS provides a scalable and extensible platform that
empowers development teams to build, manage, and deploy integration solutions to meet
unique integration needs.
Reporting Services
SQL Server Reporting Services is a comprehensive, server-based reporting solution designed
to help you author, manage, and deliver both paper-based and interactive Web-based reports.
Data Mining
SQL Server 2005 Analysis Services (SSAS) provides tools for data mining with which you
can identify rules and patterns in your data, so that you can determine why things happen and
predict.
ABOUT WINDOWS XP PROFESSIONAL
Windows XP Professional has many features that will make using the Computer easy,
effective and entertaining. For instance, you can use Remote Desktop to access your work
computer and its resources from home and to view files and documents on the computer’s
desktop from a co-workers computer.
30
Windows XP Professional extensive online help is for all OS as well as a digital tour to help
you discover the possibilities awaiting you. There are tools that can used to get the most out
of the computer experience and other technology that run in the background making the
computer run more efficiently and reliably With Windows XP Professional, you can work
with your files and folders more efficiently.
You can perform tasks with a more intuitive Web page interface, and view file and folder
details in new and helpful ways. There are more options to associate certain file types with
specific programs and working files and folders offline has never been easier. Folders and
files are compressed quickly and easily, so they take up less space on the computer.
Windows XP Professional combines a bright, fresh new look with a simple-to-use design.
The desktop and taskbar are less cluttered. The Start menu provides easier access to the
programs. There are more options for customizing desktop environment.
Windows XP Professional offers many new and more effective features and technologies.
Remote Desktop allows accessing Windows session from another computer, just as if you
were in front of your computer. Features like Windows File Protection and System Restore
will keep from accidentally deleting important files and will return computer to its previous
state if something goes wrong. If a system or program error is encountered, a report can be
send to Microsoft and NetMeeting can be used for virtual meeting with anyone, anywhere .If
a flat computer screen is in use, then you can choose to display screen fonts with Clear Type,
the latest breakthrough technology in font clarity from Microsoft. The Dual View features
enables to use a separate monitor with the laptop computer.
With Windows XP Professional home networking was never been easier. The Network Setup
Wizard can be used to quickly setup own network. You can share your Internet connection
with all the computers on your network, and feel comfortable knowing your computer is
protected by an Internet Connection Firewall.
Windows XP Professional makes it easy to set up and manage computer accounts for
everyone who uses your computer. Now multiple users can switch between accounts without
having to restart the computer. Help is provided for remembering forgotten password, store
multiple and protect copy of Windows XP Professional against piracy.
Windows XP Professional includes the newest version of MSN Explorer, with its full package
of Micros of services and the most recent release of Internet Explorer.
30
About Internet Information Services (IIS)
Internet Information Services (IIS) is the Windows component that makes it easy to publish
information and bring business applications to the Web. IIS makes it easy for you to create a
strong platform for network applications and communications.
Internet Information Services 5.1 has many features to help Web administrators to create
scalable, flexible Web applications.
Security
Administration
Programmability
Internet Standards
Microsoft Internet Information Services 5.0 and 5.1 comply with the HTTP 1.1 standard,
including features such as PUT and DELETE, the ability to customize HTTP error messages,
and support for custom HTTP headers.
IIS 5.1 offers greater protection and increased reliability for your Web applications. By
default, IIS runs all of your applications in a common or pooled process that is separate from
core IIS processes.
In IIS 5.1, administrators and application developers have the ability to add custom objects,
properties, and methods to the existing ADSI provider, giving administrators even more
flexibility in configuring their sites
Internet Information Services (IIS) makes it easy for you to publish information on the
Internet or your intranet. IIS includes a broad range of administrative features for managing
Web sites and your Web Server. With programmatic features like Active Server Pages (ASP),
you can create and deploy scalable, flexible Web applications.
30
5. LOGICAL DESIGN
0 Level DFD 1 Level DFD ERD
30
Level-0 DFD
Output Result
TnPMS
System
User/TPO
TPO
Result/Information
Input data
Input data
Result/
Information
User
30
Level -1 DFD
Modify Data
Access Data
Fetch Data
Input data
User
TPO
Information
User/TPO
Fetch Data
Data Base
Input Data
TnPMS System
Update/Delete/Insert
Input data
30
(1,N)
(N,1)
(M,N) (1,N)
(M,N) (N,1)
ER-DIAGRAM
STUDENT
TPOMODIFY
USER NAME
PASSWORD
E.NO.
%12
BRANCH
CGPA
NAME
%10
F.NAME
ADDRESS
P.NO.
COMPANY
REGIS-TERED
PLACED
DOP
MIN. QUAL
PACKAGE
NAME
30
6. PHYSICAL DESIGN
Form Layout Design View Codes
30
FORM LAYOUT
30
30
30
30
30
30
30
30
30
30
30
30
30
30
30
DESIGN VIEW
30
30
30
30
30
30
30
CODES
ABOUT US
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="aboutus.aspx.cs" Inherits="Default2" Title="AboutUs" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> <br /> <asp:Image ID="Image2" runat="server" Height="186px" ImageUrl="~/Images/corporate.jpg" Width="288px" ImageAlign="Right" style="margin-left: 0px" /> Department of training and placement cell is an integral part of the organisation where the Placement is the ultimate goal, the desired destination and the fulfilment of the dream of the aspirant student, the faculty and the Management who make frantic endeavours in carving out and crafting the students’ career. Training and Placement Cell is the nerve-centre of the Department of Computer Science and advance planning begins to see each student well placed in public or private sector.<p align="justify">The training and placement cell's team is active,concern ,wide awake and enthusiastic for the placement of its student which is headed by Mr. E.R.Khan, Mr. S.Tanweer & Mr. J.Ahamd (Training and Placement Coordinator) ,offer full assistance and support to the student in their search for the suitable placement.</p> <p align="justyfy"> With our dedicated direct or indirect effort ,our students of pass out batches have been suitably placed to the outmost satisfaction. Our students hold dignified positions in prestigious national and multinational companies like L&T,TCS,Wipro,Newgen,Headstrong,Vodafone,Infosys,Fiserv,Aricent and CSC are few to name. Campus interviews for the Final Year students of various Courses are held with admirable frequency</p> <p align="justify">The Training & Placement cell is highly ambitious, hopeful and optimistic about the future placement scenario of the organisation. Our brilliant student, well-equipped with sound knowledge of the concerned field, excellent communication skills and grooming in the working of the Corporate culture, are proving our brand ambassadors. They have set precedents and paved path for others to follow their foot steps.</p> <p>ALL THE BEST TO OUR AMBASSADORS !!!</p> </p> </asp:Content>
30
ADMIN<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Admin.aspx.cs" Inherits="Default2" Title="Admin" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> <center><h1>Welcome Administrator</h1></center></p> <p> <center>Select courses for Placement Modification for Department of Computer Science</center> </p> <p> <center><asp:DropDownList ID="DropDownList1" runat="server" Height="22px" onselectedindexchanged="DropDownList1_SelectedIndexChanged" Width="147px"> </asp:DropDownList> </center></p> <p> <center><asp:Button ID="Button1" runat="server" Text="Click Here" onclick="Button1_Click" /> </center> </p></asp:Content>
CONTACT US
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="contactus.aspx.cs" Inherits="Default2" Title="Contact Us" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <style type="text/css"> .style11 { width: 637px; } </style></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> <table><tr><td class="style11">
30
<p><center><h1>Contact Us</h1></center><br /><strong>JAMIA HAMDARD</strong><br />(Hamdard University)<br />Hamdard Nagar<br />New Delhi - 110 062 (India)<br />Phone : 011-26059688 Fax: 011-26059663<br />E-mail :<font class="Apple-style-span" color="#800000"> [email protected]</font> <br /></p>
</td></tr></table> </p> </asp:Content>
NEWS
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="aboutus.aspx.cs" Inherits="Default2" Title="News" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <marquee><p><font size="5" face="Times"color="#CC3300">Do Visit Regularly for Updates</font></p></marquee>
<marquee onmouseover="this.stop()" onmouseout="this.start()" scrollamount="2" scrolldelay="0" direction="left" height="400" bgcolor="transparent" behaviour="scroll"> <table cellspacing="0" cellpadding="0" width="700" > <tr><td style="vertical-align:middle"> <span id="lblEvents"> <a href='News Flash/NOTICE .pdf' class='linksmarquee'><P><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> General Notice</P></a> <a href='News Flash/Recruitment.pdf' class='linksmarquee'> <IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Off Campus Recruitment for Final Year Student
30
</a><br><br><a href='News Flash/offcampus.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Off Campus Recruitment updated schedule for MICROSOFT</a><br><br><a href='News Flash/Visiting company.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Visiting company & its criteria</a><br><br><a href='Schedule for GD.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Schedule for Group Discussion & Pesonality Development</a><br><br><a href='Result of aptitude.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Result of aptitude test conducted by Infosys</a><br><br><a href='News Flash/Result of aptitude.pdf' class='linksmarquee'> <IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Notice For Final Year Student</a><br><br><a href='News Flash/Schedule for GD.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Special Coaching Classes</a><br><br>
</table></marquee> </asp:Content>
GUIDELINES
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Guidlines.aspx.cs" Inherits="Default2" Title="Guidelines" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" runat="server" contentplaceholderid="ContentPlaceHolder1"> <br /> <br /> <p> <center><h1>Study material/guidelines for student</h1></center> </p> <br /> <br />
30
<br /> <p align="left" style="height: 30px; font-size: large;"> <a href='News%20Flash/ibm%20paper[www.PlacementPapers.net].doc' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> Question paper of various company</a> </p> <p align="left" style="height: 30px; font-size: large;"> <a href='News%20Flash/DotnetInterview.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> .NET Interview questions</a> </p> <p align="left" style="height: 30px; font-size: large;"> <a href='News%20Flash/DotnetInterview.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> JAVA Interview Questions</a> </p> <p align="left" style="height: 30px; font-size: large;"> <a href='News%20Flash/IBMPAPER[www.PlacementPapers.net].DOC' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> HR Interview Tips</a> </p> <p align="left" style="height: 30px; font-size: large;"> <a href='News%20Flash/cs2000.pdf' class='linksmarquee'><IMG style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" alt=New src="Images\new.gif"> DO'S and DON'TS during Interview</a> <br /> <br />
</asp:Content>
PLACEMENT
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Placement.aspx.cs" Inherits="Default2" Title="Placement" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> <center><h1>Welcome to placement page</h1></center> </p> <p> <center>Select Courses to see the placed student of Department of Computer Science.</center>
30
</p> <p> <center><asp:DropDownList ID="DropDownList1" runat="server" Height="23px" onselectedindexchanged="DropDownList1_SelectedIndexChanged" style="margin-left: 0px" Width="147px"> </asp:DropDownList></center> </p> <p> <CENTER><asp:Button ID="Button1" runat="server" Text="Click here" onclick="Button1_Click" /></CENTER> </p></asp:Content>
RESUME<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="resume.aspx.cs" Inherits="Default2" Title="Resumeupload" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> <center><h1>Upload Your Resume</h1></center> </p> <p> <center><asp:FileUpload ID="FileUpload1" runat="server" /></center> </p> <p> <center> <asp:Button ID="Button1" runat="server" Text="Submit" /></center> </p></asp:Content>
LOGIN<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="Default3" Title="Login" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <style type="text/css"> .style14 { width: 196px; }</style> </asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
30
<br /> <p align="center"> <center> <h1>Welcome to LogIn Page</h1> </center> <center><h3>Only member can login</h3> <p> </p></center> <table class="style7" style="width: 71%; margin-left: 55px"> <tr> <td class="style14"> <center> UserName </center></td> <td> <asp:TextBox ID="TextBox1" runat="server" Width="150px"></asp:TextBox> </td> </tr> <tr> <td class="style14"> <center> Password</center></td> <td> <asp:TextBox ID="TextBox2" runat="server" Width="150px" TextMode="Password"></asp:TextBox> </td> </tr> <tr> <td class="style14"> </td> <td> <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="LogIn" /> </td> </tr> </table> </p> </asp:Content>
30
7. TESTING
System Testing Level of Testing Testing in TnPMS
30
TESTING
SYSTEM TESTING
Software is only element in the whole system and so it is necessary to check whether, the
application will work after the implementation or not. The available hardware, operating
system, environment will match with the application or not. Advisor, Client, Enquirer,
Company will accept it or not. And so for this purpose, application is installed on the
machine, database of the server, gives complete description about it to all relative persons.
After this, performance of the application is checked on the given environment.
Result are checked, different types of securities taken in the application and for the database
is checked. After this the project is complete and ready for work.
LEVEL OF TESTING
The basic levels are unit testing, system and acceptance testing. These different level attempts
to detect different types of faults. The relation of faults introduced in different phases and
different level of testing are shown below.
Clint Need Acceptance Testing
Requirements System Testing
Design Integration Testing
Code Unit Testing
Testing the TnPMS web application
After developing the software, whole software has been tested. Unit Testing method has been used to test the software. In Unit Testing, individual units of source code are tested to determine if they are fit for use. A unit is the smallest testable part of an application.
30
In the process of testing all the errors have been removed, which are found, although they haven’t any impact on the functioning of the software. But due to user convenience all the errors, which may create some confusions for the uses, have been removed and the software is working properly.
30
8. CONCLUSION
Result Advantages Limitation Further Enhancement
30
CONCLUSION
In this study it can be concluded that the main aim of the project is to provide the Interaction
between the Training and the Placement cell and the student on web and reduce the effort and
the human error, user the instant liquidity in finding and dealing with data. It also saves time
of students as well as TnP cell.
RESULT
After we have completed the project we are sure the problems in the existing system would
overcome. The “Training and Placement Management System” made training and
placement cell computerized to reduce human errors and to increase the efficiency. The main
focus of this project is to lessen human efforts. The maintenance of the records is made
efficient, as all the records are stored in the database, through which data can be retrieved
easily. The TPO is given a particular unique id. and password so that they can be accessed
correctly and without errors and can make the changes as required. The main purpose of
TnPMS is to save time and increase efficiency of T n P cell and make the student and T n P
cell interactive.
The problems, which existed in the earlier system, have been removed to a large extent. And
it is expected that this project will go a long way in satisfying students and the T n P cell
requirements.It not only improves the efficiency but will also reduce human stress.
ADVANTAGES OF TnPMS
1. TnPMS is designed to automate the functionality of Training and Placement cell.
2. The TnPMS is a user-friendly system and even a non-technical person can also operate
it easily.
3. TnPMS is a fast, accurate and efficient s/w that provide satisfaction to its users.
LIMITATION
1. System operates only when the internet connection is available.
FUTURE SCOPE & FURTHER ENHANCEMENTS
1. System can be used in another organization also for their Training and Placement Cell.
30
2. TPO power could be enhanced in which he can directly inform the student via email
directly to the student registered.
30
9. REFERENCES
Books Websites
30
REFERENCES
BOOKS
1. Beginning Visual C# 2005 by Wrox publication.
2. C# Professional By Wrox Publications
3. Asp.NET
4. Professional ASP.NET 3.5 in C# and VB By Wrox Publication.
WEBSITES
1. Google.com
2. Answers.com
3. Codeguru.com