Page 283 - IT-802_class_12
P. 283
• Telecom management application
• Insurance management application
4.2 case stUdY-a sHoPPInG WeBsIte
In this section, we shall study the database management application used in MINI-MART Shopping Website that allows
users to shop online by providing 24 × 7 access. The website offers a wide range of products ranging from books, clothes,
stationery, kitchen appliances, and electronic items. A customer can select items to be purchased by putting them in the
shopping cart or in the wish list. The website also allows users to make a choice of the product by performing comparative
analysis of the products. The order can be completed by choosing to pay through Cash on Delivery option, credit/debit
card, or net banking. Once the payment is made, goods will be delivered to the address specified by the customer.
The left panel of the website shows various categories of products. In the center, there are pictures of some of its
products. The right panel displays offer details as well as links to contact, login, and track orders.
4.2.1 Entities Involved
Let us look at the different types of information that must be kept in the database in order to create the shopping
application. For each entity, a separate table is to be created using the create SQL command. The primary key is
underlined in each case.
Ð ÐCATEGORY: This table stores categories of commodities available. It will store information such as category id, name
of category and its description.
Schema: CATEGORY (Category_id, Name, Description)
Name Data Type Description
Category_id INT(10) Category number (Primary Key)
Category_Name VARCHAR(20) Name of Category
Category_Description VARCHAR(20) Description of Category
Work-Integrated Learning IT-DMA 281

