Tag: visual basic projects

Passport Automation System Project

To develop a mini project for Passport Automation System using Rational Rose, SmartDraw, MS Access and Visual Basic projects.

Passport Automation System

Problem Statement

The Passport Application System for Indian Nationals is being automated with a user-friendly interface and a strong back-end support. Every citizen of India who wishes to apply for his/her passport has to create a personal login account by registering himself/herself at first. From thereon, he/she can access the forms for the application process by logging in with the username and password for authentication.

The passport applicant can apply either by:

  • Normal application mode or
  • Tatkal mode.

Opting for the tatkal scheme costs the applicant an additional fee amount of Rs. 1000/- besides extra document proof submission.

We basically have two categories of applicants:

  • Fresh Passport Applicants
  • Passport Renewal Applicants

The applicants who are seeking their renewals must fill up an additional form regarding their old passport details.

All the details entered by the applicants are validated upon submission and recorded in the database. The applicants have to scan and upload their original documents for proofs of citizenship, address, educational background, occupation, etc.The final step would be payment of the passport application fee that would be computed automatically based on the modes and category of applicant. After the payment is successfully carried out, an appointment date would be generated for in-person verification of the applicant by the passport authorities. A receipt slip would be generated as an acknowledgement for the completion of passport application process.

Passport Automation System Modules


Basic Description
Users have to create their own login account by registering themselves. After filling up the registration form, the users can login to their account by entering username and passport for validation.

Basic Flow
New users will be directed to a registration page asking them to fill up the details like Name, DOB and other such trivial details. Filling up all the fields will be mandatory.
Pre-Conditions: None
Post-Conditions: After login, user will be prompted to choose the mode of applications.

Alternative Flow
If the user fails to login due to invalid username/password, the login screen will be reloaded again and again. Even if this doesn’t work, the user can try registering afresh.


Basic Description
This usecase prompts the applicant to decide on either of the 2 application modes- normal or tatkal.
Basic Flow
.Entering into the normal mode will open up the application form directly.
• Pre-Conditions: Successful login with appropriate username and password.
• Post-Conditions: The applicant has to pay the passport fees according to the choice of application mode in a later stage.
Alternative Flow
If the applicant chooses tatkal, an alert message is displayed indicating that additional charges are applicable. The flow resumes displaying the normal application form.


Basic Description
The applicant has to fill in all the mandatory fields in the given application form. Valid details are to be filled up without any ambiguity.
Basic Flow
The applicant has to manually type in all the particulars required.
• Pre-Conditions: The applicant has to make his choice of mode of application.
• Post-Conditions: The form is subjected to validations.
Alternative Flow
If the user wishes to terminate the session of form filling and proceed later, he can do so by quitting the process.


Basic Description
If the user wants to renew his passport (i.e. not a fresh applicant), previous passport details are to be filled in for validation.
Basic Flow
The renewal seekers are required to fill in their old passport details like Passport no, Date of Issue, Date of Expiry and Place of Issue
• Pre-Conditions: A valid old passport is to be produced to fill in the details.
• Post-Conditions: Authentication is done for the old passport existence before payment.
Alternative Flow
. None.


Basic Description
Original documents need to be provided for various authentications by the passport authorities.
Basic Flow
Scan the documents using a scanner and upload them to the database. This usecase validates the proofs of citizenship, address, education details, marital status and other such trivial details.
• Pre-Conditions: Valid documents like Birth Certificates, Licenses, Ration Cards, Bank Passbook, etc.
• Post-Conditions: Matching the submitted documents with the no of proofs required and validating.
Alternative Flow
If the documents are insufficient, an alert message is displayed. Otherwise, no alternative flow here.


Basic Description
The pre-computed payable amount is displayed in the form and payment options are displayed.

Basic Flow
The payment is calculated based on the mode chosen (normal or tatkal) and the charges are listed explicitly. Payment is done here.
• Pre-Conditions: Completion of all forms and proper modes chosen already.
• Post-Conditions: Payment gateway is opened and receipt would be generated.

Alternative Flow
Quit option to pay later on.


Basic Description
This is the final step in Passport Automation System process. A receipt is generated with an appointment date generated along with final application summary.
Basic Flow
The generated receipt can either be printed (saved) to a file or directly printed using a printing device.
• Pre-Conditions: Full payment for passport is done.
• Post-Conditions: A valid receipt is generated as a proof of having completed the passport process. He/she has to visit the passport office in person on the appointment date allotted for final authentication.
Alternative Flow
. None.


Thus a mini-project on Passport Automation System using Rational Rose, Smart Draw, MS – Access and Visual Basic has been developed and verified successfully.

Passport Automation System Report

{ Add a Comment }

Shift Management System Project


Call center Shift Management System is proposed for the call centers using which they can computerized their shifts organized, work distribution and employee performances. Call centers are basically the work centers, which provide 24 hours customer care via telephones and Internets etc. Now a day every large or small company has, their call centers situated at different locations. Besides supporting customers via a team of customer care executives, call centers has one more team that of technical peoples responsible for allocating, maintaining, updating and allotment company’s communication network. In order to schedule and distribute the work via which company can run smoothly the call centers make different-different teams and distribute the work task in several shifts to facilitate both the customer and the employee.

Feasibility Study

Benefit Analysis

In the current Shift Management System it is difficult for the employee to work over a number of projects simultaneously and for the call center to distribute the times. This results to costing a call center in terms of

  • Unnecessary delays in the work planned ahead
  • Extra manpower requirement to transfer messages across the organization on a daily basis.
  • Employees are working at different departments are not able to get some technical and administrative support sometimes from the call center and proceed in their own way which sometimes leads to unnecessary delays I the ongoing project.

The proposed Shift Management System if implemented will lead to cost saving in following ways:

  • Availability of information by the call center from employees and vice versa related to the ongoing project. Leading to efficient planning for the work ahead in proper time shifts.
  • No extra manpower requirement for the communication between the employees and mangers or any department. The system handles all the communication activities.
  • No extra manpower requirement for the communication between the employees and mangers or any department. The system handles all the communication activities.
  • The employees get the technical and administrative support in terms of the articles posted by other employees or administrator related to their experiences and responses to the queries raised of them in shorter period of time.

Shift Management SystemThe linear sequential model for software engineering. Modeled after a conventional engineering cycle, the linear sequential model encompasses the following activities:-

  • System /Information engineering and modeling.
  • Software requirements Analysis.
  • Design.
  • Code Generation.
  • Testing.
  • Support.

Shift Management System diagram

Implementation Of The System

The overall software of Employee management system is implemented using Visual Basic and Oracle-8. The Visual Basic provides a perfect graphical user interface for implement the call center’s shift allotment system into the forms to make the system user friendly and interactive. The system is implemented in forms, which are connected to oracle database, which in its turn is used to held data or records for the further details. Call center’s shift allotment System is implemented into Visual Basic forms used to take input i.e. details required for the system. Detail manipulation and calculations are also performed via the forms and the correspondent data is sent to the tables of the oracle database.

Forms Designs

This form contains all the fields of employee details table. It also contains few necessary navigation buttons. It contain buttons for adding, saving and deleting records. Records saved from this form goes directly to employee_details table.

This form is linked to the employee form. After filling the official details in the employee form we will fill in his personal details in this form. This form is bound to the personal_details table and all the record will be saved in this table.

This form is used to assign the jobs to the
Employees. In this form the reporting officer is also assigned to the employee along with the start, end, review dates of the project. According to the review date given in this form, the employees will be reviewed.

Each and every employees review details is stored in table from this form. There are two buttons in this form. One is SAVE and another one is EXIT. In the click event of save button there are some important procedures, which needs some explanation. As I am processing three reviews of each person, so it will be very difficult to maintain record of all the three reviews in this table. So I am moving the points of each employee in the Point’s table each time a person is reviewed along with his emp_no . Since there is a number of data flow from this form so it is a very important form.

In this project result form is a sub form of the review form. The average acquired from this form is passed to the review form to calculate the final details for the employee performance. As soon as the employees review is done the records from this table is deleted, so as to reduce redundancy.

Shift Management System Snapshots

shift management system Welcome page

shift management system login

call center shift schedule employee shift details employee work details Home page Office details Personal details page report one review details page Shift allocation page shift management system reports shift management system shift details Shift scheduling


Shift Management System Data flow Diagram


1st Level DFD

Call center first level diagram


2nd level DFD

Call center second level diagram

3rd level DFD

Call center third level diagram


Minimum Requirement

  • Random Access Memory: 64 MB.
  • Hard Disk: 10 GB.
  • Processor: P I (100 MHZ)



Like all other systems this system will remain feasible in the long run only if it provides the solutions to the current and future needs of the call centers and must be up to date as per the requirement of the call centers, it should evolve continually so as to incorporate the necessary changes. In addition, changes in the hardware and software platforms may also make it necessary to port the current application to that specific platform.

Project Download

Shift Management System Report

{ Add a Comment }