Chapter 3: Database Management System using LibreOffice Base

Important questions — the ones the board asked most (13)

1. Q1Short answer4 marksAsked: 2026

   19. With reference to DBMS, answer the following questions : (a) What is the purpose of using reports in DBMS ? (b) Can we generate a report from multiple tables in a database ? (c) What is a dynamic report ? (d) In LibreOffice Base, to insert the current date and time in a report, the steps to be followed are : Step 1 : Click inside the Page Header area to activate it. Step 2 : Click ____________ > ____________ However, the correct menu item and option names are missing. Identify the correct menu item and option name needed to complete this task.

   

   Medha Ma’am

   Ask Medha’s AI teacher

   Hear it from Medha Ma’am · 120 s

   Model answer · Reports in LibreOffice Base

   1. 1.(a) In a DBMS, a report is used to present the retrieved data in an attractive and customized manner. Records extracted by a query are shown only in a simple row and column format. A report lets us display the data from one or more tables in a presentable manner, and we can add controls such as titles, author name and the date of generation of the report.1 mark
   2. 2.(b) Yes. A report can be created from a table, a query or both, so it can show data from multiple tables. If a report has to be generated from multiple tables, a query should preferably be created first. That query can then be used to generate the report.1 mark
   3. 3.(c) A dynamic report is a type of report that changes automatically as the field values in the base table or query change. Whenever the data in the base table or query is updated, the report shows the latest data.1 mark
   4. 4.(d) Step 2: Click Insert > Date and Time… option. The menu item is Insert and the option is Date and Time…. The Date and Time dialog box then appears. Select the desired format for the date and time and click on the OK button. The date is inserted in the Page Header area.1 mark

   Marks split as in the board’s published marking scheme

2. Q2Case-based4 marksAsked: 2026

   21. An electronic gadget shop keeps records of its electronic products, such as mobile phones, laptops, etc., in a table named Gadgets, which has columns for ItemID (Primary key), ItemType (mobile, iPad, Laptop), Size, Quantity, Price and Supplier. It also stores the billing data in another table named Bill, which has columns as BillNo (Primary key), ItemID, Price, CustName and CustPhoneNo. Based on the above, answer the following questions : (a) Name any two columns of the Gadgets table where duplicate values are allowed. (b) Assume that the table Gadgets already contains a product having value of ItemID as I001. Can we enter a new record with value of ItemID as I001 ? Justify. (c) Is it possible to store photos of the products in a new column of the table, Gadgets ? If yes, then suggest a suitable data type to store images. (d) Briefly explain the principle of referential integrity with respect to the tables, Gadgets and Bill.

   

   Medha Ma’am

   Ask Medha’s AI teacher

   Hear it from Medha Ma’am · 170 s

   Model answer · primary key, referential integrity

   1. 1.(a) ItemType and Supplier (also Size, Quantity, Price) can have duplicate values.1 mark
   2. 2.(b) No — ItemID is the primary key, and a primary key must be unique for every record, so I001 cannot be entered again.1 mark
   3. 3.(c) Yes, photos can be stored in a new column of the Gadgets table.0.5 marks
   4. 4.A suitable data type is Image (binary, e.g. BLOB/LONGVARBINARY; OLE Object in some DBMS).0.5 marks
   5. 5.(d) Referential integrity: the foreign key ItemID in Bill must match an ItemID that already exists in Gadgets (the primary key), so no bill can be entered for an item that is not in Gadgets.1 mark

   Marks split as in the board’s published marking scheme

3. Q3Short answer4 marksAsked: 2023

   Explain any four data types of DBMS.

4. Q4Short answer4 marksAsked: 2023

   (a) Structure of a table "Orders" is given below. Suggest suitable data type of each column Table : Orders | Order_ID | Order_date | Customer_ID | Amount | | --- | --- | --- | --- | | A_101 | 12/12/19 | C3445 | 1200.00 | | A_202 | 11/09/19 | C1245 | 3456.00 | | A_402 | 09/07/19 | C2121 | 2312.00 | (b) Consider the following table "Books". | BkID | BkName | Author | Qty | Price | | --- | --- | --- | --- | --- | | B_101 | Learning with Fun | Jacobins | 5 | 355.00 | | B_103 | How I Live Now | Meg Rosoff | 4 | 400.00 | | B_104 | I Capture the Castle | Dodie Smith | 5 | 520.00 | | B_106 | Mortal Engines | Philip Reeve | 4 | 260.00 | | B_110 | The Kite Rider | Geraldine McCaughrean | 3 | 270.00 | Write SQL queries to (i) Display data of all books whose quantity is more than 3. (ii) Display total amount of all books whose price is less than 500. (Hint : amount = Qty x Price) For visually impaired candidates. Explain various relationships that can be created between two tables in a database.

   How the model answer begins

   1. (a) Suitable data types for the columns of the table "Orders": Order_ID – Varchar, because values such as A_101 mix letters, digits and the underscore, so they are stored as text. Order_date – Date, because values such…

   The full answer from Medha Ma’am →
5. Q5Long answer4 marksAsked: 2025

   (a) State two advantages of joining two tables in a database. (b) Explain the many-to-many relationship between tables in a database.

   How the model answer begins

   1. (a) Two advantages of relating (joining) two tables in a database are: 1. A relationship can help prevent data redundancy. Because the tables are related, the same data does not have to be stored again in many tables,…

   The full answer from Medha Ma’am →
6. Q6Case-based4 marksAsked: 2025

   Consider the following table : Table : Student | Student_ID | Name | Age | Phone_Number | | --- | --- | --- | --- | | S001 | Amit | 15 | 9876543210 | | S002 | Priya | 16 | 8765432109 | | S003 | Priya | 15 | 7654321098 | Answer the following questions : (a) You are given the task to design the student database for your school in LibreOffice Base. Based on the given table structure, suggest the datatype of student_id and age field that would be suitable to store student's-id and age respectively. (b) As a database administrator, you need to ensure each student has a unique identifier. Which field in the table would you choose as the primary key and why ? (c) Identify the field that can serve as an alternate key. Justify your answer. (d) How many attributes and records are present in the above shown table ?

   How the model answer begins

   1. The datatype suitable for Student_ID would be Number or Text, and the datatype suitable for Age would be Number. Student_ID values like S001, S002, S003 are alphanumeric in nature, so Text datatype can also be used to…

   The full answer from Medha Ma’am →
7. Q7Case-based4 marksAsked: 2024

   Consider the table Product and write SQL queries for the following : Table : Product (a) To display names of all products whose category is "domestic". (b) To display product name and price whose quantity is less than 50. (c) To display price and quantity of Laptop. (d) To display name and quantity of those products whose price is above 5000. For Visually Impaired Candidates : In the context of Database Management System, write a short note on the following : (i) Database (ii) Table (iii) Field (iv) Composite Primary Key

8. Q8Short answer4 marksAsked: 2024

   In context of OpenOffice Base, explain the concept and significance of the following : (a) Forms (b) Reports

   How the model answer begins

   1. (a) Forms: A form is an object of the database that has a user friendly interface. A database form provides the user a systematic and interactive way of storing information into the database. It is an interface in a…

   The full answer from Medha Ma’am →
9. Q9Short answer2 marksAsked: 2026

   How are data and information different from each other ? Explain with an appropriate example.

   How the model answer begins

   1. Data is raw, unprocessed facts and figures that have no clear meaning by themselves.

   The full answer from Medha Ma’am →
10. Q10Very short answer2 marksAsked: 2023

    What is a Primary Key ? How is it different from foreign key ?

    How the model answer begins

    1. A primary key is a field that uniquely identifies a row in a table. No two rows can have the same value for it, and it cannot be left blank. Difference – Primary key: uniquely identifies each record of its own table;…

    The full answer from Medha Ma’am →
11. Q11Short answer2 marksAsked: 2025

    What are the important prerequisites for setting a relationship between two tables in LibreOffice Base ? Mention any two.

    How the model answer begins

    1. (a) The most important prerequisite for setting a relationship between two tables is that there must be a common field (column) between the two tables. The relationship is set using this common field.

    The full answer from Medha Ma’am →
12. Q12Short answer2 marksAsked: 2024

    Give any two benefits of creating relationships between tables in a database.

13. Q13Very short answer1 markAsked: 2023

    ____ is usually suitable for less amount of data. (Relational/Flat file)

    How the model answer begins

    1. Flat file is usually suitable for less amount of data.

    The full answer from Medha Ma’am →

Objective questions with the board’s key (10)

1. 1. CBSE 2026

   In a database, a form is ________.

   • (A) a tool used only for storing data in tables
   • (B) an object with a user-friendly interface for data entry ✓
   • (C) a feature used to write queries
   • (D) a chart to display statistical data

   Answer: (B)

2. 2. CBSE 2026

   Which of the following is an example of a DBMS ?

   • (A) Ubuntu
   • (B) MySQL ✓
   • (C) MS Word
   • (D) Canva

   Answer: (B)

3. 3. CBSE 2026

   While forming a relationship between two tables in LibreOffice Base, the ________ of the common field must be ________.

   • (A) same, data type
   • (B) data type, same ✓
   • (C) data type, different
   • (D) primary key, same

   Answer: (B)

4. 4. CBSE 2026

   Which of the following advantages of DBMS ensures that changes in data are reflected across all tables ?

   • (A) Data Sharing
   • (B) Organised Storage
   • (C) Data Consistency ✓
   • (D) Minimal Data Redundancy

   Answer: (C)

5. 5. CBSE 2026

   Which of the following best explains the use of a query in LibreOffice Base ?

   • (A) To store data in an organized format
   • (B) To retrieve data from the database and display it in the desired format ✓
   • (C) To create tables
   • (D) To design the layout of forms and reports

   Answer: (B)

6. 6. CBSE 2026

   ________ Data Model in which data is stored in the form of linked records, which are arranged in a tree-like structure.

   • (A) Network
   • (B) Relational
   • (C) Fictional
   • (D) Hierarchical ✓

   Answer: (D)

7. 7. CBSE 2025

   __________ is the database software that is used to create, manipulate and manage data.

   • (A) Ingress ✓
   • (B) Writer
   • (C) Paint
   • (D) Windows

   Answer: (A)

8. 8. CBSE 2025

   The process of arranging data in ascending or descending order is known as __________ .

   • (A) Filtering
   • (B) Tracking
   • (C) Purification
   • (D) Sorting ✓

   Answer: (D)

9. 9. CBSE 2025

   With reference to LibreOffice Base, which of the following is a valid data type to indicate the monetary values ?

   • (A) Money
   • (B) Currency ✓
   • (C) Rupee
   • (D) Dollar

   Answer: (B)

10. 10. CBSE 2025

    Data can be retrieved and displayed from one or more tables in a DBMS using a __________ .

    • (A) Referential integrity
    • (B) Domain
    • (C) Query ✓
    • (D) Field

    Answer: (C)

Questions parents and students ask

How many marks does "Database Management System using LibreOffice Base" carry in CBSE Class 10 Information Technology?

In the CBSE papers of 2023–2026, this chapter carried about 11 marks and about 8 questions a year; by marks it ranks 1 in Information Technology.

Which are the most important (VVI) questions of "Database Management System using LibreOffice Base"?

The 13 questions above are from the board’s real papers, each with the years it was asked; the most-asked come first with their full model answers. All 13 written questions of this chapter, with answers, are in the Ask Medha app.

Do the answers follow the board’s marking scheme?

Yes. CBSE publishes its marking schemes; every model answer here is written point by point to the marks the board’s own scheme gives, and checked by a second, independent model.