CBSE Class 10 Information Technology
Chapter 3: Database Management System (DBMS)
20 Important Questions and Answers
Q1. What is a Database? Explain with an example.
Answer:
A database is an organized collection of related data stored in a structured manner so that it can be easily accessed, managed, and updated. It helps in storing large amounts of information efficiently. For example, a school’s database may contain details of students such as admission number, name, class, section, and marks. Instead of maintaining separate files for each student, all information is stored in one centralized system. Databases reduce duplication of data and improve data accuracy. They are widely used in schools, hospitals, banks, libraries, and businesses for efficient record management and retrieval of information.
Q2. What is DBMS? Mention any four advantages of DBMS.
Answer:
DBMS (Database Management System) is software that enables users to create, manage, store, retrieve, and update data in a database. It acts as an interface between users and the database. Examples include LibreOffice Base, MySQL, and MS Access. The major advantages of DBMS are: (1) Reduction of data redundancy, (2) Improved data security, (3) Easy data retrieval and updating, and (4) Better data consistency. DBMS also supports multiple users working on the same database simultaneously. It helps organizations maintain large volumes of data efficiently and ensures that information remains accurate and accessible whenever needed.
Q3. Differentiate between Data and Information.
Answer:
Data refers to raw facts and figures that do not have a meaningful context. Examples include numbers, names, dates, or marks. Information is processed and organized data that becomes meaningful and useful for decision-making. For example, the marks obtained by students in different subjects are data. When these marks are analyzed to determine the percentage and rank of a student, they become information. Data serves as the input for a system, whereas information is the output generated after processing. Databases store data, and DBMS helps convert this data into useful information through queries, reports, and analysis.
Q4. What is a Table in a Database?
Answer:
A table is the basic building block of a relational database where data is stored in rows and columns. Each table contains information about a specific entity such as students, employees, or products. Columns represent fields or attributes, while rows represent records. For example, a Student table may contain fields like Student_ID, Name, Class, and Marks. Each row contains the complete information of one student. Tables help organize data systematically and make it easy to search, update, and retrieve information. Multiple tables can be linked together in a relational database using keys and relationships.
Q5. What is the difference between a Field and a Record?
Answer:
A field is a single piece of information about an entity and corresponds to a column in a database table. Examples include Name, Roll Number, and Age. A record is a collection of related fields that describes one complete entity and corresponds to a row in a table. For example, in a Student table, the field “Name” stores student names, whereas a complete row containing Roll Number, Name, Class, and Marks represents a record. Fields define the type of data stored, while records store the actual information about an individual item or person.
Q6. What is a Relational Database?
Answer:
A relational database is a type of database in which data is stored in multiple tables that are related through common fields. These relationships help avoid duplication of data and improve efficiency. For example, a school database may have separate Student and Fee tables connected through Student_ID. Relational databases allow users to retrieve information from multiple tables using relationships. They are easy to manage and support data consistency. Examples of Relational Database Management Systems (RDBMS) include MySQL, Oracle, LibreOffice Base, and Microsoft Access. Most modern database applications use the relational model because of its flexibility and reliability.
Q7. What is RDBMS? How is it different from DBMS?
Answer:
RDBMS stands for Relational Database Management System. It is an advanced form of DBMS that stores data in related tables. While DBMS can manage data in a single table or file, RDBMS supports relationships among multiple tables. RDBMS reduces data redundancy and improves data integrity through keys and constraints. Examples include MySQL, Oracle, and MS Access. DBMS is suitable for small applications, whereas RDBMS is preferred for large and complex databases. RDBMS also supports advanced features such as normalization, relationships, and multi-user access, making it more efficient than traditional DBMS systems.
Q8. What is a Primary Key? Why is it important?
Answer:
A primary key is a field or combination of fields that uniquely identifies each record in a table. No two records can have the same primary key value, and it cannot contain null values. For example, Student_ID can be used as the primary key in a Student table because each student has a unique ID. The primary key helps prevent duplicate records and ensures data integrity. It also establishes relationships between tables in a relational database. A well-chosen primary key improves database performance and makes data retrieval faster and more accurate.
Q9. What are Database Objects?
Answer:
Database objects are components used to store, manage, and retrieve data in a database. The main database objects are Tables, Queries, Forms, and Reports. Tables store data in rows and columns. Queries are used to retrieve specific information from tables based on conditions. Forms provide a user-friendly interface for entering and editing data. Reports are used to present data in a formatted and printable form. These objects work together to make database management easier and more efficient. Understanding database objects is essential for creating and maintaining a functional database system.
Q10. What is a Query? Explain its importance.
Answer:
A query is a request used to retrieve specific information from a database. It allows users to search, filter, sort, and analyze data according to their requirements. For example, a query can display all students who scored more than 80 marks. Queries help users access only the required information without viewing the entire database. They improve efficiency and save time when dealing with large amounts of data. Queries can also be used to update, delete, or modify records. In database management, queries play a vital role in transforming stored data into meaningful information. (CBSE Tuts)
Q11. What is a Form in a Database?
Answer:
A form is a database object that provides a user-friendly interface for entering, editing, and viewing data. Instead of directly working with tables, users interact with forms to manage records easily. Forms reduce the chances of errors and improve data entry efficiency. For example, a student admission form may contain fields such as Name, Class, and Date of Birth. Users fill in the details, and the data is automatically stored in the corresponding table. Forms are especially useful when multiple users need to enter data without understanding the underlying database structure.
Q12. What is a Report in a Database?
Answer:
A report is a database object used to display and print data in a structured and formatted manner. Reports help summarize information and present it professionally. For example, a school can generate a report showing student attendance, examination results, or fee details. Reports can include headings, totals, charts, and formatting options to make information easier to understand. They are often used for analysis and decision-making purposes. Unlike tables, which store raw data, reports provide a clear and organized presentation of information for users and management.
Q13. Explain Data Redundancy.
Answer:
Data redundancy refers to the unnecessary duplication of data in a database. When the same information is stored in multiple places, it increases storage requirements and may lead to inconsistencies. For example, if a student’s address is stored repeatedly in different files, updating one copy but not the others can create errors. A DBMS minimizes data redundancy by storing information in a centralized and organized manner. Reduced redundancy improves data consistency, saves storage space, and enhances database performance. One of the main advantages of relational databases is their ability to control and reduce redundant data effectively.
Q14. Explain Data Security in DBMS.
Answer:
Data security refers to protecting data from unauthorized access, modification, or deletion. A DBMS provides security features such as passwords, user authentication, and access control. These measures ensure that only authorized users can view or modify specific information. For example, a school database may allow teachers to enter marks but restrict students from editing records. Data security helps maintain confidentiality, integrity, and availability of information. It also protects sensitive data from accidental loss or cyber threats. Therefore, security is one of the most important benefits of using a DBMS.
Q15. What are the common Data Types used in a Database?
Answer:
Data types define the kind of values that can be stored in a database field. Common data types include Integer, Text, Float, and Date/Time. Integer stores whole numbers, while Float stores decimal values. Text is used for names, addresses, and other alphanumeric information. Date/Time stores dates and times in a standard format. Choosing the correct data type helps maintain accuracy and efficient storage of data. It also prevents users from entering invalid information. Proper use of data types improves database performance and ensures consistency across records.
Q16. What is the role of a Database Administrator (DBA)?
Answer:
A Database Administrator (DBA) is responsible for managing and maintaining a database system. The DBA ensures data security, backup, recovery, and efficient performance of the database. They define user permissions, monitor database operations, and resolve technical issues. A DBA also maintains data integrity and ensures that information is available whenever required. In large organizations, the DBA plays a critical role in managing huge volumes of data and protecting it from unauthorized access. Their work ensures smooth functioning of database applications and reliable access to information.
Q17. Why is a Database better than a Manual Record System?
Answer:
A database is more efficient than a manual record system because it provides faster storage, retrieval, and updating of information. Manual systems require physical files and consume more time for searching records. Databases reduce paperwork, save storage space, and minimize human errors. They also support multiple users accessing data simultaneously. Security features protect information from unauthorized access, and backup facilities help prevent data loss. Databases improve accuracy, consistency, and reliability of records. Therefore, organizations prefer computerized database systems over traditional manual record-keeping methods for managing large amounts of information.
Q18. Explain the concept of a Composite Primary Key.
Answer:
A composite primary key is a primary key that consists of two or more fields combined together to uniquely identify a record. It is used when a single field cannot uniquely identify records. For example, in a Student_Course table, the combination of Student_ID and Course_ID can serve as a composite primary key. Together, these fields ensure uniqueness. Composite keys help maintain data integrity and establish relationships between tables. They are commonly used in relational databases where many-to-many relationships exist. A composite key ensures that duplicate records are not entered into the database.
Q19. What are the features of a Database?
Answer:
A database has several important features. It stores data in an organized manner using tables, fields, and records. It supports easy retrieval, updating, and deletion of data. Databases reduce redundancy and improve consistency. They provide security mechanisms to protect information from unauthorized access. Multiple users can access the database simultaneously without conflicts. Databases also support backup and recovery features to prevent data loss. Additionally, they help maintain relationships between different sets of data. These features make databases reliable, efficient, and suitable for managing large amounts of information in organizations.
Q20. Explain the working of a Database Management System.
Answer:
A Database Management System works as an interface between users and the database. Users enter data through forms or applications, and the DBMS stores it in tables. When information is required, users submit queries, and the DBMS retrieves the relevant data from the database. It manages data storage, updates, security, and access control. The DBMS also ensures consistency and prevents duplication of records. Multiple users can access the same database simultaneously without affecting its integrity. Through its various tools and features, a DBMS simplifies data management and improves efficiency in organizations.