document (repaired)

Upload: amit-sharma

Post on 07-Jul-2018

220 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/19/2019 Document (Repaired)

    1/64

    1

     

    ABSTRACT

      Telecom industry provides so many services to their customers such as

    request for a new connection , change of number , billing etc . The main objective of this

     project is to automate the services provided by the telecom system , by which users can

    use all the services online.

     

  • 8/19/2019 Document (Repaired)

    2/64

    2

    INDEX

     S.N. !NT"NTS #$%" N

    1. &NT'()!T&N *

    2 . S+ST" $N$-+S&S

      2.1 "/&ST&N% S+ST"

      2.2 #'0-" ST$T""NT

      2.* #'#S"( S+ST"

      2. '"3)&'""NT $N$-+S&S 4

      2. '"3)&'""NT S#"!&5&!$T&NS 6

      2. 5"$S&0&-&T+ ST)(+ 7

    *. S+ST" ("S&%N 12

    *.1 #'8"!T ()-"S *

      *.2 ($T$ (&!T&N$'+ *

      *.* ($T$ 5-9 (&$%'$S *7

    *. ":' (&$%'$S *

    *. ;$'(9$'" $N( S5T9$'" '"3)&'"NTS

    *. -&5"!+!-" ("-S

    . S+ST" T"ST&N% 7

    . T"!;N&!-$- NT"S 2

    .1 &NT'()!T&N T ;T- 2

    .2 &NT'()!T&N T S"'

  • 8/19/2019 Document (Repaired)

    3/64

    *

      The project entitled >Telecom connection system? deals with fully automated

    system used by the Telecom department.

    Telecom industry is one of the major sectors, which provides so many services to

    their customers such as request for a new connection, change of number, billing etc.

    aintaining all these services manually is complicated process.

     The main objective of this project is to automate the services provided by

    telecom telecom system, by which customer can use all the services online.

    The project has been divided into four modules.

    1. $pplications2. "ntries

    *. "nquiries

    . !omplaints

    The Applications module provides following services.

    • $ customer can apply for a new telephone connection by filling the form.

    • ;e can request for transferring phone connection to another location.

    • ;e can modify the mode of bill payment details.

    • ;e can also cancel his phone connection.

    The Entries module provides following services.

     

    •  &f the customer requested for change of telephone number, here if we

    enter the old number, it will display the new number.

    The Enquiries module provides following services.

     

    • The customer can ma@e a request about his bill.

  • 8/19/2019 Document (Repaired)

    4/64

    • ;e can also @now the information about changed numbers.

    • ;e can also as@ about the status of his applications.

    The Complaints module provides following services.

    • The customers can complaint regarding the service and all other issues.

    Technologies

    Soft wares A Servlets, 8S#, 8(0!

    (atabases A racle

    9eb Server A $pache Tomcat .1

    perating System A 9indows 76BNTB2===

     

    2.SYSTE ANA!YSIS

     

  • 8/19/2019 Document (Repaired)

    5/64

     system analysis first stage according to System (evelopment -ife !ycle model. This

    System $nalysis is a process that starts with the analyst.

    $nalysis is a detailed study of the various operations performed by a system and

    their relationships within and outside the system. ne aspect of analysis is defining the

     boundaries of the system and determining whether or not a candidate should consider 

    other related systems. (uring analysis, data is collected from the available files, decision

     points, and transactions handled by the present system.

    -ogical system models and tools are used in analysis. Training, eCperience, and

    common sense are required for collection of the information needed to do the analysis.

     

    2."E#istin$ S%stem

    The eCisting system is a manual one where the entrant has to go to the Telecom

    !onncetion System and get details of the company for getting the new connection. ;ere

    it is getting a tedious one for the user to go and manually register with it. $nd in the

     process only a few users are ta@e the connection. To over come this they have proposed

    for the online !onnection.

    2.2&ro'lem Statement

    The previous system was an manual system. So, the system is not available to all

    globally. To ma@e the system available globally, it is now proposed to be web enabled.

    &n the eCisting manual process entrants can not get the information of all the

    telecom system where by registering with Telecom !onnection System they can get the

    updated share values and also since the registration process is automiDed, participation in

    !onnection is easy to the entrants.

      2.(&ropose) S%stem

  • 8/19/2019 Document (Repaired)

    6/64

    The proposed system is the online registration of the entrants with the company.

    0y atomiDing this !onnection process, the entrants enjoy the facility to participate from

    anywhere. "ntrants can also get the information online about all the telecom system. 0y

    this process the user can get all the information of the !onnection process from where

    ever he want as there is no need for him to come to the office and register for !onnection.

    Thus the proposed system is efficient all the way.

    The project has been divided into four modules.

    1.$pplications

    2."ntries

    *."nquiries

      .!omplaints

     The administrator is responsible for the !onnection process and he maintains allthe information about the telecom system that are offering the !onnection process for 

    different participants. ;e is also responsible for the registration of different users that are

    going to ta@e the !onnection process. The administrator will only offer the !onnection

     process and maintain the bill details and everything for the users as well as the telecom

    system who are already registered at the !onnection system

    &n the )ser odule a new user or an user who is already registered with the

    company may be going for !onnection and these persons will @eep their connections by

    ta@ing the connection on telecom system. $ user can offer to ta@e new connection

    ,enquiry, complaints and bill details and every thing on the connection system. The user 

    can get for the !onnection only for the registered telecom system at the administrator 

    only.

    &n "nquiry module user can @now the details from telecom system regarding his

    requirements and another module in user side is complaints i.e ;e can ma@e complaint to

    the office if any connection is corrupted. $nd if he want to @now the bill status . These

    telecom system has to be registered at the administrator only because he is responsible

    for all the !onnection process at the different users.

     

    2.*Requirement Anal%sis

  • 8/19/2019 Document (Repaired)

    7/64

    4

    The requirement phase basically consists of three activitiesA

    1. 'equirement $nalysis

    2. 'equirement Specification

    *. 'equirement

  • 8/19/2019 Document (Repaired)

    8/64

    6

    • The functions that the software is to perform must be defined.

    • The behavior of the software as a consequence of eCternal events must be

    defined.

    • The models that depict information, function and behavior must be

     partitioned in a hierarchical or layered fashion.

    • The analysis process must move from essential information to

    implementation detail.

    2.,Requirement Speci-ication

    Speci-ication &rinciples+

    Software 'equirements Specification plays an important role in creating quality software

    solutions. Specification is basically a representation process. 'equirements are

    represented in a manner that ultimately leads to successful software implementation.

     'equirements may be specified in a variety of ways. ;owever there are some guidelines

    worth followingA :

    • 'epresentation format and content should be relevant to the problem

    • &nformation contained within the specification should be nested

    • (iagrams and other notational forms should be restricted in number and

    consistent in use.

    • 'epresentations should be revisable.

  • 8/19/2019 Document (Repaired)

    9/64

    7

    So-tare Requirements Speci-ications+

    The software requirements specification is produced at the culmination of the

    analysis tas@. The function and performance allocated to the software as a part of system

    engineering are refined by establishing a complete information description, a detailed

    functional and behavioral description, and indication of performance requirements anddesign constraints, appropriate validation criteria and other data pertinent to

    requirements.

    An outline o- t/e So-tare Requirements Speci-ication+

    $ simplified outline can be given for the framewor@ of the specifications. This is

    according to the &""" Standards.

    2.01easi'ilit% Stu)%

    $ll projects are feasible, given unlimited resources and infinite time. 0ut the

    development of software is plagued by the scarcity of resources and difficult delivery

    rates. &t is both necessary and prudent to evaluate the feasibility of a project at the

    earliest possible time.

    Three @ey considerations are involved in the feasibility analysis.

    Economic 1easi'ilit%+This procedure is to determine the benefits and savings that

    are eCpected from a candidate system and compare them with costs. &f benefits outweigh

    costs, then the decision is made to design and implement the system. therwise, further 

     justification or alterations in proposed system will have to be made if it is to have a

    chance of being approved. This is an ongoing effort that improves in accuracy at each

     phase of the system life cycle.

    Tec/nical 1easi'ilit%+

  • 8/19/2019 Document (Repaired)

    10/64

    1=

    Technical feasibility centers on the eCisting computer system Fhardware, software,

    etc.,G and to what eCtent it can support the proposed addition. &f the budget is a serious

    constraint, then the project is judged not feasible.

    Operational 1easi'ilit%+

     #eople are inherently resistant to change, and computers have been @nown to facilitate

    change. &t is understandable that the introduction of a candidate system requires special

    effort to educate, sell, and train the staff on new ways of conducting business.

    Tec/nical 1easi'ilit%

    Technical feasibility spea@s about the eCisting hardware and the software that we

    are using and the deviations that we have to ma@e from the eCisting one, as we are

    developing the application using java there is no change in the hardware that the

    we are using. So we an say that this application is technically feasible as there is

    no change in the configuration more over it is cost effective.

    Economic 1easi'ilit%

    "conomic feasibility tal@s about the benefits that which we get from this project.

    ;ere with the introduction of this online process we are not only reducing the

    time ta@e for the registration of the entrants we even reduce the burden on the

    administrator. $s this project is not only reducing the time but also the wor@ 

     burden of the user we say that this product is economically feasible.

    Operational 1easi'ilit%

  • 8/19/2019 Document (Repaired)

    11/64

    11

    $s this project is a user friendly version there is not much training required for 

    the people to use. This product is not only ma@ing the tas@ of the administrator 

    easy but it is reducing the time that is ta@en otherwise. So we say that this product

    is operationally feasible.

  • 8/19/2019 Document (Repaired)

    12/64

    12

      (.SYSTE DESIN

    The most creative and challenging phase of the life cycle is system design. The

    term design describes a final system and the process by which it is developed. &t refers to

    the technical specifications that will be applied in implementations of the candidate

    system. The design may be defined as >the process of applying various techniques and 

     principles for the purpose of defining a device, a process or a system with sufficient 

    details to permit its physical realization”.

    The designerEs goal is how the output is to be produced and in what format.

    Samples of the output and input are also presented. Second input data and database files

    have to be designed to meet the requirements of the proposed output. The processing phases are handled through the program !onstruction and Testing. 5inally, details related

    to justification of the system and an estimate of the impact of the candidate system on the

    user and the organiDation are documented and evaluated by management as a step toward

    implementation.

    The importance of software design can be stated in a single word

    >Quality” . (esign provides us with representations of software that can be assessed for 

    quality. (esign is the only way where we can accurately translate a customerEs

    requirements into a complete software product or system. 9ithout design we ris@ 

     building an unstable system, that might fail if small changes are made. &t may as well be

    difficult to test, or could be one whoEs

    quality canEt be tested. So it is an essential phase in the development of a software

     product.

  • 8/19/2019 Document (Repaired)

    13/64

    Customer

    Applications

     Entry

    Enquiries

    Complaints

    Customerr 

     ApplicationsCustomer  enquiries Complaints

    entries

    Applications Registered

    Entries

    EntriesRegistered Enquiries

    Enquiries Completed Complaints

    Complaints

    Registered

    1*

    U! Dia$rams

      5igure *.1 )se case diagram of !ustomer 

  • 8/19/2019 Document (Repaired)

    14/64

     :Customer 

    Applications

    Enquiries

    complaints

    ChangedNumbers

    entry

    1.Applications

    2:application detailsregistered

    3: entries

    4: entries registered

    7: complaints8: complaintsregistered

    5.Enquiries

    6: status of Applications

    Known

    1

     

    5igure*.2 Sequence diagram of !ustomer 

  • 8/19/2019 Document (Repaired)

    15/64

    1

      5igure*.* !ollaboration diagram of !ustomer 

    Pone modification Connection transfer 

    Pone cancellation

    !ills reports  Applications reports

     App for new connection

     App for pone transfer 

     App for pone modification

     App for pone cancellation

    !ill enquir"

     App enquir"Canged no# enquir"

    Canged no# entr"

    Enq for complaints

    complaints rectification

    connection confirmation

     Administrator 

    $ogin

    Entries

    %%include&&

     Applications

    %%include&&

    %%include&&

    %%include&&

    %%include&&

     Apps response

    %%include&&%%include&&

    %%include&&

    generate reports

    %%include&& %%include&&

    customer details

    complaints

    'ser 

    (elecom )!

    Enquiries%%include&&

    %%include&&%%include&&

    %%include&&

    complaints reports

    %%include&&

      5igure*. )se !ase (iagram 5or T!S

      5igure*. )se !ase (iagram 5or T!S

  • 8/19/2019 Document (Repaired)

    16/64

    1

    (elepone*modi*details

    +eq*id : ,nteger 

    poneno : ,nteger 

    reqdate : )ate

    name : -tring

    reason : -tring

    Pone*transfer*requ

    est

    connt"pe : -tring

    n*address : -tringp*adress : -tring

    Pone*cancellation

    connt"pe : -tring

    user*reg

    userid : ,nteger 

    password : -tringfname : -tring

    lname : -tring

    gender : -tring

    ).! : )ate

    cit" : -tring

    mstatus : -tring

    address : -tring

    email : -tring

    age : ,nteger 

    su/mit01

    cancel01

    ew*connections*details

    req*id : ,nteger 

    name : -tring

    gender : -tring

    password : -tring

    facilit" : -tring

    purpose : -tring

    address : -tring

    getdetails01

    storedetails01

    ## ##

     Application*response

    +eq*id : ,nteger 

    5*status : -tring

    (*status : -tring

    C*status : -tring

    oldno# : ,nteger 

    newno# : ,nteger 

    gieresponse01

    storeinfo01

    )emand*draft*detailsdd*id : ,nteger 

    dd*date : )ate

    draft*no : ,nteger 

    /name : -tring

    amount : )ou/le

    /ranc : -tring

    storedddetails01

    proidedddetails01

    ##

    ##

    ##n

    ##n

    Conconfirm*details

    +eq*id : ,nteger cname : -tring

    poneno : ,nteger 

    status : -t ring

    cont"pe : -tring

    conreqdate : )ate

    conconfirmdate : )ate

    getdetails01

    storedetails01

    ##n ##n

    Complaints*solutionsolution : -tring

    sol*send*date : )ate

    com*gien*date : )ate

    getresponse01

    storeresponse01

    Complaints

    com*id : ,nteger 

    cname : -tring

    comdate : )ate

    poneno : ,nteger 

    connt"pe : -tring

    su/ect : -tring

    message : -tring

    su/mit01

    ##

    ##

      5igure*. !lass (iagram 5or T!S

  • 8/19/2019 Document (Repaired)

    17/64

    14

     : 'ser  : 5ain9orm : registrationform

     : (elecom )!

    : -ign'p0 1

    2: .pen0 1

    3: Collect)etails0 1

    4: -u/mit0 1

    : isfilled0 1

    6: isproper0 1

    7: ;erif"'ser0 1

    8: createuser0userid1

  • 8/19/2019 Document (Repaired)

    18/64

    16

     : 'ser 

     :

    5ain9orm

     : registrationform

     : (elecom )!

    3: Collect)etails0 1: isfilled0 1

    6: isproper0 1

  • 8/19/2019 Document (Repaired)

    19/64

    17

     

    : 'ser  : 5ain9orm : $ogin9orm

     : (elecom )!

    : Connect0 1

    2: .pen0 1

    3: =et'idPasswd0'ser,d:,nt>Password:-tring1

    : ;alid0 1

    7: ,nalid0 1

    8: )ispla"msg

    6: )ispla".perations0 1

    4: =et)etails0 1

      5igure*.6 Sequence (iagram 5or -ogin

  • 8/19/2019 Document (Repaired)

    20/64

    2=

     : (elecom )!

     : 'ser 

     :

    5ain9orm

     : $ogin9orm

    : ;alid0 17: ,nalid0 1

    : Connect0 1

    3: =et'idPasswd0'ser,d:,nt>Password:-tring1

    8: )ispla"msg

    2: .pen0 16: )ispla".perations0 1

    4: =et)etails0 1

      5igure*.7 !ollaboration (iagram 5or -ogin

  • 8/19/2019 Document (Repaired)

    21/64

    21

     : 'ser  : 5ain9orm :

     Application9orm : (elecom )!

    2: application0 1

    3: .pen0 1

    4: Proide)etails0 1

    : isfilled0 1

    7: isproper0 1

    8: -tore)etails0 1

    6: -u/mit0 1

  • 8/19/2019 Document (Repaired)

    22/64

    22

     : 'ser 

     :

    5ain9orm

     : Application9orm

     : (elecom )!

    : isfilled0 17: isproper0 1

    2: application0 1: $ogin0 1

    4: Proide)etails0 1

    6: -u/mit0 1

  • 8/19/2019 Document (Repaired)

    23/64

    2*

     : 'ser  : 5ain9orm

     : (elecom )!: cancelform

    2: cancelpone0 1

    3: .pen0 1

    6: ispnoaail0 1: su/mit0 1

    4: proidedetails0+eqid:,nt>Pno:um/er1

    7: displa"statusmsg0 1

    8: close0 1

    : $ogin0 1

    5igure*.12 Sequence (iagram 5or $pplication 5or #hone !ancellation

  • 8/19/2019 Document (Repaired)

    24/64

    2

     : 'ser 

     :

    5ain9orm

     : (elecom )!

     : cancelform

    2: cancelpone0 1: $ogin0 1

    3: .pen0 18: close0 1

    4: proidedetails0+eqid:,nt>Pno:um/er1: su/mit0 1

    7: displa"statusmsg0 1

    6: ispnoaail0 1

    5igure*.1* !ollaboration (iagram 5or $pplication 5or #hone !ancellation

  • 8/19/2019 Document (Repaired)

    25/64

    2

     : 'ser  : 5ain9orm : enquir"form

     : (elecom )! : Administ rator  

    2: !illEnquir"0 1

    3: open0 1

    : $ogin0 1

    4: get+eqid0 1

    : is+eqidaail0 1

    6: displa"msg0 1

    7: getuserdetails0 1

    8: proide/illdetails0 1

  • 8/19/2019 Document (Repaired)

    26/64

    2

     : 'ser 

     :

    5ain9orm

     : enquir"form

     : (elecom )!: Administrator 

    : $ogin0 12: !illEnquir"0 1

    3: open0 1

  • 8/19/2019 Document (Repaired)

    27/64

    24

    Connect

    )ispla".peratio

    ns

    .pen

    ? alid @

    )ispla"msg

    ? ,nalid @

    =et'idPasswd0'id:int

    >Password:-tring1

    ;alidatedetails

    =etdetails

     : Telecom DB: LoginForm: mainform: User 

      5igure*.1 $ctivity (iagram 5or -ogin

  • 8/19/2019 Document (Repaired)

    28/64

    26

    login

    get+eqid

    )ispla"errmsg

    proide/illdetails

    !illenquir"

    )ispla"statusinf 

    o

    open

    ? ,nalid @

    ? ;alid @

    ;alidate+eqid

    =etuserdetails

    Administrator TelecomDBenquiryformmainformuser 

      5igure*.14 $ctivity (iagram 5or 0ill "nquiry

  • 8/19/2019 Document (Repaired)

    29/64

    27

    login

    proidedetails0+eqid:

    int>Pno:um/er1

    )ispla"errmsg

    giesresponse

    cancelpone

    ? ,nalid @

    )ispla"statusm

    sg

    ? ;alid @

    open

    alidatepno

    cecapplicatio

    ns

    administrator telecomDBcancelformMainformuser 

      5igure*.16 $ctivity (iagram 5or #hone !ancellation

  • 8/19/2019 Document (Repaired)

    30/64

    *=

    login

    Proidedetails

    )ispla"msg

    Proide+eqid

    ew application

    ? ,nalid @

    .pen

    ;alidate weter te details

    are properl" filled or not

    -toredetails? ;alid @

    TelecomDBapplicationformmainformuser 

      5igure*.17 $ctivity (iagram 5or New #hone !onnection

  • 8/19/2019 Document (Repaired)

    31/64

    *1

    !rowsingCenter

    0locationBKadapa1

    %%Processor&&

    !rowsingCenter

    0locationBCennai1

    %%Processor&&!rowsingCenter

    0locationBD"d1

    %%Processor&&

    ,nternet

    %%Processor&&

    user application user application user application

    %%A&&%% A&& %%A&&

      -erer

    0locationB.ffice1

    %%Processor&&

    %%A&&

    (elecom )!

    %%Processor&&

    %%$A&&

    -tore Customer details

    -tore Administrator

    details

    . . . . . .

      5igure*.2= (eployment (iagram

  • 8/19/2019 Document (Repaired)

    32/64

    *2

    !rowsingCenter

    0locationBKadapa1

    %%Processor&&

    !rowsingCenter

    0locationBCennai1

    %%Processor&&!rowsingCenter

    0locationBD"d1

    %%Processor&&

    ,nternet

    %%Processor&&

    user application user application user application

    %%A&&%% A&& %%A&&

      -erer

    0locationB.ffice1

    %%Processor&&

    %%A&&

    (elecom )!

    %%Processor&&

    %%$A&&

    -tore Customer details

    -tore Administrator

    details

    . . . . . .

      5igure*.21 !lass diagram for psis

      (."&ro3ect mo)ules

  • 8/19/2019 Document (Repaired)

    33/64

    **

     The project has been divided into four modules.

    1.$pplications

    2."ntries

    *."nquiries

    .!omplaints

    The Applications module provides following services.

    • $ customer can apply for a new telephone connection by filling the form.

    • ;e can request for transferring phone connection to another location.

    •;e can modify the mode of bill payment details.

    • ;e can also cancel his phone connection.

    The Entries module provides following services.

     

    •  &f the customer requested for change of telephone number, here if we

    enter the old number, it will display the new number.

    The Enquiries module provides following services.

     

    • The customer can ma@e a request about his bill.

    • ;e can also @now the information about changed numbers.

    • ;e can also as@ about the status of his applications.

    The Complaints module provides following services.

    • The customers can complaint regarding the service and all other issues

     

    (.2 Data Dictionar%

  • 8/19/2019 Document (Repaired)

    34/64

    *

    The logical characteristics of current systems data stores, including name,

    description, aliases, contents, and organiDation, identifies processes where the data are

    used and where immediate access to information required, Serves as the basis for 

    identifying database requirements during system design.

    Uses o- Data Dictionar%+

    1. To manage the detail in large systems

    2. To communicate a common meaning for all system elements

    *. To (ocument the features of the system

    . To facilitate analysis of the details in order to evaluate characteristics and

    determine where system changes should be made.

    . To locate errors and omissions in the system.

    TAB!E NAE (.2 +  Telecom !onnection System

    5ield name Type !onstraint

    )S"'&(

  • 8/19/2019 Document (Repaired)

    35/64

    *

    Telecom -ogin Table*.21A

    5ield name Type !onstraint

    #honeHno Number Not null

    0illHno Number  $mount NumberF1*,2G

    0ill (etails Table *.22A

    5ield name Type !onstraint

    ldHno Number  

     NewHno number 

    !hanged Numbers Table *.2*A

    5ield name Type !onstraint

    !omplaintHid Number Not null

    Subject

  • 8/19/2019 Document (Repaired)

    36/64

    *

    'eqid Number Not null

    !name

  • 8/19/2019 Document (Repaired)

    37/64

    *4

      (.(Data 1lo Dia$rams

    $ graphical tool used to describe and analyDe the moment of data through a

    system manual or automated including the process, stores of data, and delays in the

    system. (ata 5low (iagrams are the central tool and the basis from which other 

    components are developed. The transformation of data from input to output, through

     processes, may be described logically and independently of the physical components

    associated with the system. The (5( is also @now as a data flow graph or a bubble

    chart.

    Conte#t Dia$ram+

    The top:level diagram is often called a >context diagram”. &t contains a single

     process, but it plays a very important role in studying the current system. The conteCt

    diagram defines the system that will be studied in the sense that it determines the

     boundaries. $nything that is not inside the process identified in the conteCt diagram will

    not be part of the system study. &t represents the entire software element as a single

     bubble with input and output data indicated by incoming and outgoing arrows

    respectively.

    T%pes o- )ata -lo )ia$rams

    (5(s are two types

    ". &/%sical D1D

  • 8/19/2019 Document (Repaired)

    38/64

    *6

      Structured analysis states that the current system should be first understand correctly.

    The physical (5( is the model of the current system and is used to ensure that the

    current system has been clearly understood. #hysical (5(s shows actual devices,

    departments, people etc., involved in the current system

    2. !o$ical D1D  -ogical (5(s are the model of the proposed system. They clearly should show the

    requirements on which the new system should be built. -ater during design activity this

    is ta@en as the basis for drawing the systemEs structure charts.

    T/e Basic Notation use) to create a D1D4s are as -ollos+

    Data-lo+  (ata move in a specific direction from an origin to a

    (estination.

    &rocess+  #eople, procedures, or devices that use or produce

    FTransformG (ata. The physical component is not identified. 

    Source+  "Cternal sources or destination of data, which may be

    #eople , programs, organiDations or other entities.

     

    Data Store+ ;ere data are stored or referenced by a process in the

      System

  • 8/19/2019 Document (Repaired)

    39/64

    )ser Telecom!onnection(atabase

    Telecom!onnectinSystem

    *7

     

    DATA 1!O5 DIARAS

     

    5igure *.*1 !onteCt levelA

    Telecom!onnection#rocedures

  • 8/19/2019 Document (Repaired)

    40/64

    =

     

    5igure *.*2 !e6el "

     

    5igure *.** !e6el 2

     

    1.1!ompany'egistration #rocess

    2.1Telecom!ustomer'egistraton

    *.1!onnection#rocess

    !ompany(etails

    "ntrant(etails

    !onne(etails

    1.1.=Services

    1.1.1"ntries

    1.1.2"nquires

    Telecom

    !ompany !ustomer !are

    2S#

  • 8/19/2019 Document (Repaired)

    41/64

    Application forNew Connection

    compid

    Password

    Compname

    Address1

    Address City

    !tate

    "ipcode

    #$%reg

    &urno'er

    Phoneno

    N$(

    !E%reg% date

    !E%reg )R*

    Email

    +a,

     Entrant

    Password

    Ent%name

    Address1

    Address C

    #$%re !$%b

    Email

    +a,

    Ent%id

    Can

    beselectedbymany

    1

      (.* Entit%7Relations/ip Dia$rams

    The over all logical structure of a database can be eCpressed graphically by an E-

     R diagram. The relative simplicity and pictorial clarity of this diagramming technique

    may well account in large part for the widespread use of the ":' model. Such a diagram

    consists of the following major componentsA

    Rectan$les+ 'epresent "ntity Sets

    Ellipses+  'epresent attributes

    Diamon)s+ 'epresent relationship sets

    !ines+ -in@ attributes to entity sets and entity sets to

    'elationship sets

    Dou'le Ellipses+ 9hich represent multi:valued attributes

    Das/e) Ellipses+ 9hich denote derived attributes

    Dou'le !ines+ 9hich indicate total participation of an entity in a

      'elationshi

     

    E7R DIARAS

  • 8/19/2019 Document (Repaired)

    42/64

     Entrant

    Password

    Ent%name

    Address1

    Address City

    !tate

    "ipcode

    Phone no

    #$%reg

    !$%bet

    Email +a,

    Ent% id

     -ift

    Ent%id

    Participatedfrom

    Result

    Canget

    2

     

    3.5 Hardware and software requirements

    8ar) are Speci-ication+

  • 8/19/2019 Document (Repaired)

    43/64

    *

    &rocessor + &ntel #:&&& based system

    &rocessor Spee) + 2= ;D to 6**;D

    RA + 0 to 20

    8ar) Dis9 + 2%0 to *=%0

    :e% Boar) + 1= @eys

    So-tare Speci-ication+

    !an$ua$e + 8(I 1.2

    Data'ase + '$!-"

    Operatin$ S%stem + 9indows2===

     

    (.0!i-ec%cle mo)els

    The stage of planning and development process involves defining, developing,

    testing, delivering, operating, and maintaining a software product. (ifferent lifecycle

    models emphasiDe different aspects and no single lifecycle model is suitable for all

    software products. $ lifecycle model that is understood and accepted improves project

  • 8/19/2019 Document (Repaired)

    44/64

    communication and enhances project manageability, resource allocation, cost control, and

     product quality.

     T/e &/ase) !i-e C%cle o)el

    The phased lifecycle model represents software lifecycle as a series of successive

    activities. This phase requires well:defined input information, processes and results in

    well:defined products. The phased lifecycle model consists of following phases.

    Anal%sis; Desi$n; Implementation; S%stem Testin$ an) aintenance

    This model is sometimes called the 9aterfall odel, the products cascade fromone level to another in smooth progression.

    $nalysis (esign &mplementation System

    Testing

    aintenance

    #lanning,

    )ser needs

    (efinition

    (esign

    (etails

    !ode, debugand Test

    &ntegration J

    $cceptance

    "nhance, 5iC

    $dapt

    The Anal%sis Sta$e consists of #lanning and 'equirements definition.

  • 8/19/2019 Document (Repaired)

    45/64

    $ feasibility study, developing a recommended solution strategy, determining the

    acceptance criteria and planning development process. The products of planning are a

    System definition and a project plan.

      The So-tare Desi$n follows analysis. (esign is concerned with its software

    components, specifying relationships among components specifying some structure,

    maintaining a record of design decisions and providing blueprint implementation phase.

    (esign consists of detailed design and $rchitectural design.

    The implementation  phase of software development involves translation of 

    design specification into source code, and debugging, documenting and unit testing the

    source code. To enhance the quality of the software the methods are structured control

    constructs, built in and user defined data types, secure type chec@ing, fleCible scope ruleseCception handling mechanism, concurrency constructs and separates compilation

    modules.

    S%stem Testin$ involves two @inds of testing integration testing and acceptance

    testing. (eveloping a strategy for integrating the components of a software system into a

    functioning requires careful planning so that modules are available for integration when

    needed. $cceptance testing involves planning and eCecution of various tests in order to

    demonstrate that the implemented system satisfies the requirement document.

    The aintenance  phase comes after the acceptance of the product by the

    customer and release of the system for production wor@. aintenance activities include

    enhancements of capabilities, adaptation of software to new processing environments,

    and correction of software bugs.

  • 8/19/2019 Document (Repaired)

    46/64

    T/is pro3ect follows the #hased -ife !ycle odel or the 9ater 5all model to a large

    eCtent.

    The analysis stage consisted of listening to the needs and requirements of the

    eCamination department obtaining the required format of the system as desired by them,

    ta@ing the required data to be stored for future use etc., &n the design stage the structure

    of the system was designed and all the required screens were formatted. This was then

    shown to the officerEs approval and the system was built. &mplementation phase was

    done at #'&T;

  • 8/19/2019 Document (Repaired)

    47/64

    4

      *.SYSTE TESTIN

    Software Testing is a critical element of software quality assurance and represents

    the ultimate review of specification, design and coding, Testing presents an interesting

    anomaly for the software engineer.

    Testin$ O'3ecti6es inclu)e+

    1. Testing is a process of eCecuting a program with the intent of finding an error 

    2. $ good test case is one that has a probability of finding an as yet undiscovered

    error *. $ successful test is one that uncovers an undiscovered error 

    Testin$ &rinciples+

    • $ll tests should be traceable to end user requirements

    • Tests should be planned long before testing begins

    • Testing should begin on a small scale and progress towards testing in large

    • "Chaustive testing is not possible

    • To be most effective testing should be conducted by a independent third

     party

    TESTIN STRATERIES

    $ Strategy for software testing integrates software test cases into a series of well

     planned steps that result in the successful construction of software. Software testing is a

     broader topic for what is referred to as

  • 8/19/2019 Document (Repaired)

    48/64

    6

  • 8/19/2019 Document (Repaired)

    49/64

    7

    This method as the name suggests, begins construction and testing with atomic

    modules i.e., modules at the lowest level. 0ecause the modules are integrated in the

     bottom up manner the processing required for the modules subordinate to a given level is

    always available and the need for stubs is eliminated.

  • 8/19/2019 Document (Repaired)

    50/64

    =

      ,."Intro)uction to 8T!

      The hyperteCt mar@up language F;T-G is a simple mar@up language. )sed to create

    a hyperteCt documents that are portable from one platform to another ;T- documents

    are S%- FStandard generaliDed mar@ up languageG documents with generic semantics

    that are appropriate for representing information from a wide range of applications. This

    specification defines ;T- version *.2. ;T- *.2 aims to capture recommended

     practice as of early E7 and as such a replacement for ;T-2.= F'5! 16G.

    $ set of instructions embedded in a document is called mar@ up language. These

    instructions describe what the document teCt means and how it should loo@ li@e in a

    display. ;yper TeCt ar@ )p language F;T-G is the language used to encode 9orld

    9ide 9eb documents.

    58Y TO USE 8T!

      9ebsite is a collection of pages, publications, and documents that reside on web

    server. 9hile these pages publications and a document as a formatted in a single format,

    you should use ;T- for home page and all primary pages in the site. This will enable

    the millions of web users can easily access and to ta@e advantage of your website.

    ;T- is considered first for formatting any new material you plan to publish on

    the web. ;T- documents are platform independent, meaning that they donEt confirm to

    any standard. &f they are created properly you can move home page to any server 

     platform or you can access them with any complaint www browser.

    STRUCTURE O1 8T!

    ;T- elements perform a defined tas@. ;T- uses two types of elements

    . "mpty Tags

    . !ontainer Tags

  • 8/19/2019 Document (Repaired)

    51/64

    1

    These tags differ because of what they represent. "mpty tags represent formatting

    constricts such as line brea@s and horiDontal rules. !ontainer tags define a section of teCt,

    formats and dot all of the selected teCt. $ container tag has both a beginning and an

    ending.

    8T! !AYOUT+

      $n ;T- document consists of teCt, which comprises the content of the document and

    tags, which, defines the structure, and appearance of the document. The structure of an

    ;T- document is simple, consists of outer.

    K;T-Ltag enclosing the document header and body

    K;T-L

    K;"$(L

      KT&T-"Lthe title of ;T- documentKBT&T-"L

    KB;"$(L

    K0(+L

    This is where the actual ;T- documents

    TeCt lies, which is displayed in the browser 

    KB0(+L

    KB;T-L

    "ach document has a head and body delimited by the K;"$(L and K0(+L tag. The

    head is where you give your ;T- document a title and where you indicate other 

     parameters the browser may use when displaying the document. This includes the teCt for 

    displaying the teCt. Tag also references special and indicates the hot spots that lin@ your 

    document to other documents.

    8T! 1ORS+

  • 8/19/2019 Document (Repaired)

    52/64

    2

    !reateting a form usually involves two independent stepsA !reateting the layout

    for the form itself and then writing a script program on the server side to process the

    formation you get bac@ from a form.

    To create a form, +ou use the K5'L tag. &nside the opening and closing

    5' tags are each of the individual form elements plus any other ;T- content to

    create a layout for that form.

    The opening tag of the 5' element usually includes the attributesA "T;(

    and $!T&N. The "T;( attributes can be either %"T or #ST which determines

    how your form data is sent to the script to process it.

     The $!T&N attribute is a pointer to the script that processes the form on the

    server side. The $!T&N can be included by a relative path or by a full )'- to a script

    on your server or somewhere else. 5or eCample, the following K5'L tag would call a

    script called form:name in cgi:bin directory on server www.myservser.com

    K5' ethodM post actionMhttpABBwww.mytservser.comBcgi:binBform:name.plL

    .

    KB5'L

    ET8OD ATTRIBUTE+

      The other required attribute for the KformL tag sets the methods by which the

     browser formEs data to the server for processing. There are two waysA the #ST method

    and %"T method. 9ith #ST method, the browser sends the

    data in two stepsA the browser first contacts the form:processing server specified in the

    action attributes, and once contact is made, sends the data.

     

    http://www.myservser.com/http://www.myservser.com/

  • 8/19/2019 Document (Repaired)

    53/64

    *

      The %"T method in the other hand, contacts the form processing server and sends

    the form data in a single transaction stepA the browser appends the data to the formEs

    action )'-, separated by the question mar@ FOG character.

    .

  • 8/19/2019 Document (Repaired)

    54/64

    ,.2INTRODUCTION TO SER

    Servlets provides a 8ava:0ased solution used to address the problems currently

    associated with doing server side programming, including ineCtensible scripting

    solutions, platform specific $#&s, and incomplete interfaces. Servlets are objects conform

    to a specific interface that can be plugged into a 8ava:based server. Servlets are to the

    server:side what applets are to the client:side:object byte codes that can be dynamically

    loaded off the net. They differ from applets in that they are faceless objects Fwithout

    graphics or a %)& componentG. They serve as platform independent, dynamicallyloadable, plug gable helper byte code objects on the server side that can be used to

    dynamically eCtend server:side functionality.

    5or eCample, an ;TT# servlet can be used to generate dynamic ;T- content.

    9hen you use servlets to do dynamic content you get the following advantagesA

    TheyEre faster and cleaner than !%& scripts.

    They use a standard $#& Fthe Servlet $#&G

    They provide all the advantages of 8ava Frun on a variety of servers without

      needing to be rewrittenG

    T/e attractions o- Ser6lets

    There are many features of servlets that ma@e them easy and attractive to use.

    These includeA

    "asily configured using the %)&:based $dmin Tool.

    !an be loaded and invo@ed from a local dis@ or remotely across the networ@.

    !an be lin@ed together, or chained, so that one servlet can call another servlets, or several

    servlets in sequence.

  • 8/19/2019 Document (Repaired)

    55/64

    !an be called dynamically from within ;T- pages, using server:side include tags

    In6o9in$ t/e ser6let

    To invo@e a servlet you call it by creating a )'- with >BservletB? pretended to the

    servlet name. Then enter this )'- in your favorite browser to see the output of the

    Servlet.

    "CampleA

      $fter installing according to the directions above, access the ;elloServlet by entering

    the following )'- in your favorite browserA

    httpABBserver:host:nameA6=6=BservletBhell

    Internal Ser6lets

    The 8ava Server servlet architecture is very fleCible and the server ta@es

    advantage of this by dividing up its wor@ among several internal servlets. These are

    5ile Servlet

    &nvo@er Servlet

    Server side include servlet

    $dmin Servlet

    !%& Servlet

    &mage map servlet

    1ile Ser6let

    The file servlet provides the standard document serving capabilities of java server.

    This servlet includes a caching mechanism to speed up response times of frequently

    http://server-host-name:8080/servlet/hellhttp://server-host-name:8080/servlet/hell

  • 8/19/2019 Document (Repaired)

    56/64

  • 8/19/2019 Document (Repaired)

    57/64

  • 8/19/2019 Document (Repaired)

    58/64

    6

    ;ere a new user or an user who is already registered with the company may be

    going for !onnection and these persons will @eep their connections by ta@ing the

    connection on telecom system. $ new user has to do signup . $n eCisting user can offer to

    ta@e new connection ,enquiry, complaints and bill details and every thing on the

    connection system. The user can get for the !onnection only for the registered telecom

    system at the administrator only.

  • 8/19/2019 Document (Repaired)

    59/64

    7

    ;ere user can apply for new phone connection by giving all the necessary details.)ser

    can also apply for modifications,if necessary. $nd also one can request for cancellation of 

    connection.ne can also apply for phone transfer.

  • 8/19/2019 Document (Repaired)

    60/64

    =

      ;ere as shown,we can apply for a new connection by filling all the personal

    information that is required.;ere all the basic information li@e name,gender,address are

    filled and also (emand (raft details are filled.

  • 8/19/2019 Document (Repaired)

    61/64

    1

      ;ere user can cancel the phone connection.5or this,one has to give

    general information.$nd along with this general information user should also provide the

    reason for cancellation.;ence they can improve the service.

  • 8/19/2019 Document (Repaired)

    62/64

    2

      ;ere user can @now the details from telecom system regarding his

    requirements.ne can @now the bill status,changed number details,!omplaints enquiry

    ie,if user registers any complaint and also about the application status just by selecting

    the appropriate options as shown.

  • 8/19/2019 Document (Repaired)

    63/64

    *

      ;ere we can enter complaints ie, )ser can ma@e complaint to

    the office if any connection is corrupted.

      =.BIB!IORA&8Y

  • 8/19/2019 Document (Repaired)

    64/64