CONFERENCE MANAGEMENT SYSTEM PROJECT REPORT
PROJECT SOURCE CODE
‘Organizational
Conference’ is a web application used to conduct conference among employees of
multiple branches of same Organization.
It provides facility for
recruitment of employees required in the Organization.
PURPOSE OF THE PROJECT - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
To conduct discussions among employees who are working under a same
company but under
Different branches. They can do
online discussions as well as offline discussions and to get
Reports on discussions happened on required
topic
EXISTING SYSTEM & DISADVANTAGES
These days lots of organizations are arranging conferences to their
employees manually, Which takes them to stop their works and commit their time
in meeting room to discuss their problems and new assignments .So, to avoid
this problem we are going to introduce an online Conference to provide
communication between employees
PROPOSED SYSTEM & ADVANTAGES
This
web application is designed and developed to conduct conference among the
employees to solve their problems arises in the working time or to take
decisions regarding facing new situations etc., it also provides a facility to
recruit employees when ever the requirement arises in the Organization
SYSTEM ANALYSIS
FEASIBILITY STUDY - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
Preliminary
investigation examines project feasibility, the likelihood the system will be
useful to the organization. The main objective of the feasibility study is to
test the Technical, Operational and Economical feasibility for adding new
modules and debugging old running system. All systems are feasible if they are
given unlimited resources and infinite time. There are aspects in the
feasibility study portion of the preliminary investigation:
- Technical Feasibility
- Operation Feasibility
Economical Feasibility
TECHNICAL FEASIBILITY
The technical
issue usually raised during the feasibility stage of the investigation includes
the following:
- Does the necessary technology exist to do what is
suggested?
- Do the proposed equipments have the technical capacity
to hold the data required to use the new system?
- Will the proposed system provide adequate response to
inquiries, regardless of the number or location of users?
- Can the system be upgraded if developed?
Are there technical guarantees of
accuracy, reliability, ease of access and data security?
OPERATIONAL FEASIBILITY
OPERATIONAL
FEASIBILITY
User-friendly
Customer will use the forms for their various transactions i.e. for
adding new routes, viewing the routes details. Also the Customer wants the
reports to view the various transactions based on the constraints. Theses forms
and reports are generated as user-friendly to the Client.
Reliability
The package wills pick-up current transactions on line. Regarding the old
transactions, User will enter them in to the system.
Security
The web server and database server should be protected from hacking,
virus etc
Portability
The application will be developed using standard open source software
(Except Oracle) like Java, tomcat web server, Internet Explorer Browser etc
these software will work both on Windows and Linux o/s. Hence portability problems will not arise.
Availability
This software will be available
always.
Maintainability
The
system called the ewheelz uses the 2-tier architecture. The 1st tier is the
GUI, which is said to be front-end and the 2nd tier is the database, which uses
My-Sql, which is the back-end.
The front-end can be run on different systems
(clients). The database will be running at the server. Users access these forms
by using the user-ids and the passwords.
ECONOMIC FEASIBILITY
The
computerized system takes care of the present existing system’s data flow and
procedures completely and should generate all the reports of the manual system
besides a host of other management reports.
It should be
built as a web based application with separate web server and database server.
This is required as the activities are spread through out the organization
customer wants a centralized database. Further some of the linked transactions
take place in different locations.
Open source software like TOMCAT, JAVA,
Mysql and Linux is used to minimize the cost for the Customer.
EXISTING SYSTEM & DISADVANTAGES
These days lots of organizations are arranging conferences to their
employees manually, Which takes them to stop their works and commit their time
in meeting room to discuss their problems and new assignments .So, to avoid
this problem we are going to introduce an online Conference to provide
communication between employees
PROPOSED SYSTEM & ADVANTAGES - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
This
web application is designed and developed to conduct conference among the
employees to solve their problems arises in the working time or to take
decisions regarding facing new situations etc., it also provides a facility to recruit
employees when ever the requirement arises in the Organization
SYSTEM REQUIREMENT SPECIFICATION
OPERATING ENVIRONMENT - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
Performance is
measured in terms of the output provided by the application. Requirement
specification plays an important part in the analysis of a system. Only when
the requirement specifications are properly given, it is possible to design a
system, which will fit into required environment. It rests largely with the
users of the existing system to give the requirement specifications because
they are the people who finally use the system.
This is because the requirements have to be known during the initial
stages so that the system can be designed according to those requirements. It is very difficult to change the system
once it has been designed and on the other hand designing a system, which does
not cater to the requirements of the user, is of no use.
The
requirement specification for any system can be broadly stated as given
below:
·
The system should be able
to interface with the existing system
·
The system should be
accurate
·
The system should be better
than the existing system
The existing system is completely
dependent on the user to perform all the duties.
To
provide flexibility to the users, the interfaces have been developed that are
accessible through a browser. The GUI’S at the top level have been categorized
as
- Administrative user
interface
- The operational or
generic user interface
The
‘administrative user interface’ concentrates on the consistent information that
is practically, part of the organizational activities and which needs proper
authentication for the data collection. These interfaces help the
administrators with all the transactional states like Data insertion, Data
deletion and Date updation along with the extensive data search capabilities.
The ‘operational
or generic user interface’ helps the end users of the system in transactions
through the existing data and required services. The operational user interface
also helps the ordinary users in managing their own information in a customized
manner as per the included flexibilities
INPUT & OUTPUT REPRESENTATION
Input design is
a part of overall system design. The
main objective during the input design is as given below:
·
To produce a cost-effective
method of input.
·
To achieve the highest
possible level of accuracy.
·
To ensure that the input is
acceptable and understood by the user.
INPUT STAGES:
The
main input stages can be listed as below:
·
Data recording
·
Data transcription
·
Data conversion
·
Data verification
·
Data control
·
Data transmission
·
Data validation
·
Data correction
INPUT TYPES:
It is necessary
to determine the various types of inputs.
Inputs can be categorized as follows:
·
External inputs, which are
prime inputs for the system.
·
Internal inputs, which are
user communications with the system.
·
Operational, which are
computer department’s communications to the system?
·
Interactive, which are
inputs entered during a dialogue.
INPUT MEDIA:
At
this stage choice has to be made about the input media. To conclude about the input media
consideration has to be given to;
·
Type of input
·
Flexibility of format
·
Speed
·
Accuracy
·
Verification methods
·
Rejection rates
·
Ease of correction
·
Storage and handling requirements
·
Security
·
Easy to use
·
Portability
Keeping in view
the above description of the input types and input media, it can be said that
most of the inputs are of the form of internal and interactive. As
Input data is to
be the directly keyed in by the user, the keyboard can be considered to be the
most suitable input device.
OUTPUT DESIGN:
in general are:
- External Outputs whose destination is outside the
organization.
- Internal Outputs whose destination is with in
organization and they are the User’s main interface with the computer.
Outputs from computer systems are required primarily to communicate the
results of processing to users. They are also used to provide a permanent
copy of the results for later consultation. The various types of outputs
- Operational outputs whose use is purely with in the
computer department.
- Interface outputs, which involve the user in
communicating directly with the system.
SOFTWARE REQUIREMENTS:
Operating System : Windows
Technology : Java/j2ee (JDBC, Servlets, JSP)
Web Technologies : Html, JavaScript, CSS
Web Server :
Tomcat
Database :
Oracle
Software’s : J2SDK1.5, Tomcat 5.5, Oracle 9i
HARDWARE
REQUIREMENTS:
Hardware
requirements:
Hardware : Pentium based systems with a minimum of P4
RAM : 256MB (minimum)
Additional Tools:
HTML Designing : Dream weaver Tool
Development Tool kit : My
Eclipse
INTRODUCTION TO JAVA
About Java:
Initially the language
was called as “oak” but it was renamed as “java” in 1995.The primary motivation
of this language was the need for a platform-independent(i.e. architecture
neutral)language that could be used to create software to be embedded in
various consumer electronic devices.
Java is a programmer’s language
Java is cohesive and consistent
Except for those constraint imposed by the Internet environment.
Java gives the programmer, full control
Finally Java is to Internet Programming where c was to System
Programming.
Importance of Java to the Internet
Java has had a profound effect on the Internet. This is because; java
expands the Universe of objects that can move about freely in Cyberspace. In a
network, two categories of objects are transmitted between the server and the
personal computer. They are passive information and Dynamic active programs. in the areas of Security
and probability. But Java addresses these concerns and by doing so, has opened
the door to an exciting new form of program called the Applet.
Applications and applets. An application is a
program that runs on our Computer under the operating system of that computer.
It is more or less like one creating using C or C++ .Java’s ability to create
Applets makes it important. An Applet I san application, designed to be
transmitted over the Internet and executed by a Java-compatible web browser. An
applet I actually a tiny Java program, dynamically downloaded across the
network, just like an image. But the difference is, it is an intelligent
program, not just a media file. It can be react to the user input and
dynamically change.
Servlets/JSP
INTRODUCTION
A Servlet Is a generic server
extension. a Java class that can be loaded
Dynamically to expand the functionality of a server.Servlets are commonly
used with web servers. Where they can take the place CGI scripts.
A servlet is similar to proprietary server extension, except that it runs
inside a Java Virtual Machine (JVM) on the server, so it is safe and portable
Servlets operate solely within the domain of the server.
Unlike CGI and Fast CGI, which use multiple processes to handle separate
program or separate requests, separate threads within web server process handle
all servlets. This means that servlets are all efficient and scalable.
Servlets are portable; both across operating systems and also across web servers. Java Servlets offer
the best possible platform for web application development.
Servlets are used as replacement for
CGI scripts on a web server, they can extend any sort of server such as
a mail server that allows servelts t extend its functionality perhaps by
performing a virus scan on all attached documents or handling mail filtering
tasks.
Servlets provide a Java-based solution used to address the problems
currently associated with doing server-side programming including inextensible
scripting solutions platform-specific API’s and incomplete interface.
Servlets are objects that conform to a specific interface that can be
plugged into a Java-based server.Servlets are to the server-side what applets
are to the server-side what applets are to the client-side-object byte codes
that can be dynamically loaded off the net. They differ form applets in than
they are faceless objects(with out graphics or a GUI component).They serve as
platform independent, dynamically loadable,plugable helper byte code objects on
the server side that can be used to dynamically extend server-side
functionality.
For example an HTTP servlet
can be used to generate dynamic HTML content when you use servlets to do
dynamic content you get the following advantages:
They’re faster and cleaner then CGI scripts
They use a standard API( the servlet API)
They provide all the advantages of Java (run on a variety of servers without needing to be rewritten)
A t t r a c t i v e n e s s o f S
e r v l e t s:
They are many features of
servlets that make them easy and attractive to tuse these include:
Easily configure using the
GUI-based Admin tool]
Can be Loaded and Invoked from a local disk or remotely across
the network.
Can be linked together or chained, so that on servlet can call
another servlet, or several servlets in sequence.
Can be called dynamically from with in HTML, pages using
server-side include-tags.
Are secure-even when downloading across the network, the servlet
security model and servlet and box protect your system from unfriendly
behavior.,
Advantages of the servlet API
One of the great advantages of
the servlet API is protocol independent. It assumes nothing about:
The protocol being used to transmit on the net
How it is loaded
The server environment it will be running in
These quantities are important, because it allows the Servlet
API to be embedded in many different kinds of servers.There are other
advantages to the servelt API as well These include:
It’s extensible-you can inherit all your functionality from the
base classes made available to you
It’s simple small, and easy to use.
Features of Servlets:
Servlets are persistent.Servlet are loaded only by the web
server and can maintain services between requests.
Servlets are fast. Since servlets only need to be l\loaded once,
they offer much better performance over their CGI counterparts.
Servlets are platform independent.
Servlets are extensible Java is a robust, object-oriented
programming language, which easily can be extended to suit your needs.
Servlets are secure
Servlets are used with a variety of client.
Servlets are classes and interfaces from tow packages,javax .servlet and
javax.servlet.http.The java.servlet package contains classes t support generic,
protocol-independent servlets.The classes in the javax.servelt.http package To
and HTTP specific functionality extend these classes
Every servlet must implement the javax.servelt interface.Most servlets
implement it by extending one of two classes.javax.servlet.GenericServlet or
javax.servlet.http.HttpServlet.A protocol-independent servlet should subclass
Generic-Servlet.while an Http servlet should subclass HttpServlet, which is
itself a subclass of Generic-servlet with added HTTP-specific functionality.
Unlike a java program, a servlet does not have a main() method,Instead
the server in the process of handling requests invoke certain methods of a
servlet.Each time the server dispatches a request to a servlet, it invokes the
servelts Service() method,
A generic servlet should override its service() method to handle requests
as appropriate for the servlet.The service() accepts two parameters a request
object and a response object .The request object tells the servlet about the
request, while the response object is used to return a response
InContrast.anHttp servlet usually does not override the service()
method.Instead it overrides doGet() to handle GET requests and doPost() to
handle Post requests. An Http servlet can override either or both of these
modules the service() method of HttpServlet
handles the setup and dispatching to all the doXXX() methods.which iswhy it
usually should not be overridden
The remainders in the javax.servlet and javax.servlet.http.package are
largely support classes .The ServletRequest and ServletResponse classes in
javax.servlet provide access to generic server requests and responses while
HttpServletRequest and HttpServletResponse classes in javax.servlet provide
access to generic server requests and responses while HttpServletRequest and
HttpServletResponse in javax.servlet.http provide access a HTTP requests and
responses . The javax.servlet.http provide contains an HttpSession class that
provides built-in session tracking functionality and Cookie class that allows
quickly setup and processing HttpCookies.
Loading Servlets:
Servlets can be loaded from their places. From a directory that is on the
CLASSPATH. The CLASSPATH of the JavaWebServer includes service root/classes/,
which is where the system classes reside
From the
Loading Remote Servlets
Remote servlets can be loaded by:
Configuring the admin Tool to setup automatic loading of remote
servlets.
Selectiong up server side include tags in .html files
Defining a filter chain Configuration
JDBC
What is JDBC?
any relational database. One can write a single program using the JDBC
API,and the JDBC is a Java Api for executing SQL,Statements(As a point of
interest JDBC is trademarked name and is not an acronym; nevertheless,Jdbc is
often thought of as standing for Java Database Connectivity. It consists of a
set of classes and interfaces written in the Java Programming language.JDBC
provides a standard API for tool/database developers and makes it possible to
write database applications using a pure Java API
Using JDBC, it is easy to send SQL statements to virtually program will
be able to send SQL .statements to the appropriate database. The Combination of
Java and JDBC lets a programmer writes it once and run it anywhere.
What
Does JDBC Do?
Simply put,JDBC makes it possible to do
three things
o Establish a connection with a database
o Send SQL statements
o Process the results
o
JDBC Driver Types
o
The JDBC drivers that we
are aware of this time fit into one of four categories
o
JDBC-ODBC Bridge
plus ODBC driver
o
Native-API party-java
driver
o
JDBC-Net pure java driver
o
Native-protocol pure Java
driver
An
individual database system is accessed via a specific JDBC driver that
implements the java.sql.Driver interface. Drivers exist for nearly all-popular
RDBMS systems, through few are available for free. Sun bundles a free JDBC-ODBC
bridge driver with the JDK to allow access to a standard ODBC,data sources,
such as a Microsoft Access database, Sun advises against using the bridge
driver for anything other than development and very limited development.
JDBC drivers are available
for most database platforms, from a number of vendors and in a number of
different flavours. There are four driver categories
Type 01-JDBC-ODBC
Bridge Driver
Type 01 drivers use a bridge
technology to connect a java client to an ODBC database service. Sun’s
JDBC-ODBC bridge is the most common type 01 driver. These drivers implemented
using native code.
Type 02-Native-API
party-java Driver
Type 02 drivers wrap a thin
layer of java around database-specific native code libraries for Oracle
databases, the native code libraries might be based on the OCI(Oracle call
Interface) libraries, which were originally designed for c/c++
programmers, Because type-02 drivers are implemented using native code. in some
cases they have better performance than their all-java counter parts. They add
an element of risk, however, because a defect in a driver’s native code section
can crash the entire server
Type 03-Net-Protocol All-Java Driver
Type 03 drivers communicate via a generic network protocol to
a piece of custom middleware. The middleware component might use any type of
driver to provide the actual database access. These drivers are all java, which
makes them useful for applet deployment and safe for servlet deployment
Type-04-native-protocol All-java
Driver
Type o4 drivers are the most direct of the lot. Written
entirely in java, Type 04 drivers understand database-specific networking.
protocols and can access the database directly without any additional software
Oracle (Access)
Oracle is a
relational database management system, which organizes data in the form of
tables. Oracle is one of many database servers based on RDBMS model, which
manages a seer of data that attends three specific things-data structures, data
integrity and data manipulation.
With
oracle cooperative server technology we can realize the benefits of open,
relational systems for all the applications. Oracle makes efficient use of all
systems resources, on all hardware architecture; to deliver unmatched
performance, price performance and scalability. Any DBMS to be called as RDBMS
has to satisfy Dr.E.F.Codd’s rules.
JAVA SCRIPT - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
The Java Script Language
JavaScript is a compact, object-based scripting language for developing
client and server internet applications. Netscape Navigator 2.0 interprets
JavaScript statements embedded directly in an HTML page. and Livewire enables
you to create server-based applications similar to common gateway
interface(cgi) programs.
In a client application for Navigator, JavaScript statements embedded in
an HTML Page can recognize and respond to user events such as mouse clicks form
Input, and page navigation.
For example, you can write a JavaScript function to verify that users
enter valid information into a form requesting a telephone number or zip code .
Without any network transmission, an Html page with embedded Java Script can
interpret the entered text and alert the user with a message dialog if the
input is invalid or you can use JavaScript to perform an action (such as play
an audio file, execute an applet, or communicate with a plug-in) in response to
the user opening or exiting a page.
HTML - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
Hypertext Markup Language (HTML), the
languages of the world wide web(WWW), allows users to produces web pages that
included text, graphics and pointer to other web pages (Hyperlinks).
HTML is not a programming language but it is an application of ISO
Standard 8879,SGML(Standard Generalized Markup Language),but
Specialized to hypertext and adapted to the Web. The idea behind
Hypertext one point to another point. We can navigate through the information based
on out interest and preference. A markup language is simply a series of items
enclosed within the elements should be displayed.
Hyperlinks are underlined or emphasized works that load to other
documents or some portions of the same document.
Html can be used to display any type of document on the host computer,
which can be geographically at a different location. It is a versatile language
and can be used on any platform or desktop
HTML provides tags(special codes) to make the document look attractive.
HTML provides are not case-sensitive. Using graphics,fonts,different
sizes, color, etc.. can enhance the presentation of the document. Anything
That is not a tag is part of the document it self.
SYSTEM DESIGN - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
Introduction: Systems design is the process or art of defining the
architecture, components, modules, interfaces, and data for a system to satisfy
specified requirements. One could see it as the application of systems theory
to product development. There is some overlap and synergy with the disciplines
of systems analysis, systems architecture and systems engineering.
Architecture flow:
Below
architecture diagram represents mainly flow of requests from users to database
through servers. In this scenario overall system is designed in three tires
separately using three layers called presentation layer, business logic layer
and data link layer. This project was developed using 3-tire architecture.
URL
Pattern:
URL pattern represents how the requests are flowing
through one layer to another layer and how the responses are getting by other
layers to presentation layer through server in architecture diagram.
MODULE DESCRIPTION - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
- Admin Module:
This module is all about an Administrator who maintains this portal. The
administrator of this portal will perform the following functionalities:
a. Report on Existing Employees
i.All Employees
ii.Branch wise
iii.Designation wise
b. Report On Selected Candidates
c. Report On Feedback given by
i.Employees
ii.Visitors (outsiders).
d. Report On Conference Discussions based up on the date
- Recruitment Module:
This module is related to requirement for conducting an exam
a. Online Exam: Question paper will be
generated on the spot by generating question no’s randomly.
b. Interviewer Login: Once the candidate
qualifies the online exam, can be allowed to the following rounds.
i.Technical
ii.Managerial
iii.HR
3.Employees Module :
- Modify Personal Details
- Positing Queries
- Referring Queries
- Delete Query
- Feedback Form
- Search From
i.
Conference Discussions
ii.
Queries N Solutions
- Resign
4.Conference Module:
- To send message to
i.
All Employees
ii.
All Project Engineers
iii.
All Software Engineers
iv.
All Analysts
v.
Specified employee only
- Saving all discussions securely in Oracle database.
5.Visitors Module:
This
module is related to visitors. If the organization is having any unsolved
problems, those problems can be solved by outsiders if they know solution.
DATA DICTIONARY - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
Total Tables
Tables Names
|
Table Type
|
ALLOT
|
TABLE
|
ANSWERS
|
TABLE
|
CONFERENCE
|
TABLE
|
EMPLOYEE
|
TABLE
|
EXAMINEE
|
TABLE
|
FEEDBACK
|
TABLE
|
QUESTIONS
|
TABLE
|
VFB
|
TABLE
|
Employee Table:
Field Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
HTNO
|
VARCHAR2
|
30
|
Primary
Key
|
Hall
Ticket No
|
NAME
|
VARCHAR2
|
30
|
Not
Null
|
Candidate
Name
|
BRANCH
|
VARCHAR2
|
20
|
Not Null
|
Branch
Name
|
On Line Exam Table:
Field Name
|
Data
Type
|
Size
|
Constraint
|
Descriptions
|
SNO
|
NUMBER
|
6
|
Not
Null
|
S
NO
|
QNO
|
NUMBER
|
6
|
Primary
Key
|
Question
NO
|
ANSBY
|
VARCHAR2
|
50
|
Not
Null
|
Answer
NO
|
ANS
|
VARCHAR2
|
2000
|
Primary Key
|
Answer
|
Conference Table:
Field Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
TOPIC
|
VARCHAR2
|
20
|
Not Null
|
Topic Name
|
DAT
|
DATE
|
Not
Null
|
Conference
Date
|
|
INF
|
LONG
|
Not Null
|
Topic
|
Employee Details Table:
Field Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
FN
|
VARCHAR2
|
30
|
Primary
Key
|
First
Name
|
LN
|
VARCHAR2
|
30
|
Primary
Key
|
Last Name
|
GENDER
|
VARCHAR2
|
30
|
Check
|
Gender
|
DAY
|
VARCHAR2
|
30
|
Not
Null
|
Day
|
MONTH
|
VARCHAR2
|
30
|
Not
Null
|
Month
|
YEAR
|
VARCHAR2
|
30
|
Not
Null
|
Year
|
LIVE
|
VARCHAR2
|
30
|
Not
Null
|
Address
|
PC
|
VARCHAR2
|
30
|
Not
Null
|
NO
|
USERID
|
VARCHAR2
|
30
|
Not
Null
|
User
ID
|
PASWD
|
VARCHAR2
|
30
|
Not
Null
|
Password
|
BRANCH
|
VARCHAR2
|
30
|
Not
Null
|
Branch
Name
|
CITY
|
VARCHAR2
|
30
|
Not
Null
|
City
Name
|
STATE
|
VARCHAR2
|
30
|
Not
Null
|
State
Name
|
DESG
|
VARCHAR2
|
40
|
Not Null
|
Designation
|
Examinee Table:
Filed Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
HTNO
|
NUMBER
|
Primary
Key
|
Hall
T NO
|
|
NAME
|
VARCHAR2
|
20
|
Primary
Key
|
Name
|
BRANCH
|
VARCHAR2
|
10
|
Not
Null
|
Branch
Name
|
TR
|
VARCHAR2
|
10
|
Not
Null
|
Technical
Round
|
MR
|
VARCHAR2
|
10
|
Not
Null
|
Marks
|
HR
|
VARCHAR2
|
10
|
Not
Null
|
H
R Marks
|
SELECTED
|
VARCHAR2
|
10
|
Not
Null
|
Selected
|
DT
|
VARCHAR2
|
5
|
Not
Null
|
Verify
|
DESIG
|
DATE
|
Not
Null
|
Designation
|
|
REG
|
VARCHAR2
|
35
|
Primary
Key
|
Reg NO
|
Feedback Table:
Field Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
SNO
|
NUMBER
|
Not Null
|
Feedback No
|
|
DTE
|
DATE
|
Not Null
|
Date
|
|
WORKENV
|
VARCHAR2
|
20
|
Not Null
|
Work
|
REASON1
|
VARCHAR2
|
2000
|
Not Null
|
Reason
|
SUP_SUPPORT
|
VARCHAR2
|
20
|
Not Null
|
Supported
|
Questions Table:
Field Name
|
Data Type
|
Size
|
Constraint
|
Descriptions
|
QNO
|
VARCHAR2(20)
|
20
|
Not Null
|
Question NO
|
NUMBER
|
PBL
|
2000
|
Not Null
|
Number
|
GRP
|
VARCHAR2(2000)
|
2000
|
Not Null
|
Round Selected
|
Visitors’ feedback Table:
Field Name
|
Data
Type And Size
|
Size
|
Constraint
|
Descriptions
|
OPINION
MORE
|
VARCHAR
LONG
|
2000
|
Not
Null
|
Options
Of The Visitors
|
INTRODUCTION TO TESTING
Introduction to Testing:
Testing is a process, which reveals errors in
the program. It is the major quality measure employed
during software development. During software development. During testing, the program is executed with
a set of test cases and the output of the program for the test cases is
evaluated to determine if the program is performing as it is expected to
perform.
TESTING IN STRATEGIES - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
In order to make sure that the system does
not have errors, the different levels of testing strategies that are applied at
differing phases of software development are:
Unit Testing:
Unit Testing is done on individual modules as they are completed and become executable. It is
confined only to the designer's requirements.
Each module can be tested using the following
two Strategies:
Black Box Testing:
In this
strategy some test cases are generated as input conditions that fully execute
all functional requirements for the program. This testing has been uses to find errors in the following
categories:
Incorrect or missing
functions
Interface errors
Errors in data structure or
external database access
Performance errors
Initialization and
termination errors.
In this testing only the output is checked for correctness.
The logical flow of the data is not checked.
White Box testing:
In this the
test cases are generated on the logic of each module by drawing flow graphs of
that module and logical decisions are tested on all the cases. It has been uses
to generate the test cases in the following cases:
ü Guarantee that all
independent paths have been Executed.
ü Execute all logical
decisions on their true and false Sides.
ü Execute all loops at
their boundaries and within their
operational bounds
ü Execute internal data
structures to ensure their validity.
Integrating Testing:
Integration
testing ensures that software and subsystems work together a whole. It tests the interface of all the modules to
make sure that the modules behave properly
when integrated together.
System Testing:
Involves in-house testing of the entire system before
delivery to the user. It's aim is to
satisfy the user the system meets all requirements of the client's
specifications.
Acceptance Testing:
It
is a pre-delivery testing in which entire system is tested at client's site on
real world data to find errors.
Test Approach:
Testing can be done in two ways:
Bottom up approach
Top down approach
Bottom
up Approach:
Testing can be performed starting from smallest and
lowest level modules and proceeding one at a time. For each module in bottom up
testing a short program executes the module and provides the needed data so
that the module is asked to perform the way it will when embedded with in the
larger system. When bottom level modules are tested attention turns to those on
the next level that use the lower level ones they are tested individually and
then linked with the previously examined lower level modules.
Top down approach:
This type of testing starts from upper level modules.
Since the detailed activities usually performed in the lower level routines are
not provided stubs are written. A stub is a module shell called by upper level
module and that when reached properly will return a message to the calling
module indicating that proper interaction occurred. No attempt is made to
verify the correctness of the lower level module.
CONCLUSION - ONLINE CONFERENCE MANAGEMENT SYSTEM PROJECT
The efficiency of any
system designed to suit an organization depends cooperation during the
implementation stage and also flexibility of the system to adopt itself to the
organization. Smart Warehousing System has been developed to overcome the
problems with existing manual system which causes lot of problems in tracking
the business activities with different people.
As evidence of
the success of this system, all the data regarding users at different levels
are stored at server side through which the authorized can take decisions in
time, and all the transactions will be recorded in a well refined manner. The
Smart Warehousing System will be best suited to any organization, which has sub
location at different places.
Data Integrity
is maintained by well-defined security in the database, so the reports coming
out are live and accurate. In Total, productivity, quality, safety and user
satisfaction are improved greatly in the organization.
1 comment:
Really thanks for sharing this useful post !! This post is very informative and I have got very good information.
subscription billing platform
Post a Comment