online dsk print

8/2/2019 Online Dsk Print

1/19

Ex.No:4ONLINE TICKET RESERVATION SYSTEM

PROBLEM STATEMENT:

The Any Where Any Time Advance Reservation system is the online ticket reserving

system where the passengers can reserve the tickets for their travel, cancel the reserved ticket and they

can view the status of the ticket before travelling.

The passenger who is reserving the ticket in AWATAR unless they are the member of

AWATAR .The passenger can reserve the ticket by giving the required detail in the form and submit

it for the processing .They can reserve for at the max for five members and a single ticket is providedfor them.

The administrator the AWATAR can control the ticket reservation and the accounts of the

passengers who are signing up in AWATAR. The administrator can reset the seats, fares of the

tickets, and generates the PNR number for the ticket that are reserved.

The sole control of the system is handled by the administrator. The printer prints the tickets

that are reserved by the passenger. The passenger can sign-up for only one time and he can sign in for

any number of times for reserving, cancelling and viewing the tickets.

The AWATAR system provides flexibility for the persons based on the age, the passengers

are fared based on the age and the place of travelling. This makes ease of use in using AWATAR

system. The system tracks for the database any number of times for reserving, cancelling and status

viewing.

The passenger can see the status of the classes that are available in the train which he is going

to travel by noticing the number of seats details from the display board.

The cancellation of the tickets is also very easy so that the passenger can cancel the tickets

that he has booked.

PROBLEM REQUIREMENTS:

1.Basic Requirements:

1) Source place.

2) Destination place.

3) Date of journey.

2. Functional Requirements:


2/19

1) Details of passengers.

2) Details of the coach.

3) Pay the amount using visa card or debit card.

4) Give out the balance

5) Show the detail of ticket.

3.Non-Functional Requirements:

1) Trading system failure.

2) Unavailability of date.

3) Coach Unavailability

4) Insufficient amount for making payment.

5) Unavailability of berth.

MODELING:

UML DIAGRAMS:

Use case Diagram:


3/19

Login

Ticket Cancellation

View Status

Passenger

Admin

Printer

Ticket Reservation

Figure1: Use Case diagram for Online reservation system

Class Diagram:

Login Form

Username

Password

Login()

Display()

Login Account

Username

Password

Update()

Save()

Login Controller

Username

Password

Validate()

Figure2: Class Diagram for Login


4/19

Train Details

Train nameTrain number

Display()

Reservation Form

NameAgeGenderTrain nameTrain numberClassDateNo. of passengers

Submit()

Reservation Checker

NameAgeGenderTrain nameTrain numberDateClassNo. of passenger

Reserve()PNR Generator()

Station Name

SourceDestinationTime

Display()

PNR Status

PNR Number

Display()

Reservation Controller

NameAgeTrain nameTrain numberClassDateNo. of passengers

Validate()

Figure3: Class Diagram for Reservation

Activity Diagram:


5/19

S y s t e m R e q u e s ts

U s e r na m e a n d P a s s w o rd

P a s s e n g e r e n t e rs

U s e r na m e a n d P a s s w o r d

S y s t e m va l id a t e s t h e g i ve n

d a t a fr om t h e p a s s e n g e r

S y s t e m c h e c k s

d a t a i n d a t a b a s e

P a s s e n g e r e n t er s i n t o

t h e n e x t l e ve l

P a s s e n g e r v i e w so t h e r o p t i o n s a va i l a b le

S y s t e m d is p la y s t h e

e r ro r m e s s a g e

P a s s e n g e r e x it s

t h e s y s t e m

P a s s e n g e r r e -e n t e r s t h e

r e q u i r e d d a t a

Figure4: Activity Diagram for Login


6/19

Sys tem requires for

the Train number

Passengers enters

the Train number

System validates and displays the

train name and days available


the travelling date

Passenger enter thetravelling date

Sys tem validates the data

entered by the passenger

Passenger enters

the class of travel


class of travel

Sys tem validates

the data entered

System displays the

error message

Passenger leaves

the system

Passenger re-enters t he

required data

Passenger submits the

completed form

System displays

the message

System displays the

error message

Passenger re-enters the

required data

Figure5: Activity diagram for Reservation


7/19

Sequence Diagram:

PASSENGERPASSENGER SYSTEMSYSTEM DATABASEDATABASE

Req username & password

Enter username & password

Validates data

Permits to access

Figure6: Sequence diagram for Login

PASSENGERPASSENGER SYSTEMSYSTEM DATABASEDATABASE

Requests train no

Enter Train no

Validates data

Requires class

Enter class

Validates data

Display resevation details

Figure7: Sequence diagram for Reservation


8/19

Collaboration Diagram:

PASSENGER SYSTEM

DATABASE

1: Req username & password4: Permits to access

2: Enter username & password

3: Validates data

Figure8: Collaboration diagram for Login

PASSENGER SYSTEM

DATABASE

1: Requests train no4: Requires class

7: Display resevation details

2: Enter Train no5: Enter class

3: Validates data6: Validates data

Figure9: Collaboration diagram for Reservation

Component Diagram:

Online ReservationSystem

Update

Front Panel

Figure10: Component diagram for Online Reservation System


9/19

Deployment Diagram:

Online Reservation

System

Counter PC

Figure11: Deployment diagram for Online Reservation System

SOFTWARE DEVELOPMENT:

CODE IMPLEMENTATION:

LOGIN FORM:

MAIN FORM:

Private Sub Command1_Click()

Form2.Show

Form1.Hide

End SubPrivate Sub Command2_Click()

End

End Sub

ENTRY FORM:

Public a As New NewClass


a.viewdetails

End Sub



10/19

Form4.Show

Form2.Hide

End Sub


Form5.ShowForm2.Hide

End Sub


End

End Sub

Private Sub Form_Load()

Set a = New NewClass

End Sub

TRAIN DETAILS FORM:

Private Sub Command1_Click ()

Form2.Show

Form3.Hide

End Sub

RESERVATION FORM:

Public B As New System

Public a As New NewClass

Private Sub Combo2_Click()

Form4.Label11.Caption = Form4.Combo2.Text

End Sub


a.reservation

End Sub


End

End Sub


B.delete

End Sub


Form2.Show

Form4.Hide

End SubPrivate Sub Form_Load()


11/19

Set B = New System


End Sub

CANCELLATION FORM:Public a As New NewClass

Public B As New System


B.update

End Sub


a.cancellation

End Sub


Form2.Show

Form5.Hide

End Sub


End

End Sub

Private Sub Form_Load()


Set B = New System

End Sub

CLASS MODULE:

NEW CLASS:

Option Explicit

Dim db As Database

Dim rs As RecordsetPublic Sub viewdetails()

Form3.Show

End Sub

Public Sub reservation()

Set db = OpenDatabase("D:\06bei7876\OnlineRail\railway.mdb")

Set rs = db.OpenRecordset("details")

rs.AddNew

rs(1) = Form4.Text1.Text



12/19



rs(5) = Form4.Label11.Caption


rs(7) = Form4.Text5.Textrs(8) = Form4.Text6.Text

rs.update

MsgBox "YOUR TICKET IS RESERVED"

End Sub

Public Sub cancellation()



rs.MoveFirst

While rs.EOF = False

If rs(1) = Form5.Text1.Text Then

rs.delete

MsgBox " YOUR TICKET IS CANCELLED"

Form5.Text1.Text = ""

Form5.Label6.Caption = ""



End If

rs.MoveNext

Wend

End Sub

SYSTEM:

Option Explicit

Dim db As Database

Dim rs As Recordset

Public Sub update()



rs.MoveFirst

While rs.EOF = False

If rs(1) = Form5.Text1.Text Then

Form5.Label6.Caption = rs(4)

Form5.Label7.Caption = rs(8)

Form5.Label8.Caption = rs(5)End If


13/19

rs.MoveNext

Wend

End Sub

Public Sub delete()Form4.Text1.Text = ""








End Sub


14/19

SCREEN SHOTS:

FORM 1

Figure12: Home Page Form

FORM 2


15/19

Figure13: Option selection Form

FORM 3

Figure14: Train details Form

FORM 4


16/19

Figure15: Ticket Reservation Form

FORM 5


17/19

Figure16: Ticket cancellation Form

FORM 6


18/19

Figure17: Entering Name for Cancelling ticket

SOFTWARE TESTING:

TEST CASE REPORT:

TEST CASE NAME:Train number Availability

OBJECTIVE:Usability Test

TEST CASES:

SCENARIO 1: Train Number: 6655

EXPECTED OUTPUT: Error Message

TEST RESULT

ACTUAL OUTPUT: Train number not available


19/19

CONCLUSION:

Thus the application on student mark list analysis system is developed using rational rose

and implemented using visual basic. The main aspects that are behind this application is that they

enabled us to bring out the new ideas that sustained within us for many days. This applicationenables the student to retrieve their student details and mark details at anywhere with a system.

online dsk print

Documents