CBSE Class 11 Accountancy: NCERT Solutions for Chapter 7 - Structuring Database for Accounting

Solution: The main categories of data models are:

1. Relational Data Model: This model organizes data into tables consisting of rows (tuples) and columns (attributes). It was introduced by Ted Codd in 1970 and is fundamental for storing and retrieving data based on relationships.
2. Hierarchical Data Model: This model organizes data in a tree-like structure with parent-child relationships between records. Data is represented by records and relationships are shown by links.
3. Network Data Model: Also known as the DBTG model, this model organizes data into records and sets, where sets define relationships between record types. It allows for many-to-many relationships.

These models, particularly the hierarchical and network models, are sometimes referred to as legacy models due to their long-standing use.

Solution: Computers are highly useful in processing accounting data due to several key advantages:

• Efficiency and Speed: Computers can process vast amounts of data much faster than manual methods.
• Accuracy and Precision: They perform calculations and data handling with a high degree of accuracy, minimizing human error.
• Data Storage and Retrieval: Computers allow for systematic storage of data in databases, enabling easy and convenient retrieval whenever needed.
• Elimination of Duplication: Well-designed accounting systems using computers help in reducing or eliminating redundant data entries.
• Reliability: Unlike humans, computers are not subject to fatigue or boredom, ensuring consistent performance and reliable data processing.

By leveraging these capabilities, computers transform raw accounting data into reliable and useful financial information for decision-making.

Solution: Accounting data refers to the raw facts and figures related to financial transactions recorded in the books of accounts, such as journals, ledgers, and source documents like payment slips and receipts.

The transformation of this raw accounting data into meaningful financial information for decision-making involves several stages, collectively known as data processing:

1. Collecting Data from Source Documents: This initial stage involves gathering data from original records like invoices, receipts, and payment slips to prepare vouchers.
2. Input Data: Accounting data from the prepared vouchers is entered into a computer system using pre-designed data entry forms, which are structured to match the voucher format.
3. Data Storage: The input data is then stored in a structured database. This involves organizing the data in a format that allows for efficient recording and retrieval. A typical data record might include fields like Code, Name, and Type.
4. Manipulation of Data: In this stage, the stored data is processed, transformed, and analyzed using various operations to generate meaningful reports.
5. Output of Data: The final stage involves presenting the processed information in a user-friendly format. This includes generating accounting reports such as Journals, Ledgers, Trial Balances, and final Financial Accounts (like the Income Statement and Balance Sheet) that can be easily accessed and understood by accounting users.

Solution: A database is a structured collection of inter-related data, events, and transactions. It is organized in a systematic way to allow multiple users simultaneous access and to store data efficiently for specific operations. Key properties of a database include:

• Shared Property: Data can be accessed by authorized users to meet their diverse information needs.
• Integrated Property: The database is designed to avoid and eliminate data duplication, ensuring consistency.

A DBMS (Database Management System), on the other hand, is the software that enables the creation, development, and maintenance of a database. It acts as an interface between the users and the database, providing tools to define, organize, transform, and manage the data. While databases store the accounting data, the DBMS is the system that facilitates access to and management of that data.

Solution:

An entity type represents a class of objects or concepts about which data is collected and stored. It defines a category of things that share common properties or attributes. For example, in an accounting system, 'Customer' can be an entity type, representing all customers of a business.

An entity set is a collection of all the entities of a particular entity type at any given time. It is essentially a set of instances belonging to an entity type. Continuing the example, if 'Customer' is the entity type, then the entity set would be all the individual customers currently recorded in the database, such as 'Customer A', 'Customer B', 'Customer C', etc. Each individual customer in the set is an entity.

Illustration from accounting reality:

• Entity Type: 'Employee' (representing all employees of a company).
• Entity Set: The collection of all individual employee records, such as 'John Smith', 'Jane Doe', 'Peter Jones', etc., each having specific attributes like Employee ID, Name, Salary, etc.

In essence, the entity type is the general category, and the entity set is the specific group of items belonging to that category stored in the database.