Aleksey Burdakov:
Realized Projects Description:
INTERNET SHOP

eng rus

 Introduction

The Internet shop was developed for VESCO Company. The main goal of this Internet shop is selling spirits and vines through the Internet. This trade method gives a lot of advantages: fast customer service, it covers all parts of Moscow city area, adverts VESCO company as a leading retail and wholesale trading company in Moscow.

Total project development, installation, and maintenance cost were reduced to the lowest level. Therefore, the most inexpensive methods were used (off-line connection through e-mail and FTP protocol and no online database on an ISP server).

Solved problems/tasks

The following problems/task were solved/done:

  1. Requirements analysis
  2. System architecture design
  3. Data Flow Diagram design
  4. ER-diagram design
  5. HTML design
  6. Development of the Internet shop in JavaScript language/HTML
  7. CGI-script development in Perl language
  8. Describing/Exporting/Importing/Browsing utilities design
  9. Testing

 

Software component structure

 

    1. VESCO part

  • Corporate database, which includes information about goods and current stock level (remains of the goods)
  • Goods description utility - allows to make a description, stores images of the goods into corporate database
  • HTML templates - specially designed templates
  • Import utility - imports data from corporate database to special structures, suitable for WWW-server part
  • Export utility - process e-mail messages, received from ISP's e-mail server, then transforms them and puts into corporate database for further processing
  • Order processing - this part process orders from the Internet-shop and puts them into corporate database.

    2. ISP part

  • HTML pages/JavaScript - HTML pages with JavaScript programs those make UI and form orders
  • CGI script, which provides sending orders through e-mail to VESCO side

    3. Client part

  • An Internet browser (MS Internet Explorer 3.x, 4.x, NS Navigator 3.x, 4.x)

 

     The Internet shop system architecture, as well as events order and processes, are described in the following list:

 

  1. HTML-files generation:

    2. Special software reads data from the database (remains of goods, commodity description, commodity register, etc.) then forms this data into set of HTML files using special templates, previously created and designed.

  2. HTML-files transmission to ISP WWW/FTP server and local WWW/FTP

    3. Transmission of files to ISP WWW/FTP server is performed via FTP (file transfer protocol).

  3. WWW site browsing

    4. Customer browses WWW site (via his/her browser: Netscape Navigator 3.x, 4.x or Microsoft Internet Explorer 3.x, 4.x), selects goods and quantities, fills in his (her) requisites, and makes an order.

  4. Sending an order from client to ISP server

    5. When a customer applies his/her order, the order is being send via POST method to specially written CGI-script on ISP server.

  5. Formatting the order to e-mail message on ISP mail server

    6. The CGI-script, which is written in Perl and resides on the ISP server, processes the order and forms it into special e-mail format, then sends it to the ISP mail server.

  6. Posting the e-mail message to e-mail client

    7. Client receives the order from ISP mail server via POP3 protocol and stores the message in its local mail database. Each order has its own unique number (order number).

  7. Message processing and storing into the corporate database

    8. Special software reads e-mail database via MAPI protocol from the local database, then selects fields in the order, and puts the order into the corporate database.

  8. Orders browsing
    Employee browses orders, stored in the database, via special program, written on Centura Team Developer, and selects orders for processing, then prints it, checks the order and delivers goods to the customer.

 

 

Appendix A

Internet-shop.gif (15571 bytes)

 

Appendix B

Internet-shop DFD.gif (16103 bytes)

 

 

Appendix C

ER model.gif (12733 bytes)