Docstoc

directmoving® Planner

Document Sample
directmoving® Planner Powered By Docstoc
					MGT 6051 - Spring 2001                          Georgia Institute of Technology




          DirectMoving® Planner

          MGT 6051 - Database Management Systems


                         Presented to Dr. Han Zhang

                     Dupree College of Management
                     Georgia Institute of Technology




                              Karim El-Khazen
                                   Lin Gui
                                Pascal Suria
                                Philsou Lee
                                Xiaoting Niu



                              April 19, 2001


                                     1
MGT 6051 - Spring 2001                       Georgia Institute of Technology




                          Table of Content


Preface

I     Context

      I.1    Introduction to Directmoving.com®
      II.2   Project objectives


II    Logical design of the database

      II.1   Business rules
      II.2   Entity Relationship Diagram


III   Physical design of the database

      III.1 Microsoft Access
      III.2 SQL Query using virtual tables


IV    Active Server Page (ASP)

      IV.1 Presentation of the ASP
      IV.2 ASP Coding


V     Interface design and implementation

      V.1    Overall view of the Moving Planner
      V.2    Implementation

Conclusion




                                 2
MGT 6051 - Spring 2001                     Georgia Institute of Technology




                         Preface

                         This project has been realized as part of
                         course MGT 6051 and presented to
                         Dr. Han Zhang. We would like to thank
                         Emmanuelle Putaux for being our contact
                         at Directmoving.

                         Karim El-Khazen
                         Pascal Suria
                         Philsou Lee
                         Lin Gui
                         Xiaoting Niu

                         Atlanta, April 17, 2001




                               3
MGT 6051 - Spring 2001                                  Georgia Institute of Technology


I         Context


I.1       Introduction to Directmoving.com®
Directmoving.com® is the First Worldwide Relocation portal on the Internet
available to both expatriates, to help them prepare their departure and organize
their daily life in a new country HR Managers, responsible for relocating
personnel.

Directmoving.com® is currently concentrating its marketing strategies on Paris,
London and New York, the biggest expatriates cities in the world.

Directmoving.com®, has already launched successfully in Paris (29th May 2000 at
the 8th World Congress of HR Managers in Paris), London (8th June 2000) , and
New York via a webcast (14th Aug 2000).

Directmoving.com® offers access to more than 10,000 specialists worldwide. The
portal site provides access to a host of information, services and practical advice
covering all aspects of moving to a new country to both HR Managers and
expatriates.
The HRM‟s Lounge is a precious information and exchange resources for Human
Resources Managers arranging the expatriation of personnel that requires
managing a wide range of economic, organizational and human variables.

Directmoving.com® offers indexes, figures, evaluation methods and guidance on
fiscal, social and real estates matter in each country.

A discussion forum allows Human Resources Managers to share their
experiences and seek advice. The website also offers quick searching of
relocation service providers.
Directmoving.com® offers all the necessary tools to help expatriates prepare for
relocation, and succeed in their new environment, wherever the country of
destination.

Martha®, the super assistant, accompany the expatriate and his family before,
during, and after their departure, and dispense precious advice all throughout the
website.
HR Lounge: An indispensable work tool for Human Resource Managers:

      -   Key information on each country, Indexes and figures (indices, budget,
          costs), Fiscal data (deductions, exonerations, social contributions), Real-
          estate markets (specificities, leases, rents, etc.),
      -   Practical tools, Translation, a worldwide who‟s who directory of Human
          Resources Managers, a Q&A service with Martha®, expert not only on
          practical advice but also in international relocations, a virtual bookstore ,
          agenda of international events for Human Resources professionals,


                                            4
MGT 6051 - Spring 2001                               Georgia Institute of Technology


   -   Human Resource Managers only discussion forum, the 'VIP's Cafe',
       „Directnews‟ - the HR newsletter , reviewed and recommended HR Web
       sites,

A multi-service offer for expatriates

   -   Advice and information to move with total peace of mind: packing,
       shipping, customs, storage, insurance, estimation of the volume/weight of
       a shipment and a space planner for furniture.
   -   A selection of quality sites covering other aspects of an expatriation:
       housing, administrative matters, education, jobs, health, travel,
       automobiles, culture, leisure, shopping, etc., all carefully selected and
       rated on a scale from 1 to 5.
   -   A who's who, world-wide directory containing more than 10,000 specialists
       in the field of international relocation: Associations, Automobile services,
       Chambers of Commerce, Consultants, Finance, Freight Forwarders,
       Furniture/Appliances, Insurance, Intercultural Training, International
       Schools, Language Tuition, Lawyers, Moving companies, Pet services,
       Real Estate,        Recruitment,     Relocation companies, Temporary
       Employment, Translators, updated daily.
   -   The assistance and advice of the site mascot, Martha®: virtual office for
       coordination, free e-mail address, checklist, electronic standards of each
       country, bookstore for the expatriate and his family, how to recuperate
       VAT, etc.
   -   A discussion forum, 'Martha®'s cafe' and a 'classified ads' section.

Martha®, is in charge of setting the standard of quality by putting her label on the
relocation services providers of the Who‟s Who. Alternatively, she will manage
expatriates‟ complaints.




                                         5
MGT 6051 - Spring 2001                              Georgia Institute of Technology




II.2   Project objectives

Directmoving is willing to complete its panel of offers with a brand new tool that
starts being implemented by some actors on the moving market. This tool,
a moving planner, displays according to the users setting all the tasks to be
completed before departure and after arrival in a new home.
The users is for example asked to enter some general parameters about its
current situation (Does he possess a car?, does he have children?..)
and the moving schedule will be updated to display the information accordingly.

The main limitation of all current web-moving planners comes from the fact they
are narrowing their domain of activities to moving within one country
(mostly USA). As a consequence, Directmoving decided to put on its website an
extended version of the tool allowing moving at the international level.
The users are now retrieving information about origin and destination countries,
such as passport requirement, health procedures…

This tool constitutes the body of our project. Directmoving provided us
with a concise set of requirements, giving us a certain degree of freedom.
This project has a particularity in the fact that we had to make the logical design
and then the implementation of both the database and the web interface.




                                        6
MGT 6051 - Spring 2001                                Georgia Institute of Technology


II       Logical design of the database


II.1     Business rules

Given the requirements of DirectMoving, we derived two sets of business rules,
one for the database itself, and another one for the web interface.


Database business rules:


      A user is characterized by an email address, a password, a first name and
       a last name,
    A plan is characterized by a plan id, the nationality of the plan initiator, the
       origin and destination cities and countries, the specific attributes of the
       user corresponding to the current plan (Home, Car, Pets, Children), the
       weekly email update option,
    A task is characterized by a task id, a title, a description, a default display
       time, the specific attributes of the user that require the task to be displayed
       (Home, Car, Pets, Children),
    A user can make none or many plans, and a Plan is made by only one
       user,
    Our business rule determines that for some of the attributes of the Plan,
       such as Car, Pet, Children, Home, Weekly-Update, a user just make a
       choice between Yes or No. While, for attributes like City_Origin, and
       City_Destination, a user needs to select from our input data.
    A Plan checks tasks: each plan may check one or more task, and each
       task may be checked by one or many plans, M: N relationship.
    Plan picks Countries: as a plan includes an Origin Country and a
       Destination Country, covered in Country entity, we set two relations
       between Plan and Country as Pick_Destination and Pick_Origin. A Plan
       includes one and only one Origin Country, and one and only one
       Destination Country as well. An Origin Country is picked in none or many
       plans, so is a Destination Country. Hence, the relationship between Plan
       picks Country is M:1.
    All information must be stored in three different languages: French,
       English, and Spanish,
Interface business rules:


        The interface must support three languages: French, English, and
         Spanish,




                                          7
MGT 6051 - Spring 2001                               Georgia Institute of Technology


      A user must be able to register his email address, first name, last name
       and protect them with a password,
      A user should receive a confirmation page as well as an email to notify
       him of the successful registration,
      A user must be able to login by using his email address and password,
      A user must be able to retrieve his password by email,
      A user must be able to modify his personal information,
      A user must be able to create many plans with the following parameters:
       moving date, origin and destination countries, origin and destination cities,
       home and car ownerships, moving with children and pets, possibility of
       getting weekly updates,
      A user should receive a confirmation page of the creation of a plan,
      A user should be able to modify the settings of a plan,
      A user should receive a confirmation page of the plan updates,
      A user should be able to visualize information about the plan: information
       about the destination country, health requirements, passport procedures…
      A user should be able to display a weekly schedule summarizing the tasks
       to perform. A warning popup is sent if no plan is selected.
      A user should be able to delay task from one week to the other,
      A user should be able to delete a task from the schedule,
      A user should receive a warning before deleting a task,
      A user should be able to mark a task as done/not done in the schedule,
      A user should be able to jump from one week to a next or a previous one,
      A user should be able to delete a plan; A warning is sent if no plan exists.
      A user should receive a warning before deleting a plan,
      A user should be able to delete a plan,
      A user should receive a visual confirmation of the deletion of the plan,A
       user should be able to display all the tasks available on a single page.

II.2   Entity Relationship diagram

Figure 1 is the Entity Relationship diagram corresponding to the database
business rules defined above.




                                         8
MGT 6051 - Spring 2001   Georgia Institute of Technology




                             - figure 1 -


                                  9
MGT 6051 - Spring 2001                              Georgia Institute of Technology


III   Physical design of the database


III.1 Microsoft Access

Figure 2 gives an overview of the relationships between the tables.
We are forced to use in Microsoft Access the notion of virtual tables.
Indeed, the table PLAN contains three distinct attributes that are linked to
the same attributes of the country table. The “nationality” attribute, the
“country_orig” and the “country_dest” attributes are all linked to the “country_id”
attributes.


III.2 SQL Query using virtual tables

The following query returns the Country Names of the Origin and Destination
Countries, by using a virtual table COUNTRY1 image of the table COUNTRY.
Such query is used to display in a combobox the different plans made by a user
and available for display.


SELECT COUNTRY.Name_Us, COUNTRY_1.Name_Us FROM PLAN, COUNTRY, COUNTRY
AS COUNTRY_1 WHERE PLAN.Country_Orig=COUNTRY.Country_Id AND
PLAN.Country_Dest=COUNTRY_1.Country_Id AND Plan.Plan_Id=15




                                        10
MGT 6051 - Spring 2001   Georgia Institute of Technology
                         Relationships




                             - Figure 2 -

                                 11
MGT 6051 - Spring 2001                                 Georgia Institute of Technology


IV     Active Server Page (ASP)


IV.1 Presentation of the ASP

An Active Server Page (ASP) is an web page that includes one or more script
(small embedded programs) that are processed on a Web server before the page
is sent to the user. An ASP is somewhat similar to a Server-side include
or a common gateway interface (CGI) application in that all involve programs that
run on the server, usually tailoring a page for the user. Typically, the script in the
Web page at the server uses input received as the result of the user's request for
the page to access data from a database and then builds or customizes the page
on the fly before sending it to the requestor.

ASP is a feature of the Microsoft Internet Information Server (IIS),
but, since the server-side script is just building a regular HTML page,
it can be delivered to almost any browser. You can create an ASP file
by including a script written in VBScript or JScript in an HTML file
or by using ActiveX Data Objects (ADOs) program statements in the HTML file.
You name the HTML file with the ".asp" file suffix. Microsoft recommends the use
of the server-side ASP rather than a client-side script, where there is actually a
choice, because the server-side script will result in an easily displayable HTML
page. Client-side scripts (for example, with JavaScript) may not work as intended
on older browsers.


IV.2 ASP coding

As the code written for Directmoving is proprietary, the following is
a general explanation about the way ASP handles database.

ASP allows the users to execute all database queries or none at all:
SELECT, INSERT, or UPDATE a lot of records collectively

"A transaction is an atomic unit of work that either fails or succeeds as a whole."
In a transaction there can be any number of things to do, like update one thing,
send email, do that thing and so on. If transaction is successful,
all of these things will be done or executed as the case may be, or if transaction
fails then none of them will be executed.

When a transaction is successful it is said that this transaction has committed
and all the tasks that it had to do will be done. If there is some error then
the whole transaction will be brought back to it's original state and none of the
task that it had to do will be completed, it is called rolling back of the transaction.


                                          12
MGT 6051 - Spring 2001                                       Georgia Institute of Technology




Transactions are very simple. They are a means to allow users to do many tasks
or not to do any of them. There is no such thing in a transaction that one task is
done and other is not. Transactions are always executed as a 'whole'.

Database transactions are part of these transactions. Users will be able to
execute all of the SQL queries or if some error occurs then rollback all the
actions and no query gets executed. It is also possible to build a very useful
function to track database errors and show them to the user if some error occurs.


Step 1: creation of the access database


Users create a new Access database and save it as MDB file. Then, some new
table are designed through the 'design view' as follows:




Once saved, the table will appear in „view mode‟ as follows:




Step 2: create an error tracking function


The ErrorsFound ASP function will track database errors and report it to the user.

Function ErrorsFound(mycon)
Dim myError

If mycon.State <> 1 Then

eStr = "<table border=1 width=""90%"" align=""center""" & _
" bordercolor=""#E2EAEE"" style=""font-family:verdana; font-size:8pt;""" & _
" cellpadding=3>" & _
"<tr><td>Error</td><td>Database not found.</td></tr>" & _
"<tr><td>Page</td><td>" & Request.ServerVariables("SCRIPT_NAME") & _



                                               13
MGT 6051 - Spring 2001                                    Georgia Institute of Technology


"</td></tr><tr><td>Date & Time</td><td>" & FormatDateTime(Date, 1) & _
" " & Time & "</td></tr></table><br>"

ErrorsFound = True

ElseIf mycon.Errors.Count > 0 Then

For Each myError in mycon.Errors


If myError.Number <> 0 Then
eStr = "<table border=1 width=""90%"" align=""center""" & _
" bordercolor=""#E2EAEE""" & _
" style=""font-family:verdana; font-size:8pt;"" cellpadding=3>" & _
"<tr><td width=100>Error Property</td><td>Contents</td>" & _
"</tr><tr><td>Number</td><td>" & myError.Number & _
"</td></tr><tr><td>Native Error</td><td>" & _
myError.NativeError & "</td></tr>" & _
"<tr><td>SQLState</td><td>" & myError.SQLState & _
"</td></tr><tr><td>Source</td><td>" & _
myError.Source & "</td></tr>" & _
"<tr><td valign=""top"">Description</td><td>" & _
myError.Description & "</td></tr>" & _
"<tr><td>Page</td><td>" & Request.ServerVariables("SCRIPT_NAME") & _
"</td></tr><tr><td>Date & Time</td><td>" & FormatDateTime(Date, 1) & _ " " & Time & _
"</td></tr></table><br>"
ErrorsFound = True
End If
Next
Else
ErrorsFound = False
End If
End Function

This Function will return True if an error is found and False if none. Note this
Function can also detect the error if you remove or rename the database.

Explanations:

If mycon.State <> 1 Then

Connection.State property tells users that whether the connection to the
database is open or not. If connection is open then it is equal to 1 and if closed
then it is equal to 0. So in the above line this property is checked to detect if the
database could be opened or not, if not then an appropriate error message is
shown and exit the Function.

ElseIf mycon.Errors.Count > 0 Then
For Each myError in mycon.Errors
If myError.Number <> 0 Then




                                             14
MGT 6051 - Spring 2001                                   Georgia Institute of Technology


Next a check is performed to see if Connection.Errors.Count is greater than 0 or
not. If any errors occur then this error count will be greater than 0. So if there is a
non-zero error count then iterate through the Connection.Errors collection and
show all the information we have about the error.


Step 3: Coding the ASP page


A typical ASP page is presented as follows:

 <%
  Option Explicit
  Response.Buffer = True
 On Error Resume Next
 Dim connStr, eStr
  connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
       Server.MapPath("db.mdb")

 Function ErrorsFound(mycon)
  Dim myError

  If mycon.State <> 1 Then
    eStr = "<table border=1 width=""90%"" align=""center""" & _
    " bordercolor=""#E2EAEE""" & _
    " style=""font-family:verdana; font-size:8pt;"" cellpadding=3>" & _
    "<tr><td>Error</td><td>Database not found.</td></tr>" & _
    "<tr><td>Page</td><td>" & Request.ServerVariables("SCRIPT_NAME") & _
    "</td></tr><tr><td>Date & Time</td><td>" & _
    FormatDateTime(Date, 1) & " " & Time & _
    "</td></tr></table><br>"

  ErrorsFound = True

  ElseIf mycon.Errors.Count > 0 Then
   For Each myError in mycon.Errors

   If myError.Number <> 0 Then
     eStr = "<table border=1 width=""90%"" align=""center""" & _
     " bordercolor=""#E2EAEE""" & _
     " style=""font-family:verdana; font-size:8pt;"" cellpadding=3>" & _
     "<tr><td width=100>Error Property</td><td>Contents</td>" & _
     "</tr><tr><td>Number</td><td>" & myError.Number & _
     "</td></tr><tr><td>Native Error</td><td>" & _
     myError.NativeError & "</td></tr>" & _
     "<tr><td>SQLState</td><td>" & myError.SQLState & _
     "</td></tr><tr><td>Source</td><td>" & _
     myError.Source & "</td></tr>" & _
     "<tr><td valign=""top"">Description</td><td>" & _
     myError.Description & "</td></tr>" & _
     "<tr><td>Page</td><td>" & Request.ServerVariables("SCRIPT_NAME") &
     "</td></tr><tr><td>Date & Time</td><td>" & _
     FormatDateTime(Date, 1) & " " & Time & _
     "</td></tr></table><br>"


                                            15
MGT 6051 - Spring 2001                                          Georgia Institute of Technology


  ErrorsFound = True
 End If
  Next
 Else
  ErrorsFound = False
 End If
End Function
%>
<html>
<head>
 <style>body, p, td { font-family : Verdana; font-size : 10pt; }</style>
</head>
<body>
<%
 Dim con
  Set con = Server.CreateObject("ADODB.Connection")

  con.Open connStr
   Response.Write "Opening Connection...<br><br>"

  con.BeginTrans
   Response.Write "BeginTrans Called...<br>"
  con.Execute("insert into TestTable(name) values ('Salim Elahi')")
   Response.Write "Trying to insert records .no1...<br>"

  con.Execute("insert into TestTable(name) values ('Arshad Khan')")
   Response.Write "Trying to insert records .no2...<br>"

  If ErrorsFound(con) = False Then
    con.CommitTrans
    Response.Write "Committing Transaction...<br>"
    Response.Write "Records added successfully...<br><br>"

  Else
   con.RollbackTrans
   Response.Write "Rolling back transaction...<br>"
   Response.Write "Records were not added...<br><br>"

  End If

 con.Close
  Response.Write "Closing Connection...<br>"
 Set con = Nothing
  Response.Write "Setting Con = Nothing...<br><br><br>"

 If Len(eStr) Then
   Response.Write eStr
 End If

 ' ADO Constants
 Const adCmdText = &H0001
 Const adCmdTableDirect = &H0200

 ' Recordset Object
 Dim rs, query
   query = "TestTable"


                                                16
MGT 6051 - Spring 2001                                         Georgia Institute of Technology


   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.Open query, connStr, , , adCmdTableDirect

    If Not rs.EOF Then
  ' Creating the table
  Dim i, j
    Response.Write "<table align=""center"" border=""1"""
    Response.Write " width=""90%"" cellspacing=""1"" cellpadding=""3""" & _
    Response.Write " bordercolor=""silver"">" & vbcrlf
    Response.Write "<tr>"
  Dim Item
    For Each Item in rs.Fields
      Response.Write "<td bgcolor=""silver"">" & Item.Name & "</td>"
    Next
    Response.Write "</tr>"

 Dim ds
  ds = rs.GetRows

  End If

   rs.Close
   Set rs = Nothing
 If IsArray(ds) Then
   ' Showing Each Row
   For i = 0 To UBound(ds, 2)
     Response.Write "<tr>" & vbcrlf
     ' Showing Each Column
       For j = 0 To UBound(ds, 1)
        If ds(j, i) = False Then
        Response.Write "<td style=""color:red;font-size:7pt;"">"
        ElseIf ds(j, i) = True Then
        Response.Write "<td style=""color:green;font-weight:bold;"">"
        Else
        Response.Write "<td>"
        End If
        Response.Write ds(j, i)
        Response.Write "</td>"
       Next
     Response.Write "</tr>" & vbcrlf
   Next

  Response.Write "</table>"

   Set ds = Nothing
  End
If

 %>
 </body>
 </html>




                                                17
MGT 6051 - Spring 2001                                     Georgia Institute of Technology




Explanations:


Although the code that I provided in the last page looks a lot, but if you take a
closer look it is very simple and most of the things you will already be able to
understand.

   con.BeginTrans
    Response.Write "BeginTrans Called...<br>"

After opening the connection to the database,                          we   execute   the
Connection.BeginTrans method to start the transaction.

   con.Execute("insert into TestTable(name) values ('Salim Elahi')")
    Response.Write "Trying to insert records .no1...<br>"
   con.Execute("insert into TestTable(name) values ('Arshad Khan')")
    Response.Write "Trying to insert records .no2...<br>"

Then we execute two SQL queries to enter two names in the database.

   If ErrorsFound(con) = False Then
     con.CommitTrans
     Response.Write "Committing Transaction...<br>"
     Response.Write "Records added successfully...<br><br>"

   Else
    con.RollbackTrans
    Response.Write "Rolling back transaction...<br>"
    Response.Write "Records were not added...<br><br>"
   End If

Next we use the ErrorsFound Function that we created earlier to check if any
errors occured, if not then commit the transaction, otherwise do rollback. Then
we close the connection and show the error message (if any) and then the
records. The point to note is that the two queries we ran as a transaction will only
be executed if no database errors occur, if they do then the queries will be
rolledback and no changes will be produced in the database.


Step 4: Running the ASP page :


Both MDB and ASP files should be placed in the same directory. A simple call of
the ASP file through a web browser will run it and execute the SQL queries.




                                             18
MGT 6051 - Spring 2001                               Georgia Institute of Technology


V       Interface design and implementation


V.1     Overall view of the Moving Planner

Figure 3 summarizes all the relationships between the pages of the moving
planner. The main links are as follows:

       An unregistered user accesses a form (2) from the homepage (1) allowing
        the registration. Upon validation of the procedure, the first name, last
        name, email address, and password are stored in the database.
        Simultaneously, a confirmation email is sent to the user and the user is
        redirected to page the confirmation page (3). A link is accessible to go to
        page (5).
       In case of unsuccessful login, page (4) is displayed, and the user is given
        the possibility to receive his password by email.
       If the login is successful, page (5) is displayed. The user is now able to
        select between several options: edition of personal information, creation of
        a new plan, deletion of an existing plan, selection of an existing plan.
       The “Modify personal settings” option is a redirection to page (8). The user
        can change his last name, first name, email address, and password. Upon
        validation of the changes, the user is sent back to page (5).
       The “Delete plan” option is a redirection to page (9). The user can there
        select a plan and delete it. A popup window warns him of the deletion and
        asks for confirmation.
       The “Create new plan” is a redirection to page (11). The user enters all
        parameters relative to a plan such as origin and destination countries and
        cities, if he wants a weekly update… The validation of the page redirects
        the user to page (6),
       Page 6, the plan visualization, allows the user to display the plan
        information or to modify the settings of a plan. This page can be accessed
        either from page (5) when a plan is selected or from page (11) when a
        plan is created.
       The plan information page (7) contains a link to the moving planner as well
        as external links, some to partners‟ databases (Country information, health
        information, embassies information).
       Finally, page (11), the moving planner, displays on a weekly basis all the
        tasks to be performed so as to accomplish as successful moving. The
        user can browse every week, mark a task as done or not done, delete the
        unwanted tasks.




                                         19
MGT 6051 - Spring 2001                                              Georgia Institute of Technology




                                  (1)                 Logical Organization                                                      (9)
                                Home                                                                                       Delete plan
                                Login                                                                                    Form : Select Plan
                              Inscription                                                                           Popup windows: Confirmation


                                                                                 (5)
                                                                         Login Successful
                                                                  [Session opened for 30 minutes]
       (4)
                                  (2)                                Edit personnal information
      Login
                               New user                                Select plan to visualize
    Incorrect
                                 Form                                     Create new plan                                       (8)
  Email to send
                                                                         Delete existing plan                        Modify personal settings
   password?
                                                                                                                               Email
                                                                                                                            First name
                                                                                                                            Last Name
                                   (3)                                                                                      Nationality
                         Inscription successful
                              [Email sent]


                                                                     (6)
                                                              Visualize plan
                                                        Setup of the plan parameters
                                                                Visualization                                                  (11)
              (7)                                                                                                        Create new plan
      Plan information                                                                                                    Departure date
       Weekly schedule                                                                                                    Origin Country
     Country Information                                                                                                Destination country
      Health Information
     Embassy Information
     Weather Information                                                                              (10)
                                                                                             Modify plan settings
                                                        (12)                                     moving date
                                          Display of the weekly schedule                        origin country
                                               Setup Tasks displayed                          destination country
        External links


                                                                           - Figure 3 -


                                                                               20
MGT 6051 - Spring 2001                           Georgia Institute of Technology


V.2   Implementation

The final implementation has been delivered to DirectMoving. It includes the
Database file (.mdb) and the ASP / HTML pages.

Here are two snapshots of the tool we developed, integrated with the graphical
interface of the official website of DirectMoving.




                                     21
MGT 6051 - Spring 2001                               Georgia Institute of Technology


Conclusion


We have presented the tool to DirectMoving‟s Project Director,
and the company was satisfied of the result, as shown by the following message
we received:



“I wanted to congratulate your team for the excellent job you have done with this
project, the Move Planner.

You have been able to put in practice the ideas we had in mind when we were
not even sure how to do it.

You have paid attention to details and have shown a great deal of
professionalism.

Rami and I would like to thank you all for your efforts and the fantastic result you
have achieved.

With very best regards”

Emmanuelle PUTAUX
Project Director




                                        22

				
DOCUMENT INFO