Introduction to Database Management System Class 10 Board Questions and Answers provides important exam-oriented questions based on the Database Management System chapter of Class 10 Information Technology. It covers key concepts such as databases, tables, fields, records, database management systems, and basic database operations. The answers are written in simple and easy-to-understand language to help students revise effectively for their board examination.
Introduction to Database Management System Class 10 Board Questions and Answers
Answer the given questions in 20 – 30 words each.
Q1. How are data and information different from each other? Explain with an appropriate example.
Answer: Data means raw facts like marks, names, prices. Information is processed data in organized form. For example, marks scored by students is data, but the report card prepared from those marks is information.
Q2. What are the important prerequisites for setting a relationship between two tables in LibreOffice Base? Mention any two.
Answer:
- Both tables must have a common field.
- The data type of the common field must be the same in both tables.
Q3. Give any two benefits of creating relationships between tables in a database.
Answer:
- Reduces data redundancy.
- Ensures data consistency across tables.
Q4. What is Primary Key? How is it different from Foreign Key?
Answer: A Primary Key is a field that uniquely identifies each record in a table. A Foreign Key is a field in one table that refers to the Primary Key of another table to create a relationship.
Q5. List two important features of the Network Data Model in a Database.
Answer: Multiple records are linked to the same master file. It is represented like an inverted tree where the master is at the bottom and branches contain linked information.
Q6. Differentiate between One‑to‑Many and Many‑to‑Many relationships in a database.
Answer:
- One‑to‑Many → One record in a table is related to many records in another table.
- Many‑to‑Many → Many records in one table are related to many records in another table.
Q7. Explain any four data types of DBMS.
Answer:
- Text → Stores letters, numbers, special characters (e.g., names, PAN number).
- Numeric → Stores numbers for calculations (e.g., marks, age).
- Date/Time → Stores dates and time (e.g., 12/05/2024, 08:45 AM).
- Boolean → Stores only True/False or Yes/No values.
Q8. Explain various relationships that can be created between two tables in a database.
Answer:
- One‑to‑One → One record in a table relates to one record in another.
- One‑to‑Many → One record in a table relates to many records in another.
- Many‑to‑Many → Many records in one table relate to many records in another.
Q9. What is the difference between Form and Reports in a database?
Answer:
- Form → Used for easy and user‑friendly data entry into tables.
- Report → Used to present retrieved data in a formatted and understandable manner.
Q1. Explain “one to many” relationship to relate two tables in a database. Support your answer with an example.
Answer: A one‑to‑many relationship means one record in a table is related to many records in another table. Example: In a Student table, one student can borrow many books. So the Student table (with Roll Number as Primary Key) is linked to the Library table (with Roll Number as Foreign Key).
Q2. In a database, why is it important to create relationships between the tables?
Answer: Relationships are important because they:
- Reduce data redundancy.
- Ensure data consistency across tables.
Q3. Ravinder wants to create a table in DBMS that stores details of cricket players. Name any four columns along with their data types.
Answer:
- Player_ID → Text (Primary Key)
- Player_Name → Text
- Age → Numeric
- Runs_Scored → Numeric
Q4. Explain the term “Referential Integrity”. Why is it important in a database?
Answer: Referential Integrity means maintaining consistency between related tables using Primary Key and Foreign Key. It ensures that data in one table matches correctly with data in another table, avoiding errors or mismatches.
Q5. Write a short note on the following:
i) DBMS → Database Management System is software used to create, update, and retrieve data. Examples: MySQL, Oracle, LibreOffice Base.
ii) Database Server → A computer system that provides database services and allows multiple users to access data.
iii) Data Integrity → Ensures accuracy and consistency of data in the database.
iv) Record → A record is a row in a table that contains data values for all fields related to one person or object.
Q6. List Numeric and Alphanumeric Data types in OpenOffice Base.
Answer:
- Numeric Data Types → Integer, SmallInt, BigInt, Decimal, Float, Real, Double.
- Alphanumeric Data Types → Text (CHAR), Text (VARCHAR), Memo (LONGVARCHAR).
Answer the given questions in 50 – 80 words each.
Q1. With reference to DBMS, answer the following questions:
(a) What is the purpose of using reports in DBMS?
Answer: Reports are used to present retrieved data in a user‑friendly, formatted, and understandable manner.
(b) Can we generate a report from multiple tables in a database?
Answer: Yes, reports can be generated from multiple tables if relationships are set between them.
(c) What is a dynamic report?
Answer: A dynamic report is one that updates automatically whenever the data in the database changes.
(d) In LibreOffice Base, to insert the current date and time in a report.
Answer: In LibreOffice Base, to insert the current date and time in a report, the steps are:
- Step 1: Click inside the Page Header area to activate it.
- Step 2: Click Insert → Date and Time.
Q2. An electronic gadget shop keeps records in Gadgets and Bill tables.
(a) Name any two columns of the Gadgets table where duplicate values are allowed.
Answer: ItemType and Supplier can have duplicate values.
(b) Assume Gadgets already contains ItemID = I001. Can we enter a new record with ItemID = I001? Justify.
Answer: No, because ItemID is the Primary Key, and primary keys must be unique.
(c) Is it possible to store photos of the products in a new column of the Gadgets table? If yes, suggest a suitable data type.
Answer: Yes, photos can be stored using the Binary data type.
(d) Briefly explain the principle of referential integrity with respect to Gadgets and Bill tables.
Answer: Referential Integrity ensures that the ItemID in the Bill table must exist in the Gadgets table. This avoids invalid or mismatched entries.
Q3. Define the following:
(a) Relational Database Management System (RDBMS) → A DBMS based on the relational model where data is stored in tables and relationships are set using common fields.
(b) Composite Key → A key formed by combining two or more fields to uniquely identify a record.
(c) Field → The smallest unit of data in a table, represented as a column (e.g., Name, Age).
Q. Define the following:
a. Data Consistency
Answer: It means that data remains the same and correct across all tables. For example, if a student’s name is updated in one table, it should also update in all related tables.
b. Data Redundancy
Answer: It means repetition of the same data in multiple tables. For example, storing the same student’s phone number in both Admission and Library tables.
Q. Consider the following table :
Table : Student
| Student_ID | Name | Age | Phone_Number |
|---|---|---|---|
| S001 | Amit | 15 | 9876543210 |
| S002 | Priya | 16 | 876543210 |
| 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.
Answer:
- Student_ID → Text (VARCHAR)
- Age → Numeric (INTEGER)
(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 ?
Answer: Student_ID should be the primary key because it uniquely identifies each student.
(c) Identify the field that can serve as an alternate key. Justify your answer.
Answer: Phone_Number can be an alternate key because each student has a unique phone number.
(d) How many attributes and records are present in the above shown table ?
Answer:
- Attributes (columns) → 4 (Student_ID, Name, Age, Phone_Number)
- Records (rows) → 3
Q. In context of OpenOffice Base, explain the concept and significance of the following :
(a) Forms
Answer: Forms are user‑friendly screens used to enter data into tables. They contain text boxes, labels, and buttons, making data entry easier.
(b) Reports
Answer: Reports are used to present retrieved data in a formatted and understandable way. They help in preparing output like marksheets, invoices, or summaries.
Q. In the context of Database Management System, write a short note on the following:
- (i) Database → A database is a collection of logically related data items stored in an organised manner. Data can be added, modified, deleted, or displayed as per user requirements.
- (ii) Table → A table is a collection of logically related records arranged in rows and columns. Each column represents a field, and each row represents a record.
- (iii) Field → A field is the smallest unit of data in a table. It represents one attribute of an entity, such as Name or Age.
- (iv) Composite Primary Key → When more than one field is combined to uniquely identify a record in a table, it is called a composite primary key.
Q. Sheena wants to maintain the details of her boutique’s customers in LibreOffice Base.
(a) What is the full form of DBMS?
Answer: DBMS stands for Database Management System.
(b) Why should she choose a database to maintain the details? Mention any two points.
Answer:
- It reduces data redundancy and inconsistency.
- It allows fast and accurate retrieval of customer details.
(c) What is the difference between Char and Varchar datatypes in LibreOffice Base?
Answer:
- Char (Text Fix) → Stores a fixed number of characters. Example: Passport number.
- Varchar (Text Variable) → Stores variable length characters up to a specified limit. Example: Address.
(d) She wants to enter data into a table in an easy and user‑friendly manner using a Form object. Mention any two control names that can be used with it.
Answer:
- Text Box
- List Box
Q. Consider the table CUSTOMERS given below and answer the questions that follow :
Table Name: CUSTOMERS
| CustomerID | CustomerName | City | ContactNumber |
|---|---|---|---|
| 111 | Amita | Delhi | 122334455 |
| 222 | Rehana | Chennai | 5432112345 |
| 333 | Shailja | Delhi | 1212334344 |
(a) What is an entity? Name the entity shown above.
Answer: An entity is a real‑world object about which information is stored in a database. The entity shown above is Customer.
(b) How many data values are present in the above shown table, CUSTOMER?
Answer: The table has 4 attributes (columns) and 3 records (rows). So, total data values = 4 × 3 = 12.
(c) List two different ways of creating the CUSTOMER table in LibreOffice Base.
Answer:
- By using Table Design View.
- By using Table Wizard.
(d) A new column, bill_datetime, needs to be added to the table shown above to store the billing date and time in a single field. Suggest a suitable datatype and provide justification for your choice.
Answer: The suitable datatype is Timestamp, because it can store both date and time together in one field.
Q. While working with multiple tables, you need to set up relationships between the tables of a database.
(a) What is the most important prerequisite for setting a relationship between the two tables?
Answer: The most important prerequisite is that both tables must have a common field with the same data type.
(b) How many types of relationships can be created between two tables? Name any two.
Answer: Three types of relationships can be created:
- One‑to‑One
- One‑to‑Many
- Many‑to‑Many
(c) While setting up relationship between two tables in LibreOffice Base, what will happen if the data type of common field in both tables is not same?
Answer: If the data type of the common field is not the same, then the relationship cannot be created because the fields will not match correctly.
Q. Consider the table BOOKS given below and answer the questions that follow :
| BID | Name | DOP | Type | Price |
|---|---|---|---|---|
| 2001 | God’s Gift | 2019-05-19 | Inspire | 450.00 |
| 4003 | Millionaire | 2017-12-21 | Inspire | 340.00 |
| 3024 | The Chair | 2020-02-25 | Horror | 320.00 |
| 2082 | Morning Tea | 2017-11-20 | Mystery | 310.00 |
| 1502 | Nightingale | 2021-06-15 | Biography | 270.00 |
| 1300 | The Truth | 2020-08-18 | Mystery | 510.00 |
BID Book Identification, DOP Date of Purchase :
(a) Identify and name the candidate keys from the above table.
Answer: Candidate keys are those fields that can uniquely identify each record. In the BOOKS table, BID (Book Identification) is the candidate key.
(b) Identify and write the attribute which is best suitable to be declared as a primary key.
Answer: The attribute BID should be declared as the Primary Key because it uniquely identifies each book record.
(c) Suggest an appropriate data type of the field “Price”. Justify your answer.
Answer: The suitable data type is Decimal/Number because price values are numeric and may include decimal points (e.g., 450.00).
(d) Explain in short BOOLEAN Datatype.
Answer: The Boolean datatype stores only two values: True/False or Yes/No. It is used for fields where only two possible states are required, such as “Available/Not Available”.
Q. Consider the table given below and answer the questions that follow:
| Student Name | Roll Number | Class | Marks |
|---|---|---|---|
| Aryan Sharma | 101 | 10A | 450 |
| Priya Singh | 102 | 10B | 470 |
| Rohan Mehta | 103 | 10A | 480 |
| Ananya Kapoor | 104 | 10C | 460 |
(a) Name all the fields in the given table.
Answer: Student Name, Roll Number, Class, Marks.
(b) Which field should be made the primary key?
Answer: Roll Number should be the primary key because it uniquely identifies each student.
(c) Suggest a possible alternate key, if any.
Answer: Student Name can be an alternate key, but only if names are unique. Otherwise, Roll Number remains the best unique identifier.
(d) Explain how a primary key differs from a foreign key with an example.
Answer:
- Primary Key → A field that uniquely identifies each record in a table. Example: Roll Number in the Student table.
- Foreign Key → A field in one table that refers to the primary key of another table to create a relationship. Example: Roll Number in a Library table can act as a foreign key referring to Roll Number in the Student table.
Q1. Ruhi is managing a Sports Day database in LibreOffice Base.
(a) What is referential integrity? Give an example from Ruhi’s database.
Answer: Referential Integrity means maintaining consistency between related tables using Primary Key and Foreign Key. Example: If CategoryID in EventCategory is linked to Events table, then every CategoryID in Events must exist in EventCategory.
(b) Ruhi wants to stop deletion of any category that is being used in the Events table. Which option should she use?
Answer: She should use the No Action option.
(c) If a CategoryID is changed in EventCategory, how does the Update Cascade option affect the Events table? Give an example.
Answer: Update Cascade automatically updates the related field in Events table.
Example: If CategoryID “C01” is changed to “C001” in EventCategory, then all “C01” entries in Events will also change to “C001”.
(d) If the Set NULL option is used and a master record is deleted, what happens in the Events table? How is it different from Set Default?
Answer:
- Set NULL → The related field in Events becomes empty (NULL).
- Set Default → The related field in Events takes a predefined default value.
Q2. A health clinic is developing a patient management system.
(a) What is the use of form in DBMS?
Answer: Forms are used for easy and user‑friendly data entry into tables.
(b) What are the different ways to create forms in DBMS?
Answer:
- Using Form Wizard
- Using Design View
(c) Where can we find various tools to add or edit controls on the form?
Answer: Tools are available in the Form Controls Toolbar.
(d) What is the use of the Records Toolbar in a form?
Answer: The Records Toolbar helps to navigate, add, delete, or update records in a form.
Q3. Your cousin runs a bookstore and wants to maintain inventory.
(a) What is DBMS?
Answer: DBMS stands for Database Management System, software used to create, update, and retrieve data.
(b) What are the advantages of using DBMS?
Answer:
- Reduces data redundancy and inconsistency.
- Ensures fast and accurate retrieval of data.
(c) Name any two database programs.
Answer: MySQL and LibreOffice Base.
(d) Which field can be set as a Primary Key?
Answer: ISBN can be set as the Primary Key because it uniquely identifies each book.
Q4. Your friend owns a chemist shop and wants to keep records of medicines.
(a) What is DBMS? Explain in brief.
Answer: DBMS is software that stores data in an organised manner, reduces redundancy, ensures consistency, and allows easy retrieval.
(b) Name any two database programs.
Answer: Oracle and LibreOffice Base.
(c) Which field can be set as a Primary Key?
Answer: Medicine_ID can be set as the Primary Key because it uniquely identifies each medicine.
(d) Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.
Answer: Yes. When two or more fields are combined to uniquely identify a record, it is called a Composite Primary Key.
Disclaimer: The content that is present on our website is based on the NCERT Class 10 Information Technology textbook and is provided for educational purposes only. All the content and images have been taken from Information Technology Class 10 NCERT Textbook. Images and content shown above are the property of individual organizations and are used here for reference purposes only. To make it easy to understand, some of the content and images are generated by AI and cross-checked by the teachers.
For more information, refer to the official CBSE textbooks available at cbseacademic.nic.in