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
   278   279   280   281   282   283   284   285   286   287   288