dbms nbp project report

7/25/2019 dbms NBP project report

1/49

DBMS Project Report ( UCP, GRW ) 1

[Type text]


2/49


TABLE OF CONTENTS PAGE NO

Introduction and objective 3

History 4

Feasibility study 6

Acnole!"ent #

$re%ace &

'ans $ro%ile 11

(ver )ie* 12

+,-. 14

+/- 16

,F, 1#

0 ,IAA 21

,atabase speci%ication 26

+5(T Analysis 2&

(r!aniational +tructure 34

'ranc7 Hierarc7y 41

[Type text]


3/49


Issues Faced by 'ranc7 42

eco""endation 43

.onclusion 46

'iblio!rap7y and e%erences 4#

0lectronic e%erences 48

INTRODUCTION

,urin! t7e past several decades personnel %unction 7as been trans%or"ed %ro" a

relatively obscure record eepin! sta%% to central and top level "ana!e"ent %unction9

T7ere are "any %actors t7at 7ave in%luenced t7is trans%or"ation lie tec7nolo!ical

advances: pro%essionalis": and !eneral reco!nition o% 7u"an bein!s as "ost

i"portant resources9

A co"puter based "ana!e"ent syste" is desi!ned to 7andle all t7e pri"aryin%or"ation re;uired to calculate "ont7ly state"ents o% custo"er account *7ic7

include "ont7ly state"ent o% any "ont79 +eparate database is "aintained to 7andle

all t7e details re;uired %or t7e correct state"ent calculation and !eneration9

T7is project intends to introduce "ore user %riendliness in t7e various activities suc7

as record updation: "aintenance: and searc7in!9 T7e searc7in! o% record 7as been

"ade ;uite si"ple as all t7e details o% t7e custo"er can be obtained by si"ply eyin!

[Type text]


4/49


in t7e identi%ication or account nu"ber o% t7at custo"er9 +i"ilarly: record

"aintenance and updation can also be acco"plis7ed by usin! t7e account nu"ber

*it7 all t7e details bein! auto"atically !enerated9 T7ese details are also bein!

pro"ptly auto"atically updated in t7e "aster %ile t7us eepin! t7e record absolutely

uptodate9

T7e entire in%or"ation 7as "aintained in t7e database or Files and *7oever *ants to

retrieve can


5/49

DBMS Project Report ( UCP, GRW ) C

1&C@ ='$ establis7ed a branc7 in Dedda7: +audi Arabia

1&CC 'y t7is ti"e ='$ 7ad branc7es in -ondon and .alcutta9

1&C# ='$ establis7ed a branc7 in 'a!7dad: Ira;9

1&62 ='$ establis7ed a branc7 in ,ares+alaa": Tan!anyia9

1&64 T7e Ira;i !overn"ent nationalied ='$Es 'a!7dad branc7

1 T7e !overn"ent o% $aistan nationalied ='$9 As part o% t7e

conco"itant consolidation o% t7e banin! sector: ='$ ac;uired 'an o%

'a7a*alpur >est9 1&4#?9

1# ='$ opened an o%%s7ore brain .airo9

1&&4 ='$ a"al!a"ated e7ran 'an >est9 1&&1?9

1& ='$Es branc7 in As7!abat: Tur"enistan co""enced operations9

2@@@ ='$ opened a representative o%%ice in Al"aty: Baa7stan9

2@@1 +tate 'an o% $aistan and 'an o% 0n!land a!ree to allo* only 2

$aistani bans tooperate in t7e B9 ='$ and nited 'an a!reed to "er!e

t7eir operations to %or" $aistanInternational 'an: o% *7ic7 ='$ *ould o*n

4C and nited 'an CC9 Also t7at year: ='$closed its branc7 in =e*

Gor9

2@@2 $aistan International 'an rena"ed itsel% nited =ational 'an

-i"ited >='?9

T7eo*ners7ip structure o% t7e =' re"ained as be%ore9 T7e only c7an!e to t7

e s7are7oldin!structure is t7at '- 7ad recently been privatied in $aistan

and *as no* o*ned 4& by t7eovern"ent o% $aistan and C1 by a joint

%orei!n consortiu" o% Abu ,7abi9

2@@3 ='$ received per"ission to open a branc7 in A%!7anistan92@@C ='$

closed its o%%s7ore branc7 in .airo

[Type text]


6/49


NATURE OF BUSINESS

=ational 'an o% $aistan *as establis7ed under t7e =ational 'an o% $aistan

(rdinance: 1&4&and is listed on all t7e stoc exc7an!es in $aistan9 It is re!istered

and 7ead o%%ice is situated atI9I9.7undri!ar oad: Barac7i9 T7e ban is en!a!ed in

providin! co""ercial banin! and relatedservices in $aistan and overseas9

(r!aniation +tructure o% t7e =ational 'an o% $aistan

ain (%%ices

ain (%%ices o% t7e =ational 'an o% $aistan are o% t7ree types

Head (%%ice

e!ional (%%ices

'ranc7 (%%ice

Network of National Bank of Pakistan

=ational 'an o% $aistan 7as a very *ide net*or o% brac7es and o%%ices9 Accordin!

to ='$


7/49

DBMS Project Report ( UCP, GRW ) #

(verseas 'ranc7es 22

epresentative (%%ices 4

+ubsidiary 2

Doint )enture 1

A #

All praise to Alla7: t7e "ost "erci%ul: ind and bene%icent: and t7e source o%

all no*led!e: *isdo" *it7in and beyond "y co"pre7ension9 He is t7e only

od: *7o can 7elp us in every %ield o% li%e9 All respect and possible tributes

!oes to "y Holy $rop7et o7a""ad >+A5?: *7o is %orever !uidance and

no*led!e %or all 7u"an bein!s on t7is eart79

[Type text]


8/49


I a" proud to say t7at I a" very !rate%ul to "y %a"ily *7ose ind prayers and

cooperation 7elped "e at every step o% "y *or9 +pecial t7ans !o to "y parents %or

t7eir cooperation %or t7e sae o% "y no*led!e9

I a" !reatly indebted to "y learned teac7ers: Sir.Imran Aslam*7o 7ave !reat

in%luence on "e durin! "y %or"ative years9 T7is report re%lects t7e no*led!e *7ic7

I 7ave !ained %ro" "y valuable teac7ers9 I acno*led!e *it7 deep !ratitude t7e

invaluable 7elp extended to "e byMr. Rana Ahsaan-ul-Haq,one o% t7e o%%icer o% t7e

=ational 'an o% $aistan: *it7out 7is cooperation it *as not possible %or "e to

co"plete "y Interns7ip eport9 He !uided and 7elped "e and specially t7e

sy"pat7etic attitude: *7ic7 al*ays inspired "e %or 7ard *or9

I a" really very t7an%ul to u7a""ad a%i (perational ana!er o% =ational 'an

unir c7o* branc7 : ujran*ala and all t7e ban sta%% %or t7eir cooperative attitude

durin! "y interns7ip9

In t7e end t7ans are due to one o% "y %riend r9 a%ar B7alid %or 7is cooperative

attitude durin! t7e co"pletion o% "y project *or9 He 7elped and supported "e

durin! !at7erin! and analyin! in%or"ation9

TALHA SADI$

ABDULLAH SHAHID

ADIL TARI$

BS%Hons&'

[Type text]


9/49

DBMS Project Report ( UCP, GRW ) &

P #

,urin! t7is ei!7t *ees lon! practical !li"pse t7e t7eories and ideas *7ic7 *e

received %ro" t7e boos 7ave been *o"en in t7e texture o% our actual li%e9 =o doubt:

it 7as 7elped us in cultivatin! t7e ;ualities o% coura!e: 7ope: initiatives and capacity to

turn our no*led!e to practical purpose9

'anin! sector o*es a pivotal i"portance in t7e econo"y o% any country t7rou!7 its

vibrant %unctions9 T7is is t7e deep seated "otivator t7at !eared up "e to join any ban

%or interns7ip9

[Type text]


10/49

DBMS Project Report ( UCP, GRW ) 1@

=ational 'an o% $aistan >='$? *as establis7ed in 1&4& under t7e =ational 'an o%

$aistan (rdinance 1&4& and *as 1@@ !overn"ent o*ned9 ='$ acted as an a!ent

o% t7e .entral 'an *7erever t7e +tate 'an did not 7ave its o*n 'ranc79 It also

undertoo overn"ent Treasury operations9 Inside t7e ban: in branc7 banin! it 7as

.learin! and .ollection ,epart"ent: overn"ent eceipts $rocessin! ,epart"ent:

Account (penin! ,epart"ent: e"ittance ,epart"ent: .usto"er +ervices

,epart"ent .as7 ,epart"ent: ,eposit ,epart"ent: Advances and .redit ,epart"ent9

T7ese are t7e "ost co""on depart"ents exist in al"ost eac7 branc79 It is o%%erin!

di%%erent deposit c7oices: advances: credits and securities etc %or its custo"ers t7rou!7its corporate branc7es9

Get t7ere are "any possible i"prove"ents: *7ic7 *e can be "ade and t7at can brin!

positive c7an!es in t7e syste"9 T7ere is s7orta!e o% e"ployees in t7e or!aniation9

5it7 develop"ent o% online banin! syste" t7e load o% *or can be decreased9 All

t7e sta%%s do not no* about co"puter9 T7ere is al"ost one or t*o e"ployees are

trained to operate t7e syste" in every branc79 0specially: t7e cas7 depart"ent is not

%a"iliar *it7 co"puter and in%or"ation syste"9 It is not easy %or it to i"ple"ent a

ne* syste" i""ediately it taes a lot o% ti"e to replace syste"s9 (nce i"ple"ented

its testin! taes "ore ti"e9 +o it is i"portant %or t7e 'an to develop a researc7

depart"ent %or redesi!nin! t7e operations o% t7e 'an

HASSAN ALI

BILAL FAROO$

BS%Hons&'

[Type text]


11/49


[Type text]


12/49

Bank(s Profile#

THE

NATIONS(S BAN)

Type overn"ent

B+0J

-+0

0stablis7ed 1&4&

Head;uarter $rincipal (%%ice: Barac7i $aistan

Bey $eople +9 Ali aa >$resident K .7air"an?

Industry 'anin!: capital aret

$roducts -oans: .redit .ard: +avin!s: .onsu"er 'anin!

etc

,eposit 624&38 illion

=et inco"e 1C4C& illion

Total Assets 81##C8 illion

=u"ber o% 0"ployees 1C2@4

=u"ber o% 'ranc7es 12#6

Ho"e pa!e ***9nbp9co"9p
http://www.nbp.com.pk/http://www.nbp.com.pk/


13/49

,'+ $roject eport =ational 'an o% $aistan

9

O*ER*IE+ OF THE ORGANI,ATION#

*ISION

LTo be reco!nied as a leader and a brand synony"ous *it7 trust: 7i!7est standards o%

service ;uality: international best practices and social responsibility9L

-ISSION

='$ *ill aspire to t7e values t7at "ae ='$ truly t7e =ation


14/49


Advance"ent o% sills %or to"orro*


15/49


or account nu"ber o% t7at custo"er9 +i"ilarly: record "aintenance and updation can also be

acco"plis7ed by usin! t7e account nu"ber *it7 all t7e details bein! auto"atically !enerated9

T7ese details are also bein! pro"ptly auto"atically updated in t7e "aster %ile t7us eepin!

t7e record absolutely uptodate9

T7e "ain objective o% our project is providin! t7e di%%erent typed o% custo"ers %acility: t7e

"ain objective o% t7is syste" is to %ind out t7e actual custo"er service9 0tc9

It s7ould %ul%ill al"ost all t7e process re;uire"ents o% any 'an9

It s7ould increase t7e productivity o% ban by utiliin! t7e *orin! 7ours "ore and

"ore: *it7 "ini"u" "anpo*er9

T7is project includes t7e entire up!raded %eature re;uired %or t7e co"puteriation banin!

syste"9 T7is syste" is very easy to use: so t7at any user can use *it7out !ettin! pre

no*led!e about t7is9 Its very "uc7 user %riendly and "eet al"ost all daily *orin! process

re;uire"ents9 T7is syste" is co"pletely I based and can be use by "ouse and as *ell as

eyboard9 T7is syste" is "elded in suc7 a *ay t7at 7as !ot all %eatures to up!rade *it7out

"ain! "uc7 c7an!e in existin! co"ponents9


16/49


SOFT+ARE DE*ELOP-ENT LIFE CYCLE#

A syste" develop"ent li%e cycle is a lo!ical process by *7ic7 syste" analysts: so%t*are

en!ineers: pro!ra""ers: and end users build in%or"ation syste"s and co"puter applications

to solve business proble"s and needs9

T7e "ajor p7ases involved in t7e I+ develop"ent process are re%erred to as syste"

develop"ent li%e cycle9 0ac7 p7ase o% t7e develop"ent process "ust 7ave *ell de%ined

objectives :and at t7e end o% eac7 p7ase :pro!ress to*ards "eetin! t7e objectives "ust be

evaluated9

T7e develop"ent process s7ould not continue until t7e objectives o% all prior p7ases 7ave

been "et9

+yste" develop"ent li%e cycle is a p7ased approac7 to analysis and desi!n to ensure t7at

syste"s are best developed9

T7e syste" develop"ent li%e cycle can be divided into seven p7ases as s7o*n in %i!


17/49


STRUCTURE $UERY LANGUAGE#

Intro/0!tion to S$L# 1

+/- is a standard co"puter lan!ua!e %or accessin! and "anipulatin! databases9

+/- stands %or Structured $uery Lan!ua!e9

+/- allo*s you to access a database9

+/- is an A=+I standard co"puter lan!ua!e9

+/- can execute ;ueries a!ainst a database9

+/- can retrieve data %ro" a database9

+/- can insert ne* records in a database9

+/- can delete records %ro" a database9

+/- can update records in a database9

+/- is easy to learn9

+/- is an A=+I >A"erican =ational +tandards Institute? standard co"puter lan!ua!e %or

accessin! and "anipulatin! database syste"s9 +/- state"ents are used to retrieve and

update data in a database9 +/- *ors *it7 database pro!ra"s lie + Access: ,'2:

In%or"ix: + +/- +erver: (racle: +ybase: etc9

n%ortunately: t7ere are "any di%%erent versions o% t7e +/- lan!ua!e: but to be in

co"pliance *it7 t7e A=+I standard t7ey "ust support t7e sa"e "ajor ey*ords in a

si"ilar "anner >suc7 as +0-0.T: $,AT0: ,0-0T0: I=+0T: 5H00: and ot7ers?9


18/49


S$L Data2ase Ta2les# 1

A database "ost o%ten contains one or "ore tables9 0ac7 table is identi%ied by a na"e >e9!9

L.usto"ersL or L(rdersL?9 Tables contain records >ro*s? *it7 data9

Below is an e3a4le of a ta2le !alle/ 5Persons5# 1

Last Nae First Nae A//ress Cit6

Hansen (la Ti"oteivn 1@ +andnes

+vendson Tove 'or!vn 23 +andnes

$ettersen Bari +tor!t 2@ +tavan!er

T7e table above contains t7ree records >one %or eac7 person? and %our colu"ns >-ast

=a"e: First =a"e: Address: and .ity?9

S$L $0eries# 1

5it7 +/-: *e can ;uery a database and 7ave a result set returned9

A 70er6 like t8is# 1

+0-0.T -ast =a"e F( $ersons

Gi"es a res0lt set like t8is# 1

Last Nae

Hansen


19/49


+vendson

$etersen

S$L Data -ani40lation Lan90a9e %D-L'

+/- >+tructured /uery -an!ua!e? is syntax %or executin! ;ueries9 'ut t7e +/- lan!ua!e

also includes syntax to update: insert: and delete records9

T7ese ;uery and update co""ands to!et7er %or" t7e ,ata anipulation -an!ua!e

>,-? part o% +/-J

SELECT extracts data %ro" a database table

UPDATE updates data in a database table

DELETE deletes data %ro" a database table

INSERT INTO inserts ne* data into a database table

S$L Data Definition Lan90a9e %DDL'

T7e ,ata ,e%inition -an!ua!e >,,-? part o% +/- per"its database tables to be created

or deleted9 5e can also de%ine indexes >eys?: speci%y lins bet*een tables: and i"pose

constraints bet*een database tables9

T8e ost i4ortant DDL stateents in S$L are# 1

CREATE TABLE creates a ne* database table

ALTER TABLE alters >c7an!es? a database table

DROP TABLE deletes a database table

CREATE INDE: creates an index >searc7 ey?


20/49


DROP INDE: deletes an index + +/- +0)0 2@@@


21/49


DATA FLO+ DIAGRA-

DATA FLO+ DIAGRA-# 1T7e data %lo* dia!ra" is also no*n as Mbubble c7artN

7as t7e purpose o% clari%yin! syste" re;uire"ents and identi%yin! "ajor

trans%or"ations t7at *ill beco"e pro!ra"s in syste" desi!n so it is t7e startin! point

o% speci%ication do*n to t7e lo*est level o% detail9 A ,F,s consists o% a series i%

bubbles joined by lines9 T7e bubbles represent data trans%or"ation and t7e lines

represent t7e data %lo* in t7e syste"9

DFD SY-BOLS#

A syste" de%ined a source or destination o% data9

An arro* identi%ies data %lo*: data in "otion9

A circle represents t7e process t7at trans%or"s inco"in! data %lo* to out!oin!

data %lo*9

An open rectan!ular is data storedata at rest or a te"porary repository o% data9


22/49


SYSTE- DATA FLO+ DIAGRA-

TRANSACTIONS ACCOUNT

HOLDERSBANKING

DATABASE


23/49


E1R DIAGRA-#


24/49



25/49


0"odelin! is a data "odelin! tec7ni;ue used in so%t*are en!ineerin! to produce a

conceptual data "odel o% a in%or"ation syste"9 ,ia!ra"s created usin! t7is 0"odelin!

tec7ni;ue are called 0ntityelations7ip ,ia!ra"s: or 0 dia!ra"s or 0,s9 +o you can say

t7at 0ntity elations7ip ,ia!ra"s illustrate t7e lo!ical structure o% databases9

,r9 $eter .7en is t7e ori!inator o% t7e 0ntityelations7ip odel9 His ori!inal paper about

0"odelin! is one o% t7e "ost cited papers in t7e co"puter so%t*are %ield9 .urrently t7e 0

"odel serves as t7e %oundation o% "any syste" analysis and desi!n "et7odolo!ies:

co"puteraided so%t*are en!ineerin! >.A+0? tools: and repository syste"s9

T7e ori!inal notation %or 0,ia!ra"s uses rectan!les to represent entities: and dia"onds to

represent relations7ips9

T7ere are t7ree basic ele"ents in 0,ia!ra"sJ

0ntities are t7e Lt7in!sL %or *7ic7 *e *ant to store in%or"ation9 An entity is a person:

place: t7in! or event9


26/49


Attributes are t7e data *e *ant to collect %or an entity9

elations7ips describe t7e relations bet*een t7e entities9

0,s s7o* entities in a database and relations7ips bet*een tables *it7in t7at database9 It is

essential to 7ave 0,ia!ra"s i% you *ant to create a !ood database desi!n9 T7e dia!ra"s

7elp %ocus on 7o* t7e database actually *ors9

0ntity >Instance?

An instance o% a p7ysical object in t7e real *orld9

0ntity .lass

J roup o% objects o% t7e sa"e type9

O

09!9 0ntity .lass M+tudentN: 0ntities MDo7nN: MTris7N etc

Attributes

$roperties o% 0ntities t7at describe t7eir c7aracteristics9

TypesJ

+i"ple

J Attribute t7at is not divisible: e9!9 a!e9

.o"posite

J Attribute co"posed o% several si"ple attributes:

e9!9 address >7ouse nu"ber: street: district?


27/49


ultiple

J Attribute *it7 a set o% possible values %or t7e sa"e

entity: e9!9 $7one >7o"e: "obile etc9? or e"ail

Bey

J ni;uely Ids t7e 0ntity e9!9 $$+=: .7assis =o9

0ac7 si"ple attribute associated *it7 a )+ t7at "ay be assi!ned to t7at attribute %or eac7

individual entity:

e9!9 a!e P inte!er


28/49


DATABASE SPECIFICATIONS

Fiel/ Nae T64e Constraints

AccountQ=o Int $ri"ary Bey

'ranc7Q=o )arc7ar>#? e%erences 'ranc7QIn%o>'ranc7Q=o?

'ranc7Q=a"e )A.HA>C@? =ot =ull

AccountQHQType )arc7ar>1C? =ot =ull

=oQAccountQH )arc7ar>C? =ot =ull

+aluationQF )arc7ar>C? =ot =ull

=a"eQ$Q(QF )arc7ar>C@? =ot =ull

FaQ=a"eQF )arc7ar>C@? =ot =ull

enderQF )arc7ar>6? =ot =ull

,('QF ,ateTi"e =ot =ull

A!eQF )arc7ar>3? .7ec>A!eQFRP@ and A!eQFS1@@?

(ccupationQF )arc7ar>1C? =ot =ull

$7otoQF I"a!e =ot =ull

+i!nQF I"a!e =ot =ull

AddressQF )arc7ar>1@@? =ot =ull

$7Q=oQF )arc7ar>11? =ot =ull

obQ=oQF )arc7ar>14? =ot =ull

+aluationQ+ )arc7ar>C?

=a"eQ$Q(Q+ )arc7ar>C@?

FaQ=a"eQ+ )arc7ar>C@?

enderQ+ )arc7ar>6?


29/49


,('Q+ ,ateTi"e

A!eQ+ )arc7ar>3? .7ec>A!eQ+RP@ and A!eQ+S1@@?

(ccupationQ+ )arc7ar>1C?

$7otoQ+ I"a!e

+i!nQ+ I"a!e

AddressQ+ )arc7ar>1@@?

$7Q=oQ+ )arc7ar>11?

obQ=oQ+ )arc7ar>14?

+aluationQT )arc7ar>C?

=a"eQ$Q(QT )arc7ar>C@?

FaQ=a"eQT )arc7ar>C@?

enderQT )arc7ar>6?

,('QT ,ateTi"e

A!eQT )arc7ar>3? .7ec>A!eQTRP@ and A!eQTS1@@?

(ccupationQT )arc7ar>1C?

$7otoQT I"a!e

+i!nQT I"a!e

AddressQT )arc7ar>1@@?

$7Q=oQT )arc7ar>11?

obQ=oQT )arc7ar>14?

AccountQType )arc7ar>2C? =ot =ull

5itnessQ=a"e )arc7ar>C@? =ot =ull

5itnessQ+i!n I"a!e =ot =ull

=o"ineeQel )arc7ar>1@? =ot =ull

=o"ineeQ=a"e )arc7ar>C@? =ot =ull

=o"ineeQ+i!n I"a!e =ot =ull

(penin!Q'al )arc7ar>1@?


30/49


TQ,ate ,ateTi"e =ot =ull

SO+T ANALYSIS#

+5(T analysis is an acrony" t7at stands %or stren!t7s: *eaness: opportunities: and t7reats

+5(T analysis is care%ul evaluation o% an or!aniation


31/49


=eutraliin! it t7reats

Avoidin! or correctin! its *eaness

+5(T analysis is one o% t7e "ost i"portant steps in %or"ulatin! strate!y usin! t7e

or!aniation "ission as a context: "ana!ers assess internal stren!t7s distinctive co"petencies

and *eaness and external opportunities and t7reats9 T7e !oal is to t7en develop !ood

strate!ies and exploit opportunities and stren!t7s neutralie t7reats and avoid *eanesses9

STRENGHTS

='$ one o% t7e lar!est %inancial institutions o% $aistan *it7 ei!7t "illion o% custo"er

base ='$ 7olds 2496 s7are o% ti"e and de"and deposits in t7e country9 -ocal currency

deposits co"prise 6# o% banEs total deposits *7ile %orei!n currency deposits account

%or t7e rest9

='$ 7as an extensive do"estic branc7 net*or o% 12C4 branc7es located all over

$aistan9 T7e 'an also 7as a presence in 23 international locations includin! t7e +A:

nited Bin!do": 0urope and t7e Far 0ast9

='$Es total assets stood at $a s93#@ billion on ,ece"ber 2@@89 T7is included total

earnin! assets o% about $a s9268 billion *it7 !ross loan port%olio o% $a s914@ billion9

T7e ban also 7as an invest"ent port%olio o% $a s9&1 billion: *7ic7 co"prises treasury

securities: corporate bonds: s7ares and ot7er securities9


32/49


='$ cas7 provision as percenta!e o% non per%or"in! loans e;ual to 6@ t7is covera!e

%actor %or t7e non per%or"in! loans is t7e 7i!7est a"on!st t7e nationalied co""ercial

ban9

='$ is *orin! as ri!7t ar" !overn"ent o% $aistan as it is responsible %or all clai"s o%

!overn"ent %or recovery as *ell as pay"ent9 All depositor o% ='$ are in relie% t7at t7eir

"oney security is !uaranteed by !overn"ent o% $aistan9

It acts as an a!ent o% t7e .entral 'an *7erever t7e +tate 'an does not 7ave its o*n

'ranc79

T7e *orin! condition in t7e ='$ branc7 7ere is very conductive and %avorable %or better

output9 T7e in%or"al environ"ent a%%ects t7e per%or"ance o% t7e e"ployees in a positive*ay9

$er%or"in! social responsibilities and clai"in! MT7e =ation


33/49


nsatis%actory corporate culture o% t7e 'an

$7ysical environ"ent and at"osp7ere co"pare to ot7er bans is not "eet t7e standard

-ess nu"ber o% (nline 'ranc7es

Ine%%ectively use o% tec7nolo!ies i9e9 In%or"ation tec7nolo!y

+7orta!e o% sta%% per e"ployee custo"er is very 7i!7 side

Tec7nical education and trainin! o% sta%% is insu%%icien T7e *orload in ='$ is not evenly

distributed and t7e *orload tends to be "ore on so"e e"ployees *7ile ot7ers abscond

a*ay %ro" t7eir responsibilities: *7ic7 server as a de"otivation %actor %or e"ployees

per%or"in! above avera!e *or9

In ='$ t7e individual di%%erence 7ave stron! i"pact on t7e or!aniation


34/49


0arnin! co""issionUexc7an!e on overn"ent transactions9

A"on!st 7i!7est ban is Asia: ='$ %urt7er expand its services proudest and earn "ore

pro%it9

T7e ban is res7apin! its port%olios by investin! into 7i!7er area o% !ro*t7 developin!

core co"petin! as a result to !et "axi"u" return9

I9T and H are i"portant %actors %or develop"ent in any or!aniation: ='$ continue

stru!!le to ac7ieve t7is tar!et9

THREATS

+'$ penalties due to lo* internal control and co"pliance9

overn"ent: +'$ and $rudential ules and e!ulations9

+c7edule bans and ultinationalUInternational ban


35/49


+'$ rated just Mar!inalN in respect o% +yste" K .ontrol *7ic7 is alar"in! %or t7e 'an

to survive its license9

='$ sta%% code o% et7ics and practices9

Hi!7 nu"ber o% co"plaints re!ardin! sta%% be7avior9

overn"ent +c7e"es: overn"ent evenue .ollection: overn"ent9

$ay"ents and F' .ollections create 7eavy *orload9

ORGANIZATIONAL STRUCTURE

In National Bank of Pakistan, the hea is calle !Chair"an# or !Presient# of the

Bank$ %n after Presient there is &i'e Broa of Directors$ National Bank of

Pakistan has ele'en Grops hich control the orkin* of the Di'isions, Win*,

Depart"ent, Section an Re*ional of the national +ank of Pakistan$ In NBP,

!Depart"ent# is calle !Win*s#$


36/49


National +ank of Pakistan i'ie their task in to separate jo+s$ Basicall national

Bank of Pakistan ha'in* i-erent *rops, an each *rop perfor" i-erent task

speciali.ation in their epart"ent$ National Bank of Pakistan Cate*ories their

epart"ents thro*h their ork speciali.ation$ %n NBP hire their e"ploees

also thro*h ork speciali.ation$ /he folloin* Chart shos the Work

Speciali.ation in the +ank$ 0RM 1 %"inistration, 2peration, Co""ercial 1

Retail Bankin*, an I$/ Grop are perfor"in* i-erent orkin* in the

2r*ani.ation$

Chairman &

President

Board of

Directors

Presidents

Secretariat

Secretary

Board of


37/49


Compliance

Group

Audit &

Inspection

Group

Credit

Management

Group

Corporate &

Investment

Baning Group

Commercial &

!etail Baning

Group

"reasury

Management

Group

#peration

Group

$!M &

Administration

Group

Special Assets

Management

Group#verseas

Management

Group

I%"% Group

Co""ercial

1 Retail

Bankin*

0RM 1

%"inistratio

n Grop

I$/$ Grop2peration

Grop


38/49


National Bank of Pakistan is strctrall i'ie into Grops an *rops are also

s+i'ie into Depart"ents, Win*s, an Di'isions$ National Bank of Pakistan

has i-erent Depart"ent in the Grop an each epart"ent perfor"in* ork, as

their task assi*n$ Depart"ent also s+i'ie into orkin* +ases$

G#G!AP$IC DPA!"M'"

Creit Mana*e"ent

Grop

Creit

Monitorin*

%"inistrati

on Win*Creit Polic

1 SM3 Win*

Instrial

Research

Special %ssets

Mana*e"ent Grop

Geo ra hic De tt


39/49


P!#CSS DPA!"M'"

C(S"#M! DPA!"M'"

S%MG 4

0ea 25ce

S%MG 4 SothS%MG 7

North

Co"pliance Grop

%"inistratio

n Win*

SBP

Inspection

Market 1

8i9iit

Creit Risk

2peration Grop

(Csto"er

&inancialCsto"er

&acilitation 1Csto"er


40/49


National Bank of Pakistan (NBP) pro'ies Ser'ices thro*h "ore than :;


41/49


National Bank of Pakistan is relati'el Wie span of control an &lat Strctre$

National Bank of Pakistan are less laers of "ana*e"ent to pass a "essa*e

thro*h, so the "essa*e reaches "ore e"ploees faster$ More skillfl Grop

Chief Mana*ers can control a *reater n"+er of e"ploees$ National Bank of

Pakistan assess that the internal Control en'iron"ent is shoin* si*ns of

i"pro'e"ent as co"pare to pre'ios ear in all areas of the Bank$

$ead *$ead +$ead ,$ead -$ead .

Branch , Branch + Branch *Branch -Branch .

C% M

$!M #peration CMG

Admn%C% M

"MG

"ech" & SI!D )ing#D )ing Adm

Chairman &


42/49


National Bank of Pakistan is ha'in* Decentrali.ation in the Bank$ %n *i'e the

athorit of Decision Makin* to their Grop Chief of e'er Grop, to take

ecision, hich is +ene>t for the 2r*ani.ation$ National Bank of Pakistan pro'ies

facilit of "akin* ecision to their Senior ?ice Presient as ell as ?ice Presient

of the e'er Grop$

National Bank of Pakistan has lo &or"ali.ation in the +ank$ %n 3"ploees are

free to take action or ecision in their ork speciali.ation$ 3"ploees are follo

the rles an re*lation in the +ank is 'er little for"ali.e$ 3"ploees@ +eha'ior

is little +it *ie + rles an re*lation$

National Bank of Pakistan follo the 2r*anic Moel 2r*ani.ation$ In NBP, there

are Cross7 &nctional tea"s, as ell as Cross7hierarchical tea"s$ /here are freeAo of Infor"ation an Wie span of Control$ NBP is Decentrali.ation in natre

an 'er lo for"ali.ation in the +ank$ Basicall National Bank of Pakistan is

hi*h Dia*onal Di-erentiation an e'er e"ploee of an epart"ent can easil

co""nicate to other epart"ent of the Bank$

Grade #/cers

0Group1

President

0'BP1

A2P 0Group1

S2P or 2P

0Group1

Group Chief

0Group1


43/49


BRANCH HIERARCHY#

M%N%G3R

M%N%G3R 2P3R%/I2N

3S/%B8IS0M3N/

2&&IC3R GR%D3 7 I


44/49


=u"ber o% 0"ployees 1C

=a"e o% ana!er Abdulla7 unir

=a"e o% (perations ana!er 9 a%i

ISSUES FACED BY THE BRANCH#

i9 Trainin9#='$ 7as no !reat %acility %or t7eir e"ployees %or trainin! o% ne*

tec7nolo!ies9 T7is situation creates di%%iculty %or 7andlin! ne* c7allen!e9

ii9 De4artentali;ation#An e"ployee deals various nature o% *or9

iii9 Staff Attit0/eJ ,ue to 7eavy load o% *or sta%% attitude does not ideal %or an

or!aniation *7ere public dealin! is at lar!e scale9

2&&IC3R GR%D3 7 II

2&&IC3R GR%D3 7 III

M3SS3NG3R

P32N

SW33P3R


45/49


iv9 +ork En"ironent#5or environ"ent *as not ideal due to 7eavy custo"ers visit in

a sin!le day9 Furniture: li!7t and sittin! arran!e"ent *as not !ood %or custo"ers and

ban e"ployees9

v9 Professional A44roa!8J 5or specialiation and job speci%ication are %ound very lo*

in ban


46/49


RECO--ENDATIONS#

As analysis s7o*s t7at ='$ is a "ost !ro*in! or!aniation *it7 7i!7est return on capital: T7e

ban 7as been able to strate!ically "ana!e and build on its co"petitive advanta!e: by no*in!

custo"er


47/49


T7e 'an s7ould increase pro%it rate on deposits and savin! sc7e"es especially %or

pensioners and old a!e citiens9

For i"prove"ent o% internal control and syste" t7e co"pliance *in! and surprise inspection

syste" s7ould *or "ore e%%ectively9

T7e ban s7ould use broad castin! "edia %or pro"otion o% its products and services and to

%urt7er expand its area t7rou!7 "ore a!!ressive "aretin!9 .usto"er services "ust be better

to i"prove t7e e%%iciency o% branc7: *7ic7 results in ;uality *or and causes t7e custo"er

attraction t7at *ill create lucraturable activities9

T7ese and "any ot7er t7at can "ae a !ood set o% reco""endations: *7ic7 7ave to be "adepossible to escape %ro" t7e t7reats and *eanesses and t7e riss in environ"ent t7at surrounds

t7e 'an9 T7e "ana!e"ent do considers t7e policy "atter t7at is not 7elpin! t7e 'an: but are

still in practice due t7e absence o% prudentially re!ulated syste" to protect t7e" and t7e 'an9

0%%orts 7ave been "ade *it7 serious concern to !ive ='$ a status t7at it 7as to "aintain by

7avin! practices o%J

i!7t siin! o% t7e e"ployees9

'y closin! unpro%itable branc7es9

'y introducin! a "erit based selection criteria9

$ro"otions "ade conditional *it7 ;uali%ications9

CONCLUSION#

The primary objective of NBP was to purchase jute %ro" t7e !ro*ers in t7e %or"er 0ast

$aistan and also to per%or" t7e co""ercial banin! %unctions in t7e country9

[Type text]


48/49


T7e stren!t7 o% t7is ban is t7at it is actin! as A!ent o% +tate 'an o% $aistan: providin!

A!ency Arran!e"ents %or di%%erent !overn"ent or!aniations include 5A$,A and $IA:

$ro%itability and a vide covera!e t7rou!7out $aistan9

T7e c7allen!e it is %acin! is currently t7e lac o% i"ple"entation o% rules and re!ulations

t7at "ay lead to *ea or!aniational culture: old or!aniational culture: no re!ular

pro"otions practices and not "uc7 use o% IT tec7nolo!y in ban as ot7er are usin!9

As analysis s7o*s t7at ='$ is a "ost !ro*in! or!aniation *it7 7i!7est return on

capital: lar!est "aret s7are a"on!st all $aistani bans and cost to inco"e ratio is t7e

7i!7est in banin! sector9 'ut t7ere is %urt7er need %or i"prove"ent to overco"e

*eanesses and to "aintain its position as an MAsian Ti!erN in banin! %ield9

BIBLIOGRAPHY AND REFERENCES#

BOO)# 1

[Type text]


49/49


'lac 'oo on )isual 'asic 9=et 2@@3 'y +teven Holner

ELRCTRONICS REFERENCES#

+EBSITES# 1

5559-(I.AT5(B9I=F(

5559+-I,0+HA09.(

5559+.I',9.(

SEARCH ENGINES# 1

GAH((: +=: ((-0 etc9
http://www.logicatwork.info/http://www.slideshare.com/http://www.logicatwork.info/http://www.slideshare.com/

dbms nbp project report

Documents