Page 284 - IT-802_class_12
P. 284

Ð ÐCOMMODITIES: This table stores details of commodities available. It will store information such as commodity_id,
           commodity_name, category_id, price, quantity, discount, brand, color, size, seller_id and its description.
           Schema: COMMODITY (Commodity_id, Name, Category_id, Price, Quantity, Discount, Brand, Color, Size, Seller_id,
           Description)


                         Name                        Data Type                       Description

           Commodity_id                      INT(10)                    Commodity number (Primary Key)
           Comm_Name                         VARCHAR(20)                Name of the commodity

                                                                        Category to which the commodity belongs
           Category_id                       INT(10)
                                                                        (Foreign Key)
           Price                             INT(10)                    Price of commodity
           Quantity                          INT(10)                    Number of items left in stock

           Discount                          INT(3)                     Discount available of the commodity
           Brand                             VARCHAR(20)                Brand of the commodity

           Color                             VARCHAR(20)                Color of the Commodity
           Size                              VARCHAR(20)                Size of the Commodity

           Seller_id                         INT(10)                    Seller of the Commodity (Foreign Key)

           Description                       VARCHAR(20)                Description of Commodity

        Ð ÐBUYER: This table stores buyer details specified by him either at login time or during order. It will store information
           such as Buyer_id, password, first_name, last_name, address and email_id and phn_no.
          Schema: BUYER (Buyer_id, Password, First_name, Last_name, Address, Email_id, Phn_no)

                         Name                       Data Type                        Description

            Buyer_id                        INT(10)                    Buyer number (Primary Key)

            Password                        VARCHAR(20)                Login password of buyer
            First_name                      VARCHAR(20)                First name of buyer

            Last_name                       VARCHAR(20)                Last name of buyer
            Address                         VARCHAR(20)                Address of buyer

            Email_id                        VARCHAR(20)                Email id of buyer
            Phn_no                          INT(10)                    Contact number of buyer


        Ð ÐVENDOR: This table stores details about vendor of the commodities. It will store information such as vendor_id and
           rating of vendor.
          Schema: VENDOR (_id, Rating)


                         Name                       Data Type                        Description

            Vendor_id                        INT(10)                   Vendor number (Primary key)
            Rating                           INT(1)                    Rating of vendor



          282   Touchpad Information Technology-XII
   279   280   281   282   283   284   285   286   287   288   289