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

