Page 294 - IT-802_class_12
P. 294
B. Long answer type questions.
1. How DBMS can be used in education?
Ans. DBMS can be used in education to:
Ð keep data such as student information, grades, timetable and results.
Ð keep track of staff and faculty details.
Ð keep track of school/college information like department and course offerings
Ð keep track of all infrastructure information.
2. How DBMS can be used in the areas of companies?
Ans. DBMS can be used in the areas of companies to:
Ð To maintain information regarding the projects handled by them.
Ð To keep track of infrastructure, sales, and investments, loose.
3. Name any 5 applications that can be created using database?
Ans. Ð Bill payment and bill generation application
Ð Library management application
Ð Real estate management application
Ð Inventory control application
Ð Shop management application
4. Give details of BUYER table along with its schema.
Ans. 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
5. A company is making database of its items and shipment. Item table includes item code, item name, item cost . Give details
of Shipment Table along with its schema. [CBSE Sample Paper 2023]
Ans. SHIPMENT (Shipment_id, Details, Shipment_date)
Name Data Remarks
Buyer_id INT(10) Shipment number (Primary Key)
Details VARCHAR(20) location details
Shipment_date DATE Date of shipment
6. List the various ways in which database management applications can be used in Government Sector.
[CBSE Sample Paper 2023]
Ans. For storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax etc.), criminal records, details of PAN
cards, AADHAR cards, vehicle registration, birth/death certificate registration.
292 Touchpad Information Technology-XII

