Page 169 - DCAP306_DCAP511_E-COMMERCE_AND_E-BUSINESS

E-Commerce and E-Business

The attributes of the data must be entered while designing the database so that the searching process of
the customers can be done easily.

The figure 13.6 depicts the schematic diagram of the relational database in which the products and its
details are stored. Each table is interrelated such that the customer is provided with complete details of
the product, payments, and shipping process.

Figure 13.6: Relational Database

Source: http://www.princeton.edu/~rcurtis/ultradev/ecommdatabase.html
In the figure 13.6, the tables created are Suppliers, Products, Category, Shippers, Order details, Orders,
Payment, and Customers. The Suppliers table consists of various attributes such as supplier ID,
company name, contact address of the manufacturer, type of products, and so on. The Products table
consists of product name, supplier ID, picture of the product, price, description of the product, and so
on. The Category ID table is linked to the Product table such that the category under which the product
is advertised can be retrieved easily. The Order Details table is interrelated with Products table and
Orders table. It consists of order ID, product ID and other attributes related to the order of the product.
The Payment table describes the type of payment, mode of transaction, and the amount details in the
transaction. The Customers table includes the customer’s data such as name, address, shipping address,
and so on.
There are different database systems that are used for creating e-commerce Web site. Some of databases
are:
1. SQL server is the most popular database software systems for storing large quantity of data. SQL
is Structured Query Language for accessing the databases. If the business requires Web site to be
able to store and retrieve data from a database, it must have access to a database which is coded
using SQL.
2. Microsoft Access software is used when Web site requires simple database solution.
3. Oracle is a very popular database software for data driven Web sites with high traffic.

162 LOVELY PROFESSIONAL UNIVERSITY