1.1Preamble
In “VISA PROCESSING SYSTEM” the system has feasibility for the applicant to apply and submit the visa application through online. Visa Processing System is used to process the visa and store all the details regarding the passport holder. It is an automated System; here the applicant can apply for the visa at any time from any place. Admin will handle type of visas, and very much concentrate in visa processing. If Admin approves the visa then it will generate all possible reports.
1.2Motivation
• By using Visa Processing system the efficiency of system will be increased.
• It reduces lot of human efforts as well saves a lot of time consuming.
• It reduces the paper work.
1.3 Goal and Objectives of the Project Report
• Visa processing system avoids the manual work such as applying for visa, checking visa status and issuinginterview appointments.
• It is a Online Application which automates Visa Processing.
• It takes less time to do operations like registration and checking visa status also feedback details.
• By using this system it reduces paper work.
• Admin keeps track of all user details and feedback details.
• Admin handles three types of visa and if the admin approves for the visa then the user’s visa will be accepted.
1.4 Problem Statement
• The problem is to overcome the manual Visa processing which can be done by the use of technology and automation.
• It reduces the overall time consumed thereby increasing the efficiency.
• The problem involves paper work. But system eliminates Paper work.
• Difficulties in tracking the user details and visa status details is reduced
1.5Scope of the Dissertation Report
The Scope of this document is the System has deployed a manual process for visa in proposed system. Thus; the system needs to be automated. The Proposed system aims to check the visa status online and also reduce the workload involved in Visa processing.
1.5 Outline of Dissertation Report
Chapter 1:Introduction
This section describes about our project.
Chapter 2: Literature Survey
This section describes the Literature Survey.
Chapter 3: Requirement Analysis and Specification
This section gives the information about requirement analysis
Chapter 4: Analysis and System Design
This section gives the information about the analysis and design of our project
Chapter 5: Implementation
This section gives the information about implementation of our project.
Chapter 6: Testing
This section describes how testing is done
Chapter 7: Conclusion
This section includes Conculsion.
Chapter 8: Future Enhancements
This section includes Future enhancements.
Chapter 2
Literature Survey
Literature Survey is a study of relevant information of the given topic.
The problems which are perceived by the users in existing system are:
Less efficiency due to lot of manual entries.
Time consuming due to manual entries.
More Time Delay for payments.
Takes more time to collect the information while enquire about particular user.
Features of our System:
• It Replace Manual Processing with an automated System.
• It is used to Speedupthe entry of the user details.
• Admin will provide username and passwordto the particular user.
• It minimizes the workload involved in processing.
• User will given a userId to check visa status and interview appointment details.
• It stores data online.
• Online Checking Visa Status of particular user.
Chapter 3
Hardware and Software Requirements
3.1 Requirement Analysis
Admin Module:
Admin can view the visa renewal information, visa status information. He can generate all possible reports like interview reports, results report .He is having the control over the all the users. Administrator will describe the utilities assessed by an customers. He can view the application entries, enquiry details, interview details, result details.
Registration module:
User registers using registration module and enters the details like username, password, passport number, bank account number, gender, passport expiry Date.
Login Module:
User can login by using valid username and password. If the username and password is invalid then it displays “login unsuccessful”.
Visa Processing Module:
This is a main module. It handles all the details regarding visa application, submitted documents, employee particulars, passport details. This will be entered by user. After applying visa every applicant should attain enquiry and interviews held by Admin. These enquiry and interview details are stored in this module. The result also logged in this module.
InterviewDates Module:
After applying for visa the user has given the interviewdates by the admin and the user can check the dates given by the admin through this Module.
Visa status Module:
The user can check the status of the visa by submitting all his/her valid documents.
Feedback Module:
The user can give feedback how the application details has been processed and the admin can check the feedback details given by the user.
Report Module:
Report module deals all the available reports like user details,visa status report,interview dates report are viewed by Admin and approved by Admin if all the entered details are valid.
3.1.1Software Requirement Specification
• This project is implemented using .NET Framework.
• It is Developed using IDE Microsoft visual Studio 2010.
• Database is Implemented using Microsoft Sql server 2008.
3.1.2 Hardware Requirement Specification
• 256 MB of RAM or more.
• 2GB of hard disk space.
• Mouse or other pointing devices.
Chapter 4
System Design Architecture
4.1 ER Diagram
Entity-Relationship diagram
Entity: It is a real world object that defines the information to store in system.
Relationship: It is a named connection between entities. It also describes relationship between two or more entities. Relationships are description of the entity.
Attributes: It describes the properties of entities. It is a piece of information of entity.
Fig-4.1.1 E-R diagram
User Registration Table
Field Data Type Description
User Id varchar(50) Specifies User id
User Name varchar(50) Specifies User name
Password varchar(50) Specifies User Password
First Name varchar(50) Specifies User First Name
Last Name varchar(50) Specifies User Last Name
Father Name varchar(50) Specifies User Father Name
Mother Name varchar(50) Specifies User Mother Name
Date Of Birth Date/Time Specifies User Date Of Birth
Gender Varchar(2) Specifies User is a male or female
Country Varchar(50) Specifies User is in whice country
Passport Exp Date Integer Specifies User Passport Exp Date
Passport No Integer Specifies User Passport Number
Bank Ac No varchar(50) Specifies User Bank Ac Number
Uplode Photo varchar(50) Used to uplode user photo
Table. : User Registration Table
Employe Table
Field Data Type Description
Employee id Varchar(50) Specifies User employe id
Company_name Varchar(50) Specifies where the user works for
Duration Integer Specifies the periode of time
Country_name Varchar(50) Selects which country user needs to go
Visiting_company_name Varchar(50) Specifies name of the company
Table. : Application Entries Table
Business Table
Field Data Type Description
Employee id Varchar(50) Specifies User employe id
Company_name Varchar(50) Specifies where the user works for
Duration Integer Specifies the periode of time
Country_name Varchar(50) Selects which country user needs to go
Visiting_company_name Varchar(50) Specifies name of the company
Table. : Application Entries Table
Student Table
Field Data Type Description
Student usn Varchar(50) Specifies User id
Country_name Varchar(50) Selects which country user needs to go
College Name Integer Specifies the periode of time
Admission no Varchar(50) Selects student Admission no
Table. : Student Entries Table
Interview Date Table
Field Data Type Description
User id varchar(50) Specifies User id
Name varchar(50) Specifies User name
Date Date/time Specifies Date
Table. : Interview Date Table
Feedback Table
Field Data Type Description
User _id varchar(50) Specifies User id
Name varchar(50) Specifies User name
Email_id varchar(50) Specifies Users email address
Comments varchar(MAX) Specifies comments given by Users
Table. :Feedback Table
Cancel Interview Date Table
Field Data Type Description
User _id varchar(50) Specifies User id
Name varchar(50) Specifies User name
Passport_no Integer Specifies passport number
Date_of_birth Date/Time Specifies users Date of birth
Table. :Cancel Interview Date Table
Admin Table
Field Data Type Description
Admin_Name Varchar(50) Specifie admin name
Password Varchar(50) Specifie admin Password
Table. : Admin Table
Visa type Table
Field Data Type Description
VisaType Varchar(50) Type of visa
Country Name Varchar(50) Name of the country
periode integer Number of days
Processing fees integer fees
Table. : Visa type Table
4.2 Data Flow Diagram
Data Flow Diagram tells how the data will flow form one entity to another entity.
There are four symbols for drawing a DFD:
• Rectangle: It represents external entity which is source and destination of data
• Ellipses: It represents processes, which take data as input, process and validate it and gives output.
• Arrows: It represents the data flows.
• Open-ended rectangles or a Disk symbol: It represents data stores, which act as database.
Level 0: Admin
Fig-4.2.1 Level 0 DFD(for Admin)
Level 0: User
Fig-4.2.2 Level 0 DFD(for User)
Level 1: Admin
Fig-4.2.4 Level 1 DFD(for Admin)
Level 1: User
Username password
Unsuccessful
Fail
Success
Figure 4.1.1 Data Flow Diagram-User
4.3 Class Diagram
Fig-4.3.1 Class Diagram
4.4 Sequence Diagram
Admin :
Fig-4.4.1 Sequence Diagram(for Admin)
User:
Fig-4.4.2 Sequence Diagram (for User)
4.5 Use case diagram
Fig-4.5.1 Use case diagram
Use case diagram -USER
Figure 4.2.:-use case diagram User
Chapter 5
Implementation
Login Page
Registration
Home Page
Visa Type
Admin issuing Interview
User Interview
Approval Page
Report Page
Feedback Page
Chapter 6.
Testing
Testing is a process of executing a program with the explicit intention of finding errors. The entire testing mainly divided into three phases
• Unit Testing
• Integrated Testing
• Final/System Testing
Admin Login
Table-6.1 Login
< p>
User Login
Table-6.1 User Login
User Registration
Table-6.1 UserRegistration
Interview Table
Table-6.1 Interview Table
Employee Table
Table-6.1:Employee Table
Student Table
Table-6.1:Student Table
Business table
Table-6.1:Student Table
Chapter 7
Conclusion
• Visa processing system is a web-based application for tracking the visa details of the user.
• The main purpose is to avoid a lot of ,manual work.
• It’s User Friendly.
• It takes less time for Processing the required User details.
Chapter 8
Future Enhancements
Integration of visa to many countries.
Integration of Tourist Visa.
Efficient Management Of Records.
Simplication of the operations.
BIBLIOGRAPHY
Software Engineering
By Roger .Pressman
Unified Modelling Language
By Grady Booch, Ranbaugh, Jacobson
C#.NET Black Book
By Petereous