Transcript Directmoving.com - El

Directmoving® Planner
Georgia Institute of Technology
MGT 6051 – Database Management Systems
Database Project
Lin Gui - Karim El-Khazen - Philsou Lee
Xiaoting Niu - Pascal Suria
Directmoving® Planner
 Directmoving.com:
First Worldwide Relocation Portal on the
web available to Expatriates and to HR
Managers
responsible
for
relocating
personnel.
 Help them prepare their departure and
organize their daily life in a new country.
 Provide access to a host of information,
services, tools and practical advice
covering all aspects of moving abroad.
Directmoving® Planner
 Competitors: recent creation of a planner tool, which
puts all the moving tasks of a future expatriate into a
calendar.
 Let the user select his moving date and some options.
Give a weekly summary of all the tasks to complete.
Restricted to the USA.
 Directmoving: willing to implement
version:
- international oriented
- customized countries information
- and more options
an
extended
Directmoving® Planner
Entity / Relationship explanations
User makes Plans
 M:N relationship between user and plan.
 Binary attributes: Car, Pets, Moving_Date, Children, Home, Nationality
and Weekly_Update
 Combo box selection: Nationality, Country_Origin, and
Country_Destination
Plan checks Tasks
 M:N relationship between plan and task.
Plan picks Countries
 M:1 relationship between plan and country
 Two relations: an Origin Country and a Destination Country
Directmoving® Planner
Directmoving® Planner
Active Server Pages (ASP)
Definition of ASP:
 Server based scripting language Interpreted at run time.
 Used to create Server Side logic to handle anything from Dynamic page
creation to data coming from a Client Browser.
Main features of ASP:
 Form Logic: possibility of receiving data from a form, process it with an
If...Then... statement and if conditions are met dynamically write a
response HTML page and display it to the Client Browser.
 Client Browser Redirection: used to send the Client Browser to another
Web Page or Web Site automatically if a condition is met.
 Database Access:
ASP is excellent for storing User Data in a
database. Possibility of using a Server side text file, MS Access, or SQL
Server.
Directmoving® Planner
ASP implementation examples:
 Database Connection:
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open "DRIVER={Microsoft Access Driver *.mdb)};
DBQ=" & Server.MapPath("/database/moveplanner.mdb")
 SQL query:
Req = "SELECT Moving_Date FROM Plan WHERE Plan.Plan_Id="
Req = Req & Session("Plan")
set affichage=objConn.execute(req)
Response.Write affichage("Moving_Date")
set affichage=nothing
Directmoving® Planner
Online May 2001
www.directmoving.com
