Page 295 - IT-802_class_12
P. 295
Subject Enrichment
C. Competency-based/Application-based question:
Ananya is creating an online shopping application. She wants to create a table for wish list. But she has no idea what
elements this table should have. Help her by giving the details of the Wish List table and its schema.
Ans. WISH_LIST (Buyer_id Commodity_id)
Name Type Description
Shipment_id INT(10) Buyer number(Primary key and Foreign key)
Commodity_id INT(10) Commodity number (Primary Key and Foreign key)
Unsolved Exercise
Section A
(Objective Type Questions)
A. Choose the correct option.
1. Which of the following is not an example of eGovernance?
i. To file property tax ii. To apply for renewal of Passport
iii. To start an online coding course for 3 months iv. To get Voters ID card issued
2. Which of the following is/are the applications of database in e-commerce?
i. To maintain details on transactions that happens everyday
ii. To store information on products such as price, quantity, quality, manufacturing date, and seller.
iii. To store information on the plans offered and plans subscribed by the users.
iv. All of these
3. Which of the following is the foreign key in order table?
i. Order_id ii. Buyer_id
iii. Order_date iv. Current_status
4. What is the data type of Payment_date?
i. Int ii. Varchar
iii. Date iv. Char
B. Fill in the blanks.
1. Cash on Delivery is a payment method in ................................ .
2. The primary key of ................................ table is a combination of both its attributes, the buyer_id and commodity_id.
3. The Phase of application development that involves creating a database and writing code is called ................................ .
4. If the buyer selects any category on the website, function ................................ is invoked to display all the products in that
category.
Section B
(Subjective Type Questions)
A. Short answer type questions.
1. What is the importance of password field on online reservation site? [CBSE Sample Paper 2021]
2. Write any two uses of database in airlines.
3. What information does the PACKAGE table store?
4. Name the foreign keys of WISH LIST table.
Work-Integrated Learning IT-DMA 293

