NEAR EAST UNIVERSITY YAKIN DOGU UNiVERSiTESi

YAKIN DOGU UNiVERSiTESi

Faculty of Economics and Administrative

Sciences

DEPARTMENT OF C.I.S. 2007/2008 Spring

Graduation Project CIS 400

Reservation System

Submittet To: CIS Departmant

CONTENTS

I. ACKNOWLEDGEMENTS

II. ABSTRACT 1

('t>c.c:.~)

III. INTRODUCTION 2

IV. DESIGN OF THE SYSTEM 3-19

- Explanation - Feasibility

- Data Flow Diagram - Database

- Database Design

V. USER MANUAL 20-24

- G 5.e.< Mo~uc..L - Block Diagram - User Flow Charts

VI. REFERANCE 25

VII. APPENDIX 26-33

I used DELPHI programming language for writing this program and MY SQL database that has connection with DELPHI programming.

Aim of this projet is: Collect the customer information, reservation detail and payment with the digital environment ang automatically give invoice and recept to the customer. Program will work with the customer base. Each customer has a unique customer id and a specific referance code for each operation. With this customer id we will see all opretion that customer did. Referance code is used to see the specifik operation of the costumer did. Use customer number and name we will see all operation, payment or dept with the customer.

If needed in the analys part: You can search for a cusomer, for office, specifik dates or sale type.

DESIGN OF THE SYSTEM

This program is make for the Near East Tourism Agency Dorana Tourizm. In this program I will try to solve tay needs and wants.This project think to give the usage of the Dorana Tourism in the future. With this program all operation and payments will control and record more effective.

Program language pf this project is Delphi and the database is MY SQL.

Basic Component of the program: Analiz

B ilet Rezervas yonu

Otel Rezervasyonu Fatura

Makbuz

EXPLANATION

The minimum requirement of the system are as follows:

Intel PII Processor 350 MHZ

128 MB Ram 20 GB Hard Disk

14" Monitor

Microsoft Windows XP

The Recomended requirement of the system are as follows:

Intel PIV Processor 2.4 MHZ

1028 MB Ram 80 GB Hard Disk 17" Monitor

Microsoft Windows Vista

1. Proiect Identification Ans Selection

Aim of this Project:

Aim of this projet is: Collect the customer information, reservation detail and payment with the digital environment ang automatically give invoice and recept to the customer. Program will work with the customer base. Each

ustomer has a unique customer id and a specific referance code for each operation. With this customer id we will see all opretion that customer did. Referance code is used to see the specifik operation of the costumer did. Use

ustomer number and name we will see all operation, payment or dept with the ustomer.

The existing system's handicap is receipt an invoices are writen bye the hand. And Payments, recept, bills are storing with hard copy. But this system all datas are stor in database

2. Proiect Initiation And Planing

Technical Feasibility:

The hardware are necessary for the system are as follows: - Copmuters for sales person

- A printer to take print out receipts and bill - A computer to store database

Operational Feasibility:

The standard computer knowledge is enough to use this system. System is clear and user friendly.

Economical Feasibility:

All the expences will be afforded by the Near East University.

3. Analysis

The Reqmrement Determination

The requirements made by the users are as follows:

- To increase speed of the operations - To prevent the loss of data

- To prevent easy and quick data access

- To restrict data access with the means of the system security.

The Existing System Capability

- There is no existing system, everyting is made by Hand.

Receipt

~ -<

(1) I» tn "" (1) - <:::, s» C !:!': 0 0 (Cc :::, C: en -4 '< C: tn :::!. -N

3

3 -0 C ;::, :;,- Dl "' Cl) :, < 0 @' 0 C Ill

-

0 3 ff)

..

(/) Dl ro 3 o' 3 ~ 5· :, (') C !!?. 0 3 ~ :, o'

•

•

•

•

I

•

•

•

•

•

Customer Information () "T1 C 0 (/) 3 0 3 Ill _~ ::; Cl) _3" C. () o' C 3 !!!. 0 !!l. 3 5· ~ :, :i"" o' 3 Ill 6 :, Customer Ticket Detail ci1 3 oil> Cl)::; - Cl) Ill C. = -I 15" [ ~ 0 3 0 C. !!l. 5· :, 0 Cl) i )> :::::s II) j cii'.,:. "ti

a

(") g: UI en II) iD "ti CD iii 0 :::::s '---Analysis Request---, -I ci' ~ CD ..•. "tlW

a

(") CD UI UI )> :, 3: Ill '< c: "T1 (/) ,qi 0 iii" ..•. 3 Cl) ::0 CD :::!. Ill .0 §' C Cl) C. _!!!. :i" _{0 I} () < _~ 0 "T1 C n· Ill 0 (/) Cl) I 3 0 0 Ill 3 Cl) _§' ~ ni C. )> () C) C) C 0 (/) 3 0 0 3 C. ~ !!l. )> s C) :, C) :i" 0 _o' 3 0 3 C.

~J

!!l. 5· "T1 :, II) ..•. C o' ., 3 II) !!l. 5· :, I )> C) C) 0 3 0 C. Oil> Cl) =- -o Ill :, = () 0 (/) 0 3 Cl) L.., 2:! CD ..•. C CD S' '< "T1 0 :i" 3 < _Ill 0 :, ::; n· o' Cl) (]) .., C. 0 3 -I (]) ~~ w :i" 0 Cl) < :,

-

0 0 n· _~ Cl) Ill -I '< 0 §i:

"

0 :::::s II) ~ iii 3 II) C CD

.•

II) '< Formatted Accomodation lnfotmation 1---- Receipt Total ~1 3: II) ~ C" C N L____Accomodation lnfor ;,:;; () :, C 0 (/) :!: - -o ~~ <g .., 0 C UI ..•. 0 3 CD

..•

1J Ill '< 3 Cl) a I :::0

g~

~ (n \::

a

'\-.s ;

s

\:,

UI UI

-f

0

"C

r-

CD

<

CD

-

C

.,,

C

.,,

0

..,

::a

CD

tn

CD

<

D)

r+

-·

0

::::,

en

'<

_tn

r+

CD

3

0 Cl) 5l:

"T1 DI •• C Dl Formatted T J / lnform~t~i~ Detail~/

/

I

-g\~

"ti l...

..

\

g \

Cl) I

"'

'

"'

\

\

"T1 0 3 Q) §' a.

§

3 3 0 a. !!l. s: :, :, o' 3 !!l. s :, (I) r+

D)

-·

-

C

••

0

C

C

"'

0

••

3 DI

0

..

..,

-

::,

<

0

-·

o

(I)

-a

..,

0

n

(I)

u,

u,

() C: ~ 0 3 ~ )> § 3 3 0 C. !!l. 5· ::, 3" o' 3 !!l. 5· ::,

,,

0 3 ~ CD C. () C: ~ 0 3 ~

§

3 3 0 C. !!l. 5· ::, ::, o' 3 a 5· ::,

.,,

Ill ..•. C: iil () C:

s

3 ~

§

3 3 0 C. !!l. 5· ::, 0 CD [

"

0 ::::s Ill :!S: Ill 3 Ill C (I) ..•. Ill '< Accomodation Detail Information > C, C, "'tJ 0 .• 3 0 3 "' C, • (I) 0 •••• UI C. UI Ill

g:

::::s ~ C, 0 3 "'tJ 3 .• 0 g C. "' (I) Ill • UI e, "' UI 0 ::::s C (I) iil° () C: Cf> 0 3 ~

§

3 3 0 C. !!l. 5· ::, 0

i

C/) Ill ~ "'tJ (I) ii1 0 ::::s

C

(I) r+

D)

-·

-

C

-n

C

-n

0

-s

)>

o

o

0

3

3

0

C.

D)

r+

-·

0

:::s

,:,

-s

0

n

(I)

en

en

31:

1·

c:: I (I) '.(/1 ..•. C, r+ :::!. I

D)

-·

(')

-

C: "T1

s

C

0 3 3

i

~

.,,

:, 0. o' CJ)

C

(') 3 II) C: ~ !e. !!l. Customer 0 ,5'

.,,

3 :::, Knowledge "'C (I) C, ..., ciJ

0

:, o' 0 3 :::I

..,

!!l.

-I

5· :::, I

C,

-·

~

""'

"Tl

~~\

ci' Ticket~""- (I) II) ~ ..•. C, r+ C: ..•. .., "'C~ II) .., ..•.

.,,

0 Detail (") C,

..,

/JI

0

/JI

C,

(I) (')

tn

C: I Cl>

tn

0 (') 3 C: ~ Cl> -i 0 0 3 " ~ ~ -i CJ ff ~ " ~ ~ CJ [ Ill ~ ..•. C C, ..•. II) '< Ticket Detail Information

s: c:: ,qi r+ Cl)

~-

> :l Al '<

"'

iii' :S" "'tJ ••••

a

C') Cl)

"' "'

)> ::, Dl '< (/) ;;;· 0 CD [ :;a Cl) -g :+ .i:,. "'Ci-..,

a

C') m

"'

"Tl Al r+ C: @ Formatted Analysis Request a:,1011u1 panewJo.:1----~ Analysis Request

C

(I)

,...

Q.)

-·

-

C

'Tl

C

'Tl

0

..,

)>

::::,

Q.)

-

'<

_tA

-·

tA

.,,

I» r+ C DJ Payment 0 C Ill r+ 0 3 l'D

..•

5" "U < Ill ::0 Q. '< 3 (1) £ (1) ~. -i ;::t ~ ~ 5" Cl en

-

- 0 !!?. 3 I» ~ c6" ~ I s "'O :, l'D cil 0 ~ ::0 L-Debtl Formatted Payment (1) 3 Ill s 3:: C. 0, (1). I» ~ N ~ "U C" a C

s

N Receipt Total V, V,

I

ff)

r+

D)

-·

-

C

.,,

C

.,,

0

.,

:::a

ff)

o

ff)

-·

-c

r+

DATABASES

There are 6 databases in the system. There are:

Islem Detay Fatura Konaklama Detay Kullamcilar Makbuz Mii~teri

Database Connection

,,..:. .r

l

I

ffll

1

i -n W1 0 ~ ...•• 0, _r-r -o ro ro 3 ,::I g .~ 0:: ~u ll'l ~rTrr-,3rT ro v, 5· o, ro o, CL ::, =1 .,~, @'" W1 L'I .0.. VI 3 ("T c= r- (ti @" ~ g ;;:.

(!) J:>, ~ &f ~ ~ s -~: (!) 3 :4 "O(tl~..JW ~ ~ -~ ~ 3 ~ (!) . VI 0·· 0, (!) 0, 0.. :, :J ~- (D V) Vlo_,,.3 .@" c s (D (D ron ~ 3 3 §- "' (!) (!) <Cl ~ ~ "' Vl

"U ...• 3 .(I) u (I) 0, :::, s vf ci., lfl .lfl or ,,. r 0, 0 '"'

(D -I ...• ~ lfl J:- g; =i-, "tJ 0,.,. Q. VI m°.'C: •••• 0., '3 o., -< c:;- -o ro -a· ·" U) ,...,. (D3:4g:~,cr "CJ (1l ,..., ;:, (1l ;:, -.~ ~ ~ ·QL 3 l=;! ro _ "' er °' -ro °'- a. ::i ::, ,~- ii" Ln Vl o, v. 3 ~ ~ b

s

(ti ([I II r-r 3 3;:,. "' (1l (1l ;:, ;:, ;:, ,0 ,..,. v-r V) V)

User must enter pasword to enter the system.( see fig 1)

First of all user must select the process. Fatura, Makbuz or Analiz. If user selecet Fatura: User must select Sans tipi, Bilet or Konaklama If selected process is Ticket:

In ticker reservation: User enter Gidis or donus tarihi, Nerden Nereye, Rava yolu detail, Ticket PNR number, passenger name, surname, passenger kisi information, fiyat, and indirim. (see fig .3)

If selected process is Konaklama:

In accomodation reservation: User must enter Acente ismi, Ulke and Otel A Then user unter customer information, Giri~ tarihi, 91k1~ tarihi, gece sayisi, gecelik fiyat, ek banka komisyonu, indirim, doviz, oda tipi, pansiyon, adi, soyadi, kisi and aciklama. (see fig J,)

If user select Makbuz : Find the customer, insert customer payment detail: islem, tarih, banka adi, sube adr and miktar. (see figS)

If user sellect Analiz user select the analyse type. Like: Fatura tarihi, Sans T Islem, Islem Detayi, Ofis, Musteri No, Ad or Soyad. User can sellect all typ, can select a specific information. (see figo)

>, rn ·5. Q) 0 i= 0 z "" E E ·;;: "O s: ~ Q) Q) 2 rn -~ _-~ (J) "" >. Cl) -~ 0 ,::, "O ₀ f- _~ <( Cl) .!::,! <ii C <( E .i!l E Q) -~ .c -~ f- z- c UJ "E 0 ~ (J) rn a. N ::, .0 ..I< rn ~ ::, 0 ·- c a> >-E s: a> >. a> -5 E E -~ "E ~ ~ Cl c:: rn .5 ~ "iii f- ~ ~ ~ z "O ~ ·;;;. ! :g g- - 1 / 1 1

t

I I~

I

1

i

I

E "" E "" ·- a> iii a:; ro E ~

.:::it:. _ca ·- _{E ·w} ·- ·- _{·= ~} - .c (.) >- (.) >, ·- - .:::ic:. ·c: <1> ro Cl> ·- ·= c..

f I

I "(

OIi' "(

"t

j

1

j ca m E _rn :;;; rn C

u

0

-

:,)

tl

~

E

.E - en ·- co "' "'\ ~ ~ ~ -~ .J Q) o» C: "E 't .;:; ~ ~

~

n

c:: S5 j <( ) m )

j

I

I ~

LL

Start 1 Fatura 2 Makbuz 3 Analiz 4 Q1k1~ 21

Fatura Process

Enter Satrs Tipi

Enter BileV Konaklama

Enter Ucak/Gemi

Enter Tarih

Enter Nerden/Nereye

Ener Havayolu/Gemi

Enter PNR

Enter Ad/ Soyad

Enter Ki~i

Enter FiyaVlndirim

Enter lslern

Enter Mui?leri No

Enter Ad/ Soyad

Makbuz Process

Enter lsim Soyisim

Enter lslem

Format: Paperback

Publisher: John Wiley & Sons Inc (December 28, 2005)

Measurements: 9.25"(h) x 7.5"(w) x 1.5"(d), 2.06 lbs. ISBN: 9780764584374

Burland® Delphi .••• ·6 Developer's Guide

by Ste:ve Teixeira; Xavi,er..Bacheco

Publisher: Sams

Pub Date: Decemf>er 17, 2001

Print ISBN-10: 0-672-32115-7 Print ISBN-13: 978-0-672-32115-.3 Pa,g.es: 1200

~~~~

j

-~

cc~,-; 8 -c ~,1 ~ ::::C:::: ..,., I . a:: .J .J <( ]). ·, o <( ~ !1' ~ 0 g :: !al I-

!;:

,_ .,

> ·- 1--'

"

< ~,;; ~ c.!> ·- ::,

I

.

:5 w z:""1" 0 0 :c -:.~g§ < J ,-., :sl z "! 8 < ::'. :s -, ::; ~ °'3"

::5 .:'.:

- "'

...:

G) le o ,.... C ~ (/) ~ ~! .. [C :::c _<C ~ _' .:E 0:: ~ >'!: - ·--···

_s

ll.. e ci ~ I • l J ll. :!: ~ 2 "UCO~ N ; -~ ~ !: ~ I :: ~ i ~ () z • • = N :::, :::::> er:::::::~'.::'.~, ...J u 10 NV::::) :::,

~

~iJ~~~ ~

""=z:~.S .c::: <( ··-"'• • e 1:1 - ' w ~

'-i...~

z•"'ON,_ a: 0:: ~ ::~""""" Bi. -- <(~=~;;;.g O :il --z:N~ <.!:l Z: er:::~;~'.::'.~ ••>NC: - - LU i

o·w~~~

..

:E ~ : ; -~ s .!::1 ~ 5 ffi 0 ~ . , z ~ 00 ,S! -" .S 5 ·;.; == ~ :!!: ·== ~ w _~

111l!f

J1!11Jli1J!\~

·~ s::! ~ _~ w _•....

9>0 •mi 1s1~11a ,mi m9 m mo •111 ·om111~\"la1rn 0~1

=>

N

=> ~

co cc ..,., 0

,.

..

, ~

""

"

""

0 a::

J

(.) ""~ <C ~ ,-; C'II _cd ~ (_) <C ·;;:; ~ z I- 1 ~ 6 ,--i ::::, :5 0 •.... .J ~c.!J·-=> X: w z: ,--i ₀ .J ·=="""a:: <

:I)<

f- ·§ ..,,. ,... I- ~c::cE:5~ _~ (') ,... > I- _.::! ::CO>LO

~

'3o

::5 ·-

u, > ~ - ·c.3 0 0 :c (/) ffi 0 0 <( z

_R

0 :::c > ~ .:5 ti 0 C 0:: ~ ~ >'!: ,.... [C .••• ,,,..,,.,,,.f...,,..,.'- .,..,,,,_,.,,,.. ==

:s

e, 0 to-

I

ci en :::, .

.-

ll. :!: <( 2::~~~

•

N;~""'--s I > "t::t 0,) ·- : : .~ ~ :::i () er:::~~~"'~ ·- -: 1§ N@) z _:::::> ~::, :::;8, ...J I- : .;;';;§ :::::> ,: Z C,::, 0 en ~ <(

:!:~

~ z .~ ~ ~ -= w 0:: ~ .:::

<( ; ·u oq- :::i

""' a rorr>-0 a: :§ - z ~ ~ ₀ z er::: - ·- :::, :::; : ~ N :g _<.!:l c:c < Q ..., ~~ E z :E :'.:l ... ,_ 0 V) LU :5 0:: "' ·-

-

·- 0 . :'.:l 0 ;!~j -~ :.c:: c3, w 0:: :,,:: ·== ,::, < "' ~ "' w =· w •....

0 d (') u5 w f- ci5 er: w ~ z :::> :::> (.!J 0 0 z ~ ~ 0 z '"i a: a, u, _co ,-...

D» ~

i

0

r/j

0 , j

e<

.g£f$j

z C'\11 N ~ ,a;: ".

.... :<::,·:' ) •

'.5 <O ,.... _.··-i~~/ "" ~ :::, ~ ::;;; J ~ ·O ~ 0 ·:::; C'J d (/) c:::( ·c,; LLI M ,_ ••• w_ ·,:3 0 0:: ~ ₀ LLI > :c z ·a= ;'.',' _li r..::2 a: re; ~ N

cc

::> I- <(

z

(/) :::, a. :E ~ Cl} w CD z w Cl) :::c: w Cl) N ,:::, >-