Page 292 - IT-802_class_12
P. 292
PRODUCT: This table stores details of products available for shopping. It will store information such as product_id, name,
price, quantity, brand, color, size, seller_id.
Entities Involved
Schema: PRODUCT (Product_id, Pname, Price, Qty, Brand, Colour, Size, Seller_id)
(The column name underlined is the primary key).
Name Datatype Remarks
Product_id Int(10) Product number which will identify it (Primary Key)
Pname Varachar(50) Product Name
Price Number (10,2) Price of the Product
Qty Int (10) Quantity of items left in Stock
Brand Varchar(50) Item’s brand name
Colour Varchar(50) Item’s colour
Size Number(10,2) Item’s size
Seller_id Int(10) Id of the seller selling the item
In an application, you will have to create various tables like SELLER, BRAND DETAILS, CATEGORY etc. Developing a schema
like the one given above will help you have clarity of thought and develop the layout of your database.
Recap Zone
Ð Ð Since database management systems provide efficient data storage and fast retrieval, they find applications in a variety of fields.
Ð Ð Database application is used in education to keep data such as student information, grades, timetable and results.
Ð Ð Database application is used in banking to keep track of consumer data. For instance, Customer personal information like
residence, age, gender, PAN card, occupation, and contact information will be collected.
Ð Ð Database application is used in to store information about guests, their check-in and check-out times, duration of stay and room
number allocated.
Solved Exercise
Section A
(Objective Type Questions)
A. Choose the correct option.
1. Which of the following is/are the applications of database in education?
i. To maintain details on transactions that happens everyday.
ii. To keep track of online and offline reservations.
iii. To keep data such as student information, grades, timetable and results.
iv. None of these
2. Which of the following is a payment method in online shopping?
i. Net banking ii. Credit card
iii. Cash on delivery iv. All of these
290 Touchpad Information Technology-XII

