Page 296 - IT-802_class_12
P. 296
B. Long answer type questions.
1. List the various ways in which database management applications can be used in government sector.
2. 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.
3. A hospital is making database of patients and its staff. Doctor table includes Docid, Dname, and Department. Give details of
Patient Table along with its schema.
4. Give details of PAYMENT Table along with its schema.
5. Aman wants to shop shoes online. Write detailed Steps/ procedure to be followed while shopping online.
[CBSE Sample Paper 2021]
C. Competency-based/Application-based question: Subject Enrichment
Viraj is creating an application for online shopping. He is creating a table for commodities. The information stored in this
table is given below:
COMMODITY (Commodity_id, Name, Category_id, Price, Quantity, Discount, Brand, Color, Size, Seller_id, Description)
He wants to declare foreign keys in this table. Help him do so.
Previous Years’ Questions
1. Predict the output: [2023]
String myStr = “Welcome Users”;
System.out.println(“New String:”+myStr.toUpperCase());
Ans. WELCOME USERS
2. Write the use of database management in Railways. [2022]
Ans. The uses of database management in Railways are as follows:
• To store information about train details such as arrival time, departure time, fares, passenger capacity, number of
bookings.
• To keep track of online and offline reservations.
3. (a) How are database management concepts helpful in Telecommunications? [2022]
(b) An Airlines company is making a database of its flights and staff. The staff table includes: Emp_id, Emp_name, Emp_
dob, E_sal. Give the details of Flight table with its scheme.
Ans. (a) The uses of database management in Telecommunication are as follows:
• To store information on communication networks, customers, call records, and their bills.
• To store information on the plans offered and plans subscribed by the users.
(b) Flight Table
Schema: Flight (Flight_Number, Fllight_From_Flight_To, Flight_capacity, Flight_Fare)
Name Type Remarks
Flight_Number INT(10) Flight Number, Primary Key
Flight_From VARCHAR(30) Flight Departure from
Flight_To VARCHAR(30) Flight Destination
Flight_capacity INT(10) Seating capacity of flight
Flight_Fare DECIMAL(10,2) Fare of ticket
294 Touchpad Information Technology-XII

