RBSE Solutions Class 12 Accountancy Chapter 15 Database Management System

Rbse Class 12 Accountancy Chapter 15 Textbook Questions

Rbse Class 12 Accountancy Chapter 15 Multiple Choice Questions

Question 1. Data is:
(a) Information
(b) Collection of facts
(c) (a) and (b) both
(d) None of the options
Answer: (b) Collection of facts
In simple words: Data refers to raw, unprocessed facts, like numbers or words, that haven't been organized or given meaning yet. It's the basic information we collect.

🎯 Exam Tip: Remember that data are raw facts, while information is processed data. This distinction is fundamental in database concepts.

Question 3. The result of processed information is :
(a) Input
(b) output
(c) both
(d) None of the options
Answer: (b) output
In simple words: When you take raw data and do something with it, like organizing or calculating, the final result you get is called output. This output is what we use as information.

🎯 Exam Tip: Understand the difference: input is raw data, processing turns it into output, which is useful information. The output is the meaningful result.

Question 4. The method to prepare a quarry is :
(a) SQL method
(b) JHL method
(c) RST method
(d) DBH method
Answer: (a) SQL method
In simple words: To ask questions or fetch specific information from a database, people use a special method called SQL. This helps them get the data they need.

🎯 Exam Tip: SQL stands for Structured Query Language, a standard for managing relational databases and extracting data.

Question 5. Full Name of DBMS is :
(a) Database mark up system
(b) Database management system
(c) Database management section
(d) None of the options
Answer: (b) Database management system
In simple words: DBMS is a short way to say Database Management System. This is a computer program that helps you store, organize, and use large amounts of information.

🎯 Exam Tip: Knowing the full forms of common technical terms is crucial for quick recall in exams related to database management.

Rbse Class 12 Accountancy Chapter 15 Very Short Answer Questions

Question 1. Explain data processing cycle with the reference of accounting.
Answer: In accounting, the data processing cycle involves several steps to transform raw data into meaningful information for decision-making. These steps include collecting, sorting, relating, interpreting, and computing data items. The necessary stages in this cycle are data capturing, inputting, processing, and finally generating useful information that is available to the user. This systematic approach ensures accurate financial reporting and analysis.
In simple words: The data processing cycle in accounting takes raw financial numbers, sorts them, and turns them into useful reports. This helps people make smart business choices by providing clear information.

🎯 Exam Tip: Highlight the sequential steps of the data processing cycle, connecting each to its role in transforming raw data into useful accounting information.

Question 2. Give the meaning of accounting database.
Answer: An accounting database is a structured collection of data, specifically designed for managing financial information related to a particular business. It organizes information in a way that allows for easy access, efficient management, and timely updates. This system helps keep all financial records, like transactions and accounts, in one secure and organized place.
In simple words: An accounting database is like a digital filing cabinet that stores all the money-related information for a business. It keeps everything organized so it's easy to find and change when needed.

🎯 Exam Tip: Emphasize that an accounting database is a collection of *financial* data, stored in an *organized* way for easy *access* and *management*.

Question 3. Explain database management system?
Answer: A Database Management System (DBMS) is essential software that manages all useful and important information for a business in one central place. This data can include files on salaries, sales, purchases, and accounts. DBMS helps convert raw data into meaningful information, allowing businesses to easily arrange data and perform calculations to understand total sales, average sales, or profit percentages. DBMS simplifies the handling of large amounts of information, turning it into actionable knowledge. This system provides a structured way to interact with the data.
In simple words: A DBMS is a computer program that helps a business store, organize, and use all its information in one place. It turns raw numbers into useful reports, like total sales for the month.

🎯 Exam Tip: Define DBMS as software, explaining its function of centralizing, organizing, and converting data into useful information for business decisions.

Question 4. Explain Attributes with an example.
Answer: Attributes are characteristics or properties that further describe an entity. For example, for a person, attributes might include height, weight, and date of birth. For accounts, attributes could be a code or a name. An entity has a specific value for each of its attributes, which is the actual data stored in the database. Attributes are crucial for detailing information within the database. Attributes can be of several types:
• Composite Vs. Simple attributes
• Single valued Vs. Multi valued
• Store Vs. Derived attributes
• Null values (for absence of data)
• Complex attributes
• Entity types of entity sets
• Value sets of attributes.
Example of Entity Attributes: Customer Name, Address, Customer No; Book ISBN, Author, Price; Student Name, Address, Roll No.
In simple words: Attributes are like the different features of something. For a person, their height or birthday are attributes. They help describe what an item or person is like in the database. There are different kinds of attributes too, like simple ones or ones made of many parts.

🎯 Exam Tip: Remember to explain what attributes are and list a few examples. Briefly mentioning different types of attributes can add depth to your answer.

Question 5. Explain Entity relationship model ?
Answer: The Entity-Relationship (ER) model is a conceptual data model used to describe the structure of a database. It is based on the idea that a real-world system consists of basic entities and relationships between these entities. An entity is a particular person, place, or thing, and its values are defined by its attributes. For instance, in a hospital database, a 'patient' is an entity, with attributes like name, date of birth, and date of hospitalization. The ER model visually represents entities as rectangles, attributes as ovals, and relationships as diamonds. This model helps design how different pieces of information connect.
In simple words: The ER model is a way to plan a database using simple drawings. It shows what important things (entities) exist, what information they have (attributes), and how these things are linked (relationships). Think of it like a blueprint for your data.

🎯 Exam Tip: When explaining the ER model, clearly define entities, attributes, and relationships, and ideally draw a simple diagram to illustrate these components.

Question 6. What do you understand by database? Compare, it with an old file handling system.
Answer: A database is a structured collection of related information. It allows for efficient storage, retrieval, and management of data. For example, a school's database could store all student marks, enabling calculations for ranks or identifying failing students. A database simplifies data access and ensures consistency.
Comparison with old file handling system:

🎯 Exam Tip: Define a database and then use a two-column table to clearly contrast its features with those of an old file handling system, focusing on advantages like structure and consistency.

Rbse Class 12 Accountancy Chapter 15 Short Answer Questions

Question 1. What is data?
Answer: Data is a fundamental component of any activity, representing raw facts or figures. It can be numeric, textual, pictorial, or even vocal. Data forms the basis for generating information. When collected and analyzed, data yields meaningful insights. Modern information technology handles many different types of data, including text, voice, and pictures. Data is simply the raw material waiting to be processed.
In simple words: Data means raw facts or numbers. It's the basic stuff we use to make sense of things. Data can be words, numbers, pictures, or sounds.

🎯 Exam Tip: Define data as raw facts and mention its various forms (numeric, text, audio, visual) to show a comprehensive understanding.

Question 2. What do you understand by data processing?
Answer: Data processing generally involves the collection and manipulation of raw data to produce meaningful information. It can be seen as a specific part of broader information processing, where any detectable change in information by an observer is considered processing. This transformation makes raw data useful for analysis and decision-making, converting disorganized facts into valuable insights.
In simple words: Data processing means taking raw facts and working on them to turn them into useful information. It's like cooking ingredients to make a meal that everyone can understand and use.

🎯 Exam Tip: Focus on the transformation aspect: data processing takes raw data and converts it into valuable, understandable information.

Question 3. What do you mean by Structured Query Language (SQL)?
Answer: Structured Query Language (SQL) is a powerful language primarily used for writing queries to manage and retrieve data from relational databases. It was first defined by D.D. Chamberlain in 1974 and has undergone many updates to become an official ANSI standard today. SQL is widely used in various database management systems across many platforms. It acts as a universal tool for database interaction, allowing users to create, modify, and access databases easily.
In simple words: SQL is a special computer language used to talk to databases. It helps you ask questions to the database and get back the information you need, like finding all students who scored above 90%.

🎯 Exam Tip: Mention that SQL is a standard language for relational databases, used for querying and managing data. Highlighting its widespread use is also good.

Question 4. What do you understand by ER Model?
Answer: The Entity-Relationship (ER) Model is a high-level conceptual data model that describes data as entities and relationships. It uses a graphical representation to illustrate the logical structure of a database, showing how different data components are interconnected. The ER model helps designers visualize and define the relationships between various pieces of information within a system. This blueprint aids in organizing data effectively and serves as a communication tool among database designers.
In simple words: The ER Model is like a map for a database. It shows all the important things (entities) and how they are linked together. It helps us see the big picture of how information will be stored and used.

🎯 Exam Tip: Explain the ER model as a conceptual tool for database design, emphasizing its use of entities, relationships, and attributes to map real-world concepts into a database structure.

Question 5. What do you understand by relationship?
Answer: In a relational database, a relationship defines the connections or 'bonds' between different entities. It explains how one entity is linked to another. For example, vouchers and accounts are related in two ways: a voucher can contain debit accounts and also credit accounts. Relationships are crucial because they ensure that related data is properly connected and consistent across the database. They tell us how different parts of our data interact, making the database intelligent.
This model illustrates how different elements like Code, Name, Type can describe an Account, and how Voucher Number, Debit, Credit, Authorised by, Prepared by, and Narration are linked to an Account, showing the intricate connections within a database system.
Types of Relationship: There are three main types of relationships that describe how entities interact:
1. One-to-one relationship (1:1): This means one record in a table is related to only one record in another table.
2. One-to-many relationship (1:M): This is where one record in a table can be related to many records in another table.
3. Many-to-many relationship (M:M): This indicates that many records in one table can be related to many records in another table.
In simple words: A relationship in a database shows how different pieces of information, called entities, are connected to each other. For example, a 'customer' entity might be linked to an 'order' entity. This helps the database know which customer placed which order. There are different kinds, like one-to-one, one-to-many, and many-to-many.

🎯 Exam Tip: Define relationships in the context of relational databases, explain their purpose in connecting entities, and illustrate with different types (one-to-one, one-to-many, many-to-many) using simple examples or diagrams.

Question 6. What is the meaning of information?
Answer: Information is the result of processing raw data, making it meaningful and useful for decision-making. If the initial processing doesn't yield clear results for a decision, the process continues until actionable insights are obtained. This transformation of data into information is vital for understanding and making informed choices, helping individuals and organizations make better plans and actions.
In simple words: Information is what you get after you've worked with raw facts (data) and made them make sense. It's the useful knowledge that helps you decide things.

🎯 Exam Tip: Distinguish information from data by emphasizing that information is *processed* and *meaningful* data, used specifically for *decision-making*.

Question 1. Explain the main elements used in designing database.
Answer: Designing a database, whether computerized or not, requires a clear structure for storing accounting data. The process begins by understanding the "Reality" or the real-world accounting situation that needs to be fully described.
1. Reality: This refers to the actual real-world scenario for which a database is being designed, such as the accounting reality of a business. It captures what needs to be modeled.
2. ER Design: This involves creating a formal blueprint using a pictorial Entity-Relationship (ER) model. It represents the description of this reality using ER model concepts. This visual model helps in understanding the relationships.
3. Relational Data Model: Here, the ER design is converted into interconnected data tables. This step includes defining rules to ensure the consistency and integrity of the stored data. It creates the actual table structure.
4. Normalization: This is a refining process for the database design, aimed at reducing or eliminating duplicate or redundant data items within the interrelated tables. It makes the database efficient.
5. Refinement: This is the final stage, achieved after normalization, where the database design is finalized to ensure efficiency and accuracy. Each element builds upon the previous one to create a robust and well-structured database.
In simple words: Designing a database involves several key steps. First, you understand the real-world need, then you draw a map (ER Design), turn that map into tables (Relational Data Model), clean up the tables to remove repeats (Normalization), and finally, make sure everything is perfect (Refinement). Each step helps make the database strong.

🎯 Exam Tip: List and briefly explain each main element of database design (Reality, ER Design, Relational Data Model, Normalization, Refinement) in a sequential manner.

Question 2. Write advantages and objectives of database management system.
Answer: Database Management Systems (DBMS) offer significant advantages and objectives for efficient data handling.
Advantages:
1. Minimized Data Redundancy: DBMS reduces the storage of duplicate data, which makes updating information easier and less prone to errors.
2. Processing & Storage Efficiency: It saves effort and storage space by centralizing data, making the system more streamlined.
3. Centralized Data Access: Data is pooled for various applications, allowing easy access from one central source for all users.
4. Improved Management: DBMS makes data management much more efficient and effective, helping businesses keep track of their information better.
5. Better Access: It provides improved and well-managed access to data, ensuring that the right people can find the right information quickly.
6. Quick Query Answering: The system speeds up the process of answering data-related questions and queries.
7. Report Preparation: DBMS assists in preparing various reports easily and automatically, saving time and effort.
8. Reduced Program Needs: Fewer programs are often needed since each application can access the entire database, simplifying development.
9. Data Security & Integrity: It helps ensure the security and consistency (integrity) of the data, protecting it from unauthorized access and errors.
Objectives:
1. Flexibility in Information System: DBMS greatly increases the flexibility of information systems by allowing users to make specific, ad-hoc queries on large amounts of information.
2. Multi-user Access: Data stored for one primary purpose can be easily accessed and utilized by multiple users for various other needs as they arise.
DBMS helps overcome the problems and limitations of traditional data management systems by providing these benefits.
In simple words: DBMS is good because it stops us from saving the same information many times, makes finding data faster, and keeps all data safe in one place. Its main goals are to make our data system flexible and let many people use the same data for different things easily.

🎯 Exam Tip: Categorize your answer into 'Advantages' and 'Objectives' for clarity. List specific benefits like reduced redundancy and improved security, and objectives like flexibility and multi-user access.