CBSE Class 11 Financial Accounting Chapter 15: Structuring Database for Accounting NCERT Solutions

Solution: The primary categories of data models used in database systems are:

1. Relational Data Model
2. Hierarchical Data Model
3. Network Data Model

The Relational Data Model organizes data into tables composed of rows (called tuples) and columns (called attributes). It was introduced by Ted Codd in 1970 and is based on the relationships between data values.

The Hierarchical Data Model organizes data in a tree-like structure, with records linked through parent-child relationships. It represents data as a collection of records and uses links to show relationships.

The Network Data Model, also known as the DBTG model, organizes data using records and sets, allowing for many-to-many relationships. Data is stored in records, and sets define the relationships between different record types.

Solution: Computers are highly beneficial in processing accounting data due to several reasons:

1. Efficiency and Speed: Computers can process vast amounts of data much faster than manual methods, significantly reducing the time required for tasks like summarizing and analyzing transactions.
2. Accuracy and Precision: Unlike humans, computers are not prone to fatigue or boredom, leading to a higher degree of precision and fewer errors in calculations and data entry.
3. Data Storage and Retrieval: Computers enable the design of sophisticated databases that allow for efficient storage and easy, convenient retrieval of accounting data whenever needed.
4. Elimination of Duplication: Computer systems can be designed to prevent or minimize the duplication of data, ensuring data integrity and consistency across different records and reports.
5. Reliability: Due to their consistent performance and reduced error rates, data processed by computers is generally more reliable for decision-making.

In essence, computers transform raw accounting data into reliable and useful information for effective decision-making.

Solution: Accounting data refers to the raw facts, figures, and financial details recorded in the books of accounts, such as journals, ledgers, and other accounting records. It represents the financial transactions and events of a business.

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

1. Collecting Data from Source Documents: The process begins with gathering data from original transaction records like payment slips, receipts, invoices, and bank statements. These documents are used to prepare accounting vouchers.
2. Inputting Data: Data from the prepared vouchers is entered into a computer system. This is typically done using pre-designed data entry forms that mirror the structure of the physical vouchers, ensuring systematic and chronological recording.
3. Data Storage: The entered data is then stored in a structured database. This involves organizing the data in a way that allows for efficient retrieval and management, often using tables with defined fields (like code, name, type).
4. Manipulation of Data: In this stage, the stored data is processed and transformed using software. This involves calculations, sorting, summarizing, and other operations to generate various accounting reports.
5. Output of Data: The final stage involves presenting the processed data in a user-friendly format as useful information. This includes generating reports such as Journals, Ledgers, Trial Balances, and ultimately, the Financial Statements (like the Income Statement and Balance Sheet) that are used by stakeholders for decision-making.

Solution: A database is a systematically organized collection of inter-related data, events, and transactions. It is designed to store information in a manner that allows multiple users to access and manage it simultaneously for specific operations. Key properties of a database include:

• Shared Property: Data within the database can be accessed by authorized users to meet their diverse information requirements.
• Integrated Property: The database is structured to avoid and eliminate data redundancy, ensuring consistency and accuracy.

A DBMS (Database Management System), on the other hand, is the software system that enables users to create, develop, maintain, and interact with a database. It acts as an interface between the user and the database, handling the complex tasks of data definition, organization, storage, and retrieval. While databases are for storing accounting data, the DBMS is the tool that makes this storage and access efficient and manageable.

Solution:

An entity type represents a class or category of objects that have common properties and characteristics. It defines the structure or blueprint for a particular type of data that will be stored. For example, in an accounting context, 'Customer' can be considered an entity type.

An entity set is a collection of all the actual entities that belong to a specific entity type at a given point in time. It is a set of instances of an entity type. Continuing the example, if 'Customer' is the entity type, then the entity set would be the collection of all individual customers of the company (e.g., Customer A, Customer B, Customer C, etc.). Each customer in the set would have attributes defined by the 'Customer' entity type, such as customer ID, name, address, and contact number.

In summary:

• Entity Type: The general classification or category (e.g., Employee, Product, Vendor).
• Entity Set: The specific collection of all instances of that type (e.g., all employees in the company, all products sold, all vendors listed).