company internal main server

8/18/2019 company internal main server

http://slidepdf.com/reader/full/company-internal-main-server 1/58

A

TRAINING REPORT

“Company Internal Mail Server”

(PHP)

At

GORAL TECHNOLOG P!T" LT#"

Submitted In partial fulfillment of requirementfor the Degree of

$ACHELOR O% TECHNOLOG

IN

COMPTER SCIENCE AND ENGG!

"#$

AARTI%&'&()''*

Department of COMPTER SCIENCE AND ENGG

+ar#ana Engineering College, -agadhri, +ar#ana, India



.uru/0hetra ni1er0it#, .uru/0hetra, +ar#ana



AC&NO'LE#GEMENT

There is always a sense of gratitude which everyone express to others for

the helpful and needful services they render during difficult phases of lifeand help to achieve the goals already set. The submission of this project

report gave me an opportunity to convey my gratitude to all those who

have helped me to reach a stage where I have immense confidence to

launch my career in the competitive world of information-technology.

I too, want to express my deep gratitude to each and everyone who has

been helpful to me is getting this task of project handling to be

successful. I would like to express over profound gratitude toMr .Anil

Lamba, Head of Deptt. Comp.Sc. and Applications, Haryana

Engineering College, Jagadhri, as my project guide. He was ever willing

to give all kind of support and encouragement. His assistance and

encouragement all through my project work has left a lasting impression

in my life. Under his guidance this project never poses a problem to me.

Iexpress my profound thanks toMr. Neeraj Chhabra(Director),Goral

Technology for allowing me to undergo training at his prestigious

organization.

I am also thankful to all my friends who help me in making this project a

real success and my parents and family who have given me all the

support what so ever.

(Aarti)



TA$LE O% CONTENTS

Certiiate

A*no+le,-ement

Company Proile

Preae

Intro,.tion a/o.t PHP

Intro,.tion a/o.t E0i1tin- Sy1tem

Propo1e, Sy1tem

%a* Ad1antage0 of Propo0ed 0#0tem

%ea1i/ility St.,y

Re2.irement Speiiation

Sy1tem #e1i-n

%a* Module Chart

%b* Data 2lo3 Diagram

%4* Data "a0e De0ign

%d* Data Di4tionar#

%e* Entit#5Relation0hip Diagram

Snap13ot1

Te1tin-

Implementation

%a* +o3 to 6oad it

%b* Change O1er

%4* 0er Manual

Sy1tem Maintenane

%.t.re Sope

Conl.1ion

6imitation0 of the S#0tem

Reerene1



COMPAN PRO%ILE

Goral Te3nolo-y (P) Lt,"An ISO 7((&$ 8((' Certified Compan#

Conta4t $ 8

nd

2loor, .ri0hna Comple9, P#ara Cho3/, :amuna Nagar!+elpline $ (&;)85<=<=)<, 7'7<&5(()=(, '(>75((()=(

Web: www.goraltechnology.com , Email : [email protected]

GORAL Te3nolo-y (GTe3) P1t! 6td!, :NR i0 a IT Solution0 ba0ed Pri1ate 6imited

Compan#, Spe4iali?ed in the area0 of Soft3are @ eb0ite De1elopment, Soft3are

Training, Soft3are Edu4ation, E5"u0ine00 Solution and Con0ulting! GORAL Te3nolo-y

%GTe4h* offer0 -ob5Oriented Soft3are Training Program0 to M!S4 %CSE, IT* B MCA

Candidate0, 3hi4h are 3ell5planned /eeping in mind the indu0tr# requirement0 and future

pro0pe4t0!

Te4hnolog# 3e are offering for Indu0trial Training Program0 1i? ASP!Net =!( u0ing C

ith S6 Ser1er, Sil1er 6ight =!(, P+P >!) u0ing M:S6 B -AA!

6oo/ing for 3eb de0ign and de1elopment firmF

e offer profe00ional 3eb de0ign and de1elopment 0er1i4e0 in India! eb0ite de0ign,

graphi4 de0ign, 3eb0ite ho0ting and 0ear4h engine optimi?ation 4ompan# 0pe4iali?ing in

great 0er1i4e at affordable pri4e0! e are 6eader0 in deli1ering high end 3eb de0ign B

de1elopment 0er1i4e0! Affordable 3eb0ite de0ign 0olution0 to it0 e0teemed 4lient0!

Goral Te4hnolog# i0 a profe00ional 3eb

de1elopment B eb0ite de0igning 4ompan# operating from :amuna Nagar, +ar#ana,

India! e offer affordable 3eb0ite de1elopment B eb De0ign 0er1i4e0! hether it0 an

Internet mar/eting 3eb0ite to rai0e 4u0tomer a3arene00 of 0er1i4e0 and produ4t0, an

e4ommer4e 3eb0ite de1elopment to po3er 0ale0, 3eb5ba0ed tool to 0treamline 4ompan#

operation0, 4orporate identit# de1elopment to enhan4e 4ompanie0 outloo/ or 4u0tom

0oft3are de1elopment to help bu0ine00 run 0moother, eMa1en0 ha0 the e9perien4e ande9perti0e to deli1er and e94eed e9pe4tation0! e pro1ide all 3eb 0er1i4e0 in4luding

0ear4h engine Mar/eting B SEO 0er1i4e0 for 0mall to big50i?ed bu0ine00e0 a4ro00 the

globe!

e at Goral Te4hnolog# mainl# fo4u0 on ne3 te4hnologie0 in 3eb

appli4ation0! Our profe00ional 3eb de1elopment 0er1i4e 0uit0 e1er# bu0ine00 in e1er#

http://www.goraltechnology.com/

mailto:[email protected]

mailto:[email protected]

http://www.goraltechnology.com/



area no matter 3hether it i0 0mall or big! e 0pe4iali?e in de1eloping 0imple to 4omple9

3eb appli4ation0 at an affordable pri4e 3ith right mi9 of ae0theti4 loo/0 and ea0#

na1igation and 4an optimi?e an# 3eb0ite from 0mall per0onal 0ite0 to databa0e dri1en

4orporate 3eb0ite! Our profe00ional 3eb de1elopment 0er1i4e portfolio 0eparate0 u0 from

other0! e ha1e a de4ade of 3eb de1elopment e9perien4e 3hi4h ma/e0 pride about our

0er1i4e0! e ha1e 0ati0fied 4lient0 all o1er the globe 3ho al3a#0 rel# on Goral

Te4hnologie0 for de1eloping their bu0ine00 3eb0ite0! e al3a#0 4ommit to deli1er

0er1i4e0 timel# and at #our budget!

Goral Te4hnolog# 3or/0 on all 3eb0ite de0igning and rede0igning under #our bu0ine00

requirement! e /no3 that #our bu0ine00 i0 important to #ou and 0o ea4h 3eb0ite de0ign

i0 done /eeping #our bu0ine00 in mind! e /no3 3hat qualit# a profe00ional 3eb0ite

de0ign mu0t ha1e in order to be 0u44e00ful!

E54ommer4e 3eb0ite0 are the late0t trend in online bu0ine00! If #ou 3ant #our bu0ine00 to

mo1e 0moothl# and online then itH0 a mu0t to ha1e an e4ommer4e 3eb0ite for #our

bu0ine00! No3 a da#H0 people pur4ha0e0 and e1er#thing i0 online, 3hi4h 0a1e0 their

1aluable time! Thi0 ma/e0 all bu0ine00 o3ner0 to go for an ea0# online 0hopping 4art

3eb0ite0!



PRE%ACE

Computer0 are re1olutioni?ing e1er# a0pe4t of our life! The offi4e0 3here 3e 3or/, the

0tore0 3here 3e 0hop, the 04hool0 and the 4ollege0 3e attend, the ban/0 that handle our mone#, the de1i4e0 3e u0e in our home and in e1er# area of our life are being radi4all#

altered b# 4omputer0!

E1en ne3 in1ention0 B di04o1er# i0 0omeho3 related to 4omputer0! Computer0 ha1e

4hanged manH0 life! "e0ide0 home 0hopping or maintaining re4ord0 e1en toda# 4omputer

4hip0 are being implanted in humanH0 bod# that identifie0 #ou uniquel# !Computer0 u0age

i0 gro3ing b# leap0 and bound0 in bu0ine00, indu0tr#, go1ernment, 4ollege0, 04hool0 and

other in0titute0 !In the modern era of 04ien4e and te4hnolog# a0 a po3erful nation, India

i0 0till legging behind due to di05ad1an4ement in 4omputer te4hnologie0! Thi0 problem

4an be o1er4ome onl# 3hen the #outh of India of the pre0ent generation gi1e full 4o5

operation in ri0ing India a0 a po3erful nation b# learning more and more 4omputer!

In e1er

3idening modern 3orld, the pre0ent 0#0tem of edu4ation i0 fa4ing ne3 4hallenge0! It i0

3ell /no3n fa4t that toda# i0 the age of 4omputer0! The maor a4hie1ement of 04ien4e

and te4hnolog# !No35a5da#0 e1er#one i0 reali?ing the importan4e of 4omputer 3hi4h of

modern age in fifth generation of 4omputer0!

So, reali?ing thi0 fa4t and a44ording to time demand 3hen 4omputer0 are ne4e00ar# and

important a4hie1ement, I ha1e 4ho0en thi0 profe00ional 4our0e $"Te3 from

&4R4&SHETRA 4NI!ERSIT 5 &4R4&SHETRA"

Thi0 4our0e i0 aimed

at ma/ing 0tudent0 a 4omplete and 0elf reliant programmer! e are gi1en all the needed

.no3ledge about the 0tru4ture and the ba0i0 of 4omputer0 at fir0t 0tage B then 0tud# of

1ariou0 bu0ine00 requirement0 i0 in1ol1ed in the la0t 0eme0ter a0 proe4t 3or/! Thu0

4andidate i0 e9po0ed to real time en1ironment! The 0tudent0 are al0o gi1en proper

/no3ledge of 1ariou0 4omputer language0 0o a0 to do programming to 4hange an#

manual atmo0phere to a 4omputeri?ed 0#0tem!



The# ha1e to 3or/ in an# organi?ation and ha1e to 4hange a manuall# 3or/ing 0#0tem in

a 4omputeri?ed 0#0tem 0o that the# are able to under0tand the problem0 ari0ing out of

0u4h an en1ironment!



INTRO#4CTION A$O4T PHP

• P+P i0 an a4ron#m for JP+P +#perte9t Prepro4e00orJ

• P+P i0 a 3idel#5u0ed, open 0our4e 04ripting language

• P+P 04ript0 are e9e4uted on the 0er1er

• P+P 4o0t0 nothing, it i0 free to do3nload and u0e

'3at i1 a PHP %ile6

• P+P file0 4an 4ontain te9t, +TM6, CSS, -a1aS4ript, and P+P 4ode

• P+P 4ode are e9e4uted on the 0er1er, and the re0ult i0 returned to the bro30er a0

plain +TM6

• P+P file0 ha1e e9ten0ion J!phpJ

'3at Can PHP #o6

• P+P 4an generate d#nami4 page 4ontent

• P+P 4an 4reate, open, read, 3rite, and 4lo0e file0 on the 0er1er

• P+P 4an 4olle4t form data

• P+P 4an 0end and re4ei1e 4oo/ie0

• P+P 4an add, delete, modif# data in #our databa0e

• P+P 4an re0tri4t u0er0 to a44e00 0ome page0 on #our 3eb0ite

• P+P 4an en4r#pt data

'3y PHP6



• P+P run0 on 1ariou0 platform0 %indo30, 6inu9, ni9, Ma4 OS K, et4!*

• P+P i0 4ompatible 3ith almo0t all 0er1er0 u0ed toda# %Apa4he, IIS, et4!*

•

P+P 0upport0 a 3ide range of databa0e0

• P+P i0 free! Do3nload it from the offi4ial P+P re0our4e$ 333!php!net

• P+P i0 ea0# to learn and run0 effi4ientl# on the 0er1er 0ide

Intro,.tion to E0i1tin- Sy1tem

The e9i0ting 0#0tem of mailing i0 manual! In the e9i0ting 0#0tem, the 0ender ha0 to 3rite

all the mail0 manuall# on the paper and then 0end the me00age! If a me00age ha0 to be

0end to man# per0on0, then 3riter that me00age again B again for e1er# u0er! The time

required for 4on1e#an4e of me00age i0 1er# large! In the 4ompan# if a me00age for

meeting ha0 to be 0ent, then 3rite that me00age and get 0ign on the paper of e1er#

emplo#ee in the meeting! The reminder mail0 4an al0o be 0ent to the emplo#ee0! Thee9i0ting 0#0tem of mailing ha0 the follo3ing limitation05

• No G4I /a1e,78 The e9i0ting 0#0tem i0 not GI ba0ed! It i0 handled manuall#!

• Improper 3an-e178 In the e9i0ting 0#0tem, 0in4e e1er# mail i0 3ritten on paper,

0o it i0 1er# in4on1enient to modif# data! If the no! mi0ta/e0 are high, then the

3hole do4ument ha0 to be 3ritten again!

• Time 9 reeivin- pro/lem178 To 3rite a mail on paper, i0 time 4on0uming! The

duration for arri1ing mail i0 al0o 1er# long B it i0 al0o po00ible that it ma# not be

rea4hed at the re4ei1er! If a 0ingle mail i0 to be 0end to man# per0on0, it 3ill be

1er# he4ti4 to 3rite that mail again B again!

• No 4onfirmation of mail 0ent!



• Effe4ted b# en1ironmental fa4tor0!

• There i0 no problem related to li0t or damage of mail0!



PROPOSE# SSTEM

“INTERNALMAIL"ORG” i0 an LCOMPAN INTERNAL MAIL SSTEM! Thro3

thi0 3e 4an /no3 ho3 mailing i0 done 3ithin a 0ingle 0er1er! The admini0trator regi0ter0

the u0er0 and a00ign0 u0ername and pa003ord to the u0er0! The u0er0 after re4ei1ing

u0ername and pa003ord, login to their a44ount and mail to ea4h other! COMPAN

INTERNAL MAIL SSTEM i0 an ea0# to u0e appli4ation 3hi4h i0 helpful for the u0er

for da#5to5da# requirement0!

There are ) 1ie30 $

:" GENERAL !IE'7 General 1ie3 4ontain0 the follo3ing module05

HOME7 it 4ontain0 general information about the 0ite!

#E!ELOPER;S #ETAIL7 i0 al0o in the general 1ie3 !It 4ontain0 information

about the De1eloper0!

%EE#$AC&7 The 0ugge0tion0 B feedba4/ are al3a#0 important! The u0er0 4an

gi1e their u0eful 0ugge0tion0 B feedba4/ for the 0ite that 4an be helpful for

impro1ing the qualit# of the 0ite!

LOGIN7 If the u0er i0 an authori?ed u0er, he@0he 4an mo1e to the SERIE,

other3i0e he@0he 3ill be on the GENERA6 IE!

<" 4SER !IE' 78 The authori?ed u0er 3ill be on the SER IE! It 4ontain0

follo3ing5

COMPOSE7 If the u0er 3ant0 to 4ompo0e hi0@her o3n mail, he@0he 4an 3rite

mail0 and 0end it out!IN$O= 7 If the u0er 3ant0 to 4he4/ the mail0 he ha0 re4ei1ed from other0, he 4an

4he4/ it in IN"OK! The u0er 4an REP6:@2ORARD@DE6ETE the mail0!

O4T$O=7 If the u0er 3ant0 to 4he4/ the mail0 he ha0 0ent to the other0, he 4an

4he4/ it in OT"OK! The u0er 4an RE5SEND@DE6ETE the mail0!



View

Home

Feedback

General View User

View

Login

Admin

View

Emp info.

Emp Reg.

Contact Us Otbo!

Home

C"ange password

Compose

CHANGE PASS'OR#7 If the u0er doe0nHt 3ant hi0@her pa003ord an# more i!e!

he@0he 3ant0 to 4hange the pa003ord, the# 4an 4hange the pa003ord 1er# ea0il#

u0t b# t#ping O6D PASSORD B then NE PASSORD!

>" A#MINISTRATOR !IE' 7The admini0trator 4ontrol0 the mailing thro3

ADMIN PANE6! The admin al0o ha0 a u0ername B pa003ord thro3 3hi4h he

enter0 in the admin 1ie3! It ha0 the follo3ing 5



EMP REGISTRATION7 The admin fill0 a 0imple regi0tration form B after that

the emplo#ee i0 regi0tered for mailing! In regi0tration form 0ome field0 are

required B 0ome are not required! The admin a00ign0 a unique E5mail ID,

u0ername B pa003ord to the u0er thro3 3hi4h the u0er doe0 mailing!

EMP IN%ORMATION 7The admin ha1e all the information related to

emplo#ee0 in a 0ingle form, 0o he 4an manage the information!



A,vanta-e1 o Propo1e, Sy1tem

•0er5friendl# pa4/age be4au0e it i0 1er# mu4h a44ording to the u0erH0

requirement0! It 3ould ta/e le00 time to get familiar 3ith pa4/age!

• Graphi4al u0er interfa4e %GI* i0 pro1ided to the u0er!

• Effi4ient 3a# of 4apturing data through 3ell5de0ign 04reen0!

• Inbuilt 1alidation 4he4/0 to en0ure that a44urate data i0 onl# entered!

• 2or 0e4urit# purpo0e authenti4ation i0 pro1ided, 0o that unauthori?ed u0er

4anHt u0e manipulate the 0ite!

• In the 0#0tem there i0 no problem of 0pa4e, be4au0e there i0 effi4ient 0pa4e to

u0e!

• Effi4ient B logi4al lin/age of information!

• Suitable help@error me00age for better u0er interfa4e i!e! if u0er ma/e0 0ome

mi0ta/e, the error me00age 3ill be generated!

• A 0ingle mail 3ritten on4e 4an be 0ent to multiple per0on0 3ith little or no

effort!

• nread mail0 and Total mail0 re4ei1ed are 4al4ulated for e1er# u0er!

• 2or 0e4urit# purpo0e, if the u0er 3ant0 to 4hange the pa003ord, he@0he 4an do

thi0 1er# ea0il#!

• The u0er 4an 4he4/ ho3 man# mail0 he@0he 0ent to other per0on0 and if he@0he

3ant0 to re50end an# mail, he@0he 4an re50end it!

• The 3eb50ite i0 an ea0# to u0e appli4ation that 4an be helpful for da#5to5da#

need0!

• The u0er0 4an gi1e their 1aluable 0ugge0tion0 B feedba4/0 betterment of the

0ite!

• Than/0 me00age i0 gi1en to the feedba4/ B 0ugge0tion0 gi1er!

• The admini0trator 4an manage all the information related to the mailing u0er0

i!e! he 4an regi0ter@delete the u0er0!



• To 4ompo0e mail, the 0ender 4an 0ele4t the re4ei1erH0 addre00 from li0t bo9

1er# ea0il#!

• Change0 are 1er# mu4h ea0# to ma/e in mail0!

•

Mail i0 0ent 3ithin a 0e4ond that lead0 to 0a1ing of time!• Immediate 4onfirmation of mail 0ent i0 there!

• Not effe4ted b# en1ironmental fa4tor0!



%ea1i/ility St.,y

2ea0ibilit# 0tud# in1ol1e0 anal#0i0 of the propo0ed 0#0tem a0 a 4andidate 0olution to the

problem domain 0o a0 to identif#, de04ribe, e1aluate and a00e00 0#0tem and thu0 enabling

to 0ele4t the be0t 0#0tem the 0olution domain! Our 2ea0ibilit# 0tud# mu0t an03er three

/e# que0tion0$ 5

&! I0 there a ne3 and better 3a# to do the ob that 3ill benefit the u0erF

8! hat are the 4o0t0 and 0a1ing0 of the alternati1e0F

)! hat i0 re4ommendedF

The t3o 4on0ideration0 are in1ol1ed in the fea0ibilit# anal#0i0$ te4hni4al and beha1ioral

fea0ibilit#! 6etH0 re1ie3 ea4h 4on0ideration and ho3 it relate0 to the 0#0tem effort!

TECHNICAL %EASI$ILIT7

Te4hni4al 2ea0ibilit# 4an be adudged b# fo4u0ing on the e9i0ting 4omputer 0#0tem and to

3hat e9tent it 4an 0upport the propo0ed 0#0tem! Traditional approa4h to targeted ob

in1ol1e0 a lot of paper3or/ and 4areful and 4on0i0tent 4ommuni4ation of information

regarding dealing0, tran0a4tion a4ro00 all bran4he0 of the 4ompan#! A0 thi0 appli4ation

0er1e0 to automate the entire pro4e00, implementation of thi0 appli4ation 3ould require

in0talling it the 4omputer 0#0tem!

• All that i0 required i0 to in0tall it on a 0ingle 0er1er to 3hi4h an# u0er 4an log on

to and u0e it! Thi0 i0 onl# a one time in1e0tment!

• The 0oft3are required for the propo0ed 0#0tem i0 ea0il# a1ailable in the mar/et!

The 0oft3are and hard3are requirement0 are not 1er# e9pen0i1e!



$EHA!IORAL %EASI$ILIT7

People are inherentl# re0i0tant to 4hange and 4omputer0 ha1e been /no3n to fa4ilitate

4hange! It i0 4ommon /no3ledge that 4omputer in0tallation0 ha1e 0omething to do 3ith

turno1er, tran0fer, retraining and 4hange0 in emplo#ee ob 0tatu0! Therefore it i0under0tandable that the introdu4tion of a 4andidate 0#0tem require0 effort0 to edu4ate, 0ell

and train the 0taff on ne3 3a#0 of 4ondu4ting the bu0ine00! Thi0 i0 true that 3e 3ill ha1e

to ma/e the u0er a3are ho3 the 0#0tem 3or/0, and it 3ill be ea0# a0 table0 3ill appear a0

form0 3hi4h are 4ompatibilit# GI! A per0on ha1ing 0ome /no3ledge about 4omputer

3ill be able to operate the 0#0tem!

Therefore the 4o0t of training the u0er0 3ill be le00! A0 4omputeri?ed 0#0tem lead to

4hange in the emplo#ee ob 0tatu0, therefore 0ometime0 u0er0 or emplo#ee0 oppo0e the

in0tallation of the 0#0tem! "ut thi0 4a0e 3ill0 not be here in thi0 4a0e a0 u0er0 3ill be

ea0il# able to do the 0ame 3or/ 3ith le00 effort and time al0o! The# donHt ha1e to open

different regi0ter0 to ma/e the entr# the# 4an ump from one 3indo3 to another! hen all

the matter0 related to 0#0tem 3ill be e9plained to them, that 3hat benefit the# 3ill be

getting after the in0tallation of the 0#0tem then the# ma# 0tart 0upporting the

management! So after 0tud#ing all 3e 4ome to thi0 point that the 0#0tem i0 4ompletel#

beha1ioral fea0ible!



RE?4IREMENT SPECI%ICATION

SO%T'ARE RE?4IREMENT7

The follo3ing are the 0oft3are required for the proe4t$

• Mi4ro0oft indo30 NT@KP SP58

• amp

• MS Sql Ser1er

• Mi4ro0oft Internet Information Ser1er %IIS* =!(

HAR#'ARE RE?4IREMENT7

The follo3ing are the hard3are required for the proe4t$

• PC 3ith Pentium I or +igher

• >&8 M" RAM or +igher

• Minimum 8( G" hard di0/ 0pa4e!

• CD5ROM %=' K or higher re4ommended*!

• Mou0e or Similar Pointing de1i4e!

The requirement0 of 4lient 3ere5

• To ma/e an authenti4ated 0#0tem, 3hi4h 4an onl# be u0ed b# authori?ed u0er!

• Onl# admin 4an regi0ter u0er0 B he 0hould be able to 0ee the detail of all the

u0er0!

• After login the home page 0hould be 1ie3 profile B if he@0he 3ant0 to 4hange it,



he 4an edit it!

• Appl# 1alidation 4he4/0 3hene1er required!

• The u0er 0hould be able to 4ompo0e mail0!

• The mail0 re4ei1ed b# u0er 0hould be 0ho3n in 0eparate option 3ith total no of

mail0 B unread mail0!

• If the u0er 3ant0 to repl# on 0ome mail, the re4ei1erH0 addre00 0hould 4ome

automati4all# in the relati1e field0!

• If the u0er 3ant0 to 0end 0ome re4ei1ed mail0 to other0, he@0he 0hould be able to

for3ard it!

• If the u0er 3ant0 to 0end a 0ingle mail to multiple per0on0, he@0he 0hould be able

to do thi0!

• The mail0 0ent b# a u0er 0hould be 0ho3n in 0eparate option!

• The option to re50end an# mail 0hould be there!

• The option to delete an# re4ei1er mail0 a0 3ell a0 an# 0ent mail0 0hould be there!

• In the 4ompo0e mail, the 0ender 0hould be able to 0ele4t the re4ei1erH0 E5mail ID

from the li0t bo9!

• The u0ername of an# u0er 0hould ne1er 4hange!

The 4hange pa003ord option 0hould be a1ailable to the u0er!



ADMINISTRATOR TASK

A

ADMINISTRATOR

VIEW

Internal Mailing System

U#ER V$E%

FACILITIES ACCESS BY ALL USERSRE!ISTERED USERS

MAILS BO" USER SETTIN!

C D

B

Sy1tem #e1i-n

Mo,.le C3art7



USER #OME

ADD CONTACTS

EDIT $ROFILE

C#AN!E $ASSWORDD

COM$OSE

INBO"

OUTBO"

VIEW $ROFILE

VIEW CONTACTSC

#OME $A!E

FEEDBACK

CONTACT

SITE MA$SB

A HOME

EMPLOEE REGISTRATION

EMPLOEE IN%ORMATION



#%# (#ATA %LO' #IAGRAM)

Data flo3 diagram i0 graphi4al tool u0ed to de04ribe and anal#?e the mo1ement of data

through 0#0tem manual or automated5 in4luding the pro4e00, 0tore0 of data and dela#0

in the 0#0tem! Data flo3 diagram0 are the 4entral tool and the ba0i0 from 3hi4h other

4omponent0 are de1eloped! The tran0formation of data from input to output through

pro4e00 ma# be de04ribed logi4all# and independentl# of the ph#0i4al 4omponent0

a00o4iated 3ith the 0#0tem! The# are termed logi4al data flo3 diagram0!

Component1 o #%#;17

• #ata %lo+7 Data mo1e in a 0pe4ifi4 dire4tion from an origin to a de0tination in a

form of a do4ument letter, telephone 4all or 1irtuall# an# medium!

• Proe117 People, pro4edure0 or de1i4e0 that are u0ed to produ4e data! The

ph#0i4al 4omponent i0 not identified

• So.re or #e1tination o #ata7 E9ternal 0our4e0 or de0tination0 of data 3hi4h

ma# be people, program0, organi?ation0 or other entitie0, intera4t 3ith the

0#0tem but are out0ide it0 boundar#! The term 0our4e and 0in/ are

inter4hangeable 3ith origin and de0tination!

• #ata Store$ +ere data are 0tored or referen4ed b# a pro4e00 in the 0#0tem! The

data 0tore ma# repre0ent 4omputeri?ed or non54omputeri?ed de1i4e0!



A%ministrat&r

A't(&ri)e% User

INTERNAL MAILIN! SYSTEM

#ATA %LO' #IAGRAM (#%#)7

( 6EE6 D2D( 6EE6 D2D



LO!INUser

O$ERATIONS

*C&m+&se , Vie- In.&/, Vie- O't.&/, A%% C&nta0ts et01

DATEBASE

::STST LE!EL7LE!EL7



User

Administrator

Redirect Login &age

Login

Access

Rig"t

Access

$nValid

Login displa'

<n, LE!EL 7

D2D of the Pro4e00 of 4he4/ing the emplo#ee i0 0ho3n!

alid

Che4/ 0er

Che4/

0erName

B

Pa003ord



E(&LO)EE

REG$#*RA*$O+

,rstname

EmailedGender

Last name

-o

empid

EMP REGISTRATION 7



#ata $a1e #e1i-n7



#ata #itionary7

!aria/le Name P.rpo1e A11oiate, 'it3

Add info 0ed to 0tore E9tra info! about emplo#ee Databa0e

Additional Info" Indi4ate Additional Info! 2orm

Comment0 0ed to 0tore feedaba4/ 4omment0 Databa0e

Comment0 Indi4ate feedaba4/ 4omment0 2orm

Confirm pa003ord Indi4ate ne3 pa003ord 2orm

Date of "irth Indi4ate Date of "irth 2orm

Dob 0ed to 0tore Date of "irth of emplo#ee Databa0e

Email id 0ed to 0tore E5mail id of emplo#ee Databa0e

Email 0ed to 0tore E5mail id of feedba4/ gi1er Databa0e

E5mail ID Indi4ate E5mail ID of feedba4/ gi1er 2orm

E5mail ID%0ername* Indi4ate E5mail ID 2orm

2ather0 Name Indi4ate 2atherH0 name of emplo#ee 2orm



2ir0t name 0ed to 0tore 2ir0t name of emplo#ee Databa0e

2ir0t name 0ed to 0tore 2ir0t name of feedba4/ gi1er Databa0e

2ir0t name Indi4ate 2ir0t name feedba4/ gi1er 2orm

2ir0t name Indi4ate 2ir0t name of emplo#ee 2orm

2rom Indi4ate Email id of 0ender 2orm

2name 0ed to 0tore 2atherH0 name of emplo#ee Databa0e

Gender 0ed to 0tore Gender of emplo#ee Databa0e

Gender Indi4ate Gender of emplo#ee 2orm

6a0t name 0ed to 0tore 6a0t name of emplo#ee Databa0e

6a0t name Indi4ate 6a0t name of feedba4/ gi1er 2orm

6a0t name 0ed to 0tore 6a0t name of feedba4/ gi1er Databa0e

6a0t name Indi4ate 6a0t name of emplo#ee 2orm

Mail 0tatu0 0ed to 0tore Mail 0tatu0 of mail Databa0e

Me00age 0ed to 0tore Me00age of mail Databa0e

Mname 0ed to 0tore MotherH0 name of emplo#ee Databa0e

Mother0 Name Indi4ate MotherH0 name of emplo#ee 2orm

Mobile 0ed to 0tore Mobile no! name of emplo#ee Databa0e

Mobile Indi4ate Mobile no! 2orm

Ne3 pa003ord Indi4ate ne3 pa003ord 2orm

Old pa003ord Indi4ate old pa003ord 2orm

Phone 0ed to 0tore Phone no! of emplo#ee Databa0e

Phone No" Indi4ate Phone no! 2orm

Re4ei1er 0ed to 0tore Re4ei1er of mail Databa0e

Re4ei1er 0tatu0 0ed to 0tore Re4ei1er 0tatu0 of mail Databa0e

Sender 0ed to 0tore Sender of mail Databa0e

Sender 0tatu0 0ed to 0tore Sender 0tatu0 of mail Databa0e

Sube4t 0ed to 0tore Sube4t of mail Databa0e

Sube4t Indi4ate Sube4t 2orm

To Indi4ate Email id of re4ei1er 2orm

0ername 0ed to 0tore 0ername of emplo#ee Databa0e

0er pa003ord 0ed to 0tore Pa003ord of emplo#ee Databa0e



*"e /min0ma!1 notation

't're S0&+e

/2021/3021

/20+1/2021

Entity Relation13ip #ia-ram (ER#)7

The Entit# Relation0hip Diagram %ERD* i0 the graphi4al notation of the

relation0hip bet3een data obe4t and attribute0! The ERD 3a0 originall# propo0ed b#Peter Chen for the de0ign of relational databa0e 0#0tem0 and ha0 been e9tended b# other0!

Primar# 4omponent0 identified for ERD are$

• Data obe4t0

• Attribute0

• Relation0hip

• ariou0 t#pe indi4ator0!

P.rpo1e o ER#

The primar# purpo0e of the ERD i0 to repre0ent data obe4t0 and their

relation0hip!



In.&/ Fa0ilityC&m+&se Fa0ility A%%ress B&&2 Fa0ilityO't.&/ Fa0ility

Has

Fa0ility t& 0reate 'serFa0ility t& see Em+3 listFa0ility t& %elete

$s A $s A

Em+l&yee A%ministrat&r

User &5 System

Has



O4TP4T#e1i-nin- Snap13ot17



R.nnin- Snap13ot17



TESTING

O$@ECTI!ES O% TESTING

: Te0ting i0 a pro4e00 of e9e4uting a program 3ith the intention of findingerror0!

< To perform te0ting, te0t 4a0e0 are de0igned! A te0t 4a0e i0 in parti4ular made up of artifi4ial 0ituation upon 3hi4h a program i0 e9po0ed 0o a0 to

find error0! So a good te0t 4a0e i0 one that find0 undi04o1ered error0!

4nit Te1tin-7

nit te0ting i0 4ondu4ted fir0t! Different module0 of the 0oft3are are te0ted again0t the

0pe4ifi4ation0 produ4ed during de0ign of the module0! erifi4ation of the 4ode produ4ed

during the 4oding pha0e i0 done! Ea4h module i0 te0ted 0eparatel#!

nit te0ting fo4u0e0 1erifi4ation effort on the 0malle0t unit of 0oft3are de0ign module!

Thi0 un4o1er0 error0 3ithin the boundar# of a module! nit te0ting i0 a4tuall# hite bo9

te0ting in 3hi4h both the e9ternal thing0 a0 3ell a0 the internal 4ode0 are te0ted!

nit te0ting 4ompri0e0 the 0et of te0t0 performed b# an indi1idual programmer prior to

integration of the unit into a larger 0#0tem! There are four 4ategorie0 of te0t that 4an be

performed on a program unit! The0e are$

2un4tional nit

Performan4e nit

: Stre00 nit

< Stru4ture nit

The 0tarting point of te0ting i0 unit te0ting! In thi0, a module i0 te0ted 0eparatel#! The

purpo0e i0 to e9er4i0e the different part0 of the module 4ode to dete4t 4oding error0!

ERROR7

The OleDbCommand i0 4urrentl# bu0# Open, 2et4hing

CA4SE7

This error generally ocurrs when dr.read is being used twice without

close the first one by the command dr.close().

CORRECTION$



Thi0 4orre4tion i0 done b# 4lo0ing the fir0t 4onne4tion b# u0ing dr!4lo0e%* be4au0e

datareader 4anHt fet4h the the data 0e4ond time 3ithout 4lo0ing the fir0t one!

ERROR7

E9e4ute Reader require0 an open and a1ailable Conne4tion! The 4onne4tion0 4urrent

0tate i0 Clo0ed!

CA4SE7

Thi0 error o4urr0 3hen 0omeone 4onne4ting to the databa0e and forget to initiali?e the4onne4tion !

CORRECTION7

Thi0 error 4an be remo1ed b# initiali?ing the 4onne4tion b# u0ing 4n!open!

ERROR7

ERROR MESSAGE $ 4annot read table, 0tate of databa0e i0 opened!% STATEOPEN* in

the form login!a0p9!

CA4SE7

Careful in0pe4tion of login form allo3ed to di04o1er that one tin# but 0ignifi4ant line of

4ode 3a0 mi00ing 3hi4h 3a0 4n!4lo0e% *!

Thi0 line of 4ode 4lo0e0 the databa0e 4onne4tion after one quer# ha0 been 0u44e00full#4arried out and ne9t ma# be applied after reopening the databa0e 4one4tion

CORRECTION7

The line 4n!4lo0e% * added in the form 4oding at the appropriate pla4e!

ERROR

Change0 not refle4ted in the databa0e upon 4li4/ing po0t button in the in/o0"a1p0 form!The form upon e9e4ution di0pla#0 enrie0 for the reque0ted 1ouher t#pe and al0o allo3

ma/ing an# 4hange0 in it!

CA4SE$

The error 3a0 found to be partl# logi4al, partl# 0#nta4ti4al! In the 4oding the 4reated

obe4t0 id 3a0nt 0pe4ified!

CORRECTION7

In the +TM6 4oding of the form t3o 3ord0 had to be added for e1er# data obe4t that

0pe4ified their id!

SSTEM TESTING7



In 0#0tem te0ting the entire 0oft3are 0#0tem i0 te0ted! The referen4e do4ument u0ed for

thi0 pro4e00 i0 requirement do4ument and the goal i0 to 0ee if the 0oft3are meet0 it0

requirement0!

S#0tem te0ting in4lude0 the thorough te0ting of the produ4t! It in1ol1e0 unit te0ting,

integration te0ting B a44eptan4e te0ting! Careful planning and 04heduling are required to

en0ure that module0 3ill be a1ailable for integration into the e1ol1ing 0oft3are produ4t

3hen needed! A te0t plan ha0 the follo3ing 0tep0$

& Prepare te0t plan

8 Spe4if# 4ondition0 for u0er a44eptan4e te0ting

) Prepare te0t data for program te0ting

= Prepare te0t data for tran0a4tion path te0ting

> Plan u0er te0ting

< Compile@A00emble program

; Prepare ob performan4e aid0

' Prepare operational do4ument0

In 0#0tem te0ting the entire 0oft3are i0 te0ted !The

referen4e do4ument for thi0 pro4e00 i0 the requirement0 do4ument, and the goal i0 to 0ee

if the 0oft3are meet0 it0 requirement0! Thi0 i0 e00entiall# a 1alidation e9er4i0e, and in

man# 0ituation0 it i0 the onl# 1alidation a4ti1it#!Generall# in thi0 pro4e00 3e pre0ent our

produ4t to the higher authoritie0 in the organi?ation for their 0ati0fa4tion! The# fo4u0e0

on the e9ternal beha1iour the internal logi4 of the program i0 not empha0i?ed!A0 in 4a0e

of our proe4t 3e get it 4he4/ed b# our 4on4erned tea4her0 of proe4t and after their

0ati0fa4tion the 3hole remaining pro4e00 3a0 done!



Implementation

Ho+ to Loa, it

It i0 a eb ba0ed appli4ation named Mailing Ser1er, 3hi4h deal0 the Compan# Internalmail0 o1er the internet! To run thi0 appli4ation, there mu0t be 3eb 0er1er named IIS on

the Ser1er and there mu0t be i0ual Studio 8((' and S6 Ser1er 8((( or higher 1er0ion

on the Ser1er PC! After Completing all +ard3are and Soft3are requirement0, 3e ha1e to

4op# the 4omplete 0ite in IIS 3eb Ser1er and E9e4ute b# the 4ompatible eb "ro30er!

If 3e 3ant to Run o1er the Internet then 3e ha1e to "oo/ a DOMAIN a0 3ell a0 ma/e

the ho0ting o1er the internet ha1ing the fa4ilitie0 of DOTNET 8((' 3ith S6 SERER

8((( or higher, then u0ing the 2TP Detail0 3e ha1e to 4op# the Complete 0ite on the IIS

Ser1er 2older, then b# the eb "ro30er, 3e onl# ha1e to 3rite domain name then m#

3eb 0er1er automati4all# run Default!a0p9 3eb form, after that there are man# related

lin/0 on the fir0t home page and a44ording to thi0 3e ha1e to bro30e and u0e the

4omplete 3eb 0ite!

41er Man.al

To ma/e an authenti4ated 0#0tem, 3hi4h 4an onl# be u0ed b# authori?ed u0er!

Onl# admin 4an regi0ter u0er0 B he 0hould be able to 0ee the detail of all the u0er0!

After login the home page 0hould be 1ie3 profile B if he@0he 3ant0 to 4hange it, he 4an

edit it!

Appl# 1alidation 4he4/0 3hene1er required!

The u0er 0hould be able to 4ompo0e mail0!

The mail0 re4ei1ed b# u0er 0hould be 0ho3n in 0eparate option 3ith total no of mail0 B

unread mail0!

If the u0er 3ant0 to repl# on 0ome mail, the re4ei1erH0 addre00 0hould 4ome automati4all#

in the relati1e field0!



If the u0er 3ant0 to 0end 0ome re4ei1ed mail0 to other0, he@0he 0hould be able to for3ard

it!

If the u0er 3ant0 to 0end a 0ingle mail to multiple per0on0, he@0he 0hould be able to do

thi0!

The mail0 0ent b# a u0er 0hould be 0ho3n in 0eparate option!

The option to re50end an# mail 0hould be there!

The option to delete an# re4ei1er mail0 a0 3ell a0 an# 0ent mail0 0hould be there!

In the 4ompo0e mail, the 0ender 0hould be able to 0ele4t the re4ei1erH0 E5mail ID from the

li0t bo9!

The u0ername of an# u0er 0hould ne1er 4hange!

The 4hange pa003ord option 0hould be a1ailable to the u0er!



Sy1tem Maintenane

Maintenan4e in1ol1e0 under0tanding the e9i0ting 0oft3are %4ode and related

do4ument0*,under0tanding the effe4t0 of 4hange5to both the 4ode and the do4ument05

te0ting the ne3 part0%4hange0*,and rete0ting the old part0 that 3ere not 4hanged! "e4au0e

often during de1elopment the need0 of the maintainer0 are not /ept in mind, fe3 0upport

do4ument0 are produ4ed during de1elopment to help maintainer0! Maintenan4e i0 the t#pe

of 4hange or 0oft3are re3or/ that t#pi4all# i0 done after the 0oft3are de1elopment i0

4ompleted and the 0oft3are ha0 been deplo#ed!

Maintenan4e i0 ba0i4all# of t3o t#pe0$

• Corretive Maintenane$ It i0 4ommonl# belie1ed that the 0tate of the art toda#

i0 0u4h that almo0t all 0oft3are that i0 de1eloped ha0 re0idual error0, or bug0, in

them! Man# of the0e 0urfa4e onl# after the 0#0tem ha0 been de1eloped and ha0

been in operation, 0ometime0 for a long time! The0e error0, on4e di04o1ered, need

to be remo1ed, leading to the 0oft3are getting 4hanged! Thi0 i0 0ometime0 4alled

4orre4ti1e Maintenan4e!

• A,aptive Maintenane7 It ha0 been argued that on4e a 0oft3are 0#0tem i0

deplo#ed, the en1ironment in 3hi4h it operate0 4hange0! +en4e, the need0 that

initiated the 0oft3are de1elopment al0o 4hange0 to refle4t the need0 of the ne3

en1ironment! The 4hanged 0oft3are then 4hange0 the en1ironment ,3hi4h in turn

require0 future 4hange! Thi0 phenomenon i0 0ometime0, 4alled the law of software

evolution .Maintenan4e due to thi0 phenomenon i0 4alled adapti1e Maintenan4e!



%.t.re Sope

The appli4ation i0 meant for helping u0er to read, 0end Mail0! 0er ha0 to be regi0tered b#

admini0trator! Then u0er 4an 4he4/ hi0 all Mail0, he 4an al0o 4hange hi0 0etting0! 0er

0e00ion i0 maintained till the u0er i0 logged on! An# databa0e 0ear4h for lo4ating

parti4ular information i0 a maor feature!

The 0ite ha0 bright future be4au0e e1er#thing i0 3ell managed! In4on1enien4e i0 ruled out

to u0er! The 0ite pro1ide0 ma9imum e9po0ure of information to the u0er! ith the help

of the e9ample0, 3hi4h are e9plained e1er#3here 3here it i0 required, not onl# the u0er

4an ha1e a44e00 to the information!

+en4e, the 0ite pro1ide0 a44ount to ma9imum of people! The 3eb0ite 4reated allo30 the

u0er to login but ne3 u0er0 4an get regi0tered onl# b# the Admini0trator!

The 0ite 4reated herein i0 a44e00ible b# all t#pe of u0er0 a0 it deal0 3ith e9ternall#

ob0er1able 4hara4teri0ti40 of a 0oft3are produ4t! Al0o, it 4an be ea0il# updated a44ording

to the need0!

In Short, there are fe3 future 04ope0 3ith thi0 Appli4ation $

• The propo0ed 0#0tem 4an be 4hanged a44ording a0 per the requirement0!

• The hint que0tion 4an be added!

• Addre00 boo/ 4an be added to 0tore the information!

• S4heduling 4an be pro1ided to the u0er to ma/e it more benefi4ial!

• Re4o1er# of forgotten pa003ord 4an be done more effe4ti1el#!

• 2a4ilit# of 4hatting 4an be added!

• The 0#0tem 4an be enhan4ed to allo3 e9ternal mailing on the other 0er1er0!

• 2a4ilit# of atta4hing file0 4an be added!



Conl.1ion

Thro3 thi0 3e 4an /no3 ho3 mailing i0 done 3ithin a 0ingle 0er1er! The admini0trator

regi0ter0 the u0er0 and a00ign0 u0ername and pa003ord to the u0er0!

The u0er0 after re4ei1ing u0ername and

pa003ord, login to their a44ount and mail to ea4h other! COMPAN INTERNAL MAIL

SSTEM i0 an ea0# to u0e appli4ation 3hi4h i0 helpful for the u0er for da#5to5da#

requirement0! 0er5friendl# pa4/age be4au0e it i0 1er# mu4h a44ording to the u0erH0

requirement0! It 3ould ta/e le00 time to get familiar 3ith pa4/age!



Limitation o t3e Sy1tem

The 3eb50ite i0 not u0eful for the e9ternal per0on0 3ho are not the emplo#ee of 4ompan#

i!e! the third part# 4anHt u0e the 0#0tem!

Require0 the 3eb50er1er and data ba0e 0er1er to run the appli4ation!

No pro1i0ion for L2orgot Pa003ord!

2ile0 4anHt be atta4hed!



Reerene1

$oo*17

P+P and M#S6 eb De1elopment %De1eloper0 6ibrar#*

b# 6u/e elling

Programming P+P %Paperba4/*

b# Ra0mu0 6erdorf

P+P Coo/boo/ %Paperba4/*

b# Adam Tra4htenberg

P+P Obe4t5Oriented Solution0 %Paperba4/*

b# Da1id Po3er0

Profe00ional Php Programming %Paperba4/* b# Sa04ha S4humann

6earning P+P, M#S6, and -a1aS4ript %Paperba4/* b# Robin Ni9on

P+P > Obe4t0, Pattern0, and Pra4ti4e %Paperba4/* b# Matt Qand0tra

P+P and M#S6 for D#nami4 eb Site0$ i0ual ui4/Pro Guide %Paperba4/* b# 6arr# llman

P+P in A4tion$ Obe4t0, De0ign, Agilit# %Paperba4/*

b# Dagfinn Reier0ol

P+P for the orld ide eb %i0ual ui4/Start Guide*

b# 6arr# llman

Pro P+P and uer# %Paperba4/*

b# -a0on 6eng0torf

'e/1ite Reerene7

333 3)04hool0 4om@php@

company internal main server

Documents