Accounting System Using Database Management System Class 11 NCERT

Overview: Why DBMS Is Used in Accounting

A business records hundreds or thousands of transactions. If data is kept in separate files, the same customer name, account code or amount may be typed repeatedly, increasing errors. A Database Management System, or DBMS, solves this by storing related data in organised tables and allowing controlled access, search, update and reporting. In accounting, the DBMS must preserve the double-entry principle: every transaction affects at least two accounts and the total debit must equal total credit. Therefore, a good accounting database is not just a list of transactions; it is a structured system that connects vouchers, accounts, ledger entries and reports.

Key Terms in Accounting Database Design

Database

An organised collection of related data stored so that it can be accessed, managed and updated efficiently.

DBMS

Software that helps users create, store, modify, retrieve and secure data in a database.

Entity

A real-world object or concept about which data is stored, such as Account, Voucher, Customer or Employee.

Attribute

A property of an entity, such as account name, voucher number, date or amount.

Primary Key

A field or combination of fields that uniquely identifies each record in a table, such as AccountCode in an Accounts table.

Foreign Key

A field in one table that refers to the primary key of another table, helping to build relationships between tables.

How an Accounting System Works Using DBMS

1. Step 1: Capture source data — The process begins with accounting evidence such as invoices, receipts, payment vouchers and journal vouchers. Each document provides basic details like date, parties involved, amount and narration.
2. Step 2: Store data in tables — Instead of entering everything in one large sheet, the system stores data in related tables such as Accounts, Vouchers and VoucherDetails. This reduces repetition and keeps records consistent.
3. Step 3: Apply accounting rules — For every voucher, debit and credit entries are recorded. The system checks whether total debits equal total credits before accepting the transaction as complete.
4. Step 4: Retrieve through queries — Queries select, filter, sort or calculate data. For example, a ledger query may fetch all entries related to Cash Account and arrange them date-wise.
5. Step 5: Generate reports — Reports convert stored data into useful accounting output such as ledger accounts, trial balance, cash book, profit and loss account and balance sheet.

Worked Examples

• Example 1: Identify entities and attributes for a simple sales accounting system. Step 1: Read the requirement: the business wants to record sales invoices, customer details and amounts. Step 2: Identify entities. Customer is an entity because customer data is stored repeatedly. SalesInvoice is an entity because each invoice is a separate transaction document. Account is also an entity because sales, debtors and tax accounts are affected. Step 3: Identify attributes. Customer may have CustomerID, Name and Address. SalesInvoice may have InvoiceNo, Date, CustomerID and TotalAmount. Account may have AccountCode and AccountName. Step 4: Decide keys. CustomerID can be primary key for Customer. InvoiceNo can be primary key for SalesInvoice. CustomerID in SalesInvoice becomes foreign key. Final answer: Main entities are Customer, SalesInvoice and Account; suitable keys are CustomerID, InvoiceNo and AccountCode.
• Example 2: Show how one transaction is stored in accounting tables. Transaction: Goods sold for cash ₹5,000. Step 1: Apply double-entry rule. Cash Account is debited because cash increases. Sales Account is credited because revenue increases. Step 2: Create voucher header. VoucherNo: V001, Date: current date, Type: Receipt or Sales, Narration: Goods sold for cash. Step 3: Create voucher detail rows. Row 1: V001, Cash Account, Debit ₹5,000, Credit ₹0. Row 2: V001, Sales Account, Debit ₹0, Credit ₹5,000. Step 4: Check equality. Total debit ₹5,000 equals total credit ₹5,000, so the DBMS can accept the voucher. Final answer: The database stores one voucher header and two voucher detail records, preserving double-entry accounting.
• Example 3: Generate a trial balance from voucher details. Data: Cash Dr ₹5,000, Sales Cr ₹5,000; Purchases Dr ₹2,000, Cash Cr ₹2,000. Step 1: Group entries by account. Cash has debit ₹5,000 and credit ₹2,000. Sales has credit ₹5,000. Purchases has debit ₹2,000. Step 2: Find balances. Cash debit balance = ₹5,000 - ₹2,000 = ₹3,000. Sales credit balance = ₹5,000. Purchases debit balance = ₹2,000. Step 3: Prepare totals. Debit side = Cash ₹3,000 + Purchases ₹2,000 = ₹5,000. Credit side = Sales ₹5,000. Final answer: Trial balance agrees because total debits ₹5,000 equal total credits ₹5,000.

Manual Accounting System vs DBMS-Based Accounting System

Board Exam Tips and Common Mistakes

Do not write that DBMS automatically means accounting is correct. A DBMS improves storage and processing, but correct output depends on correct data entry, proper table design and accounting rules. In answers, use accounting words such as voucher, ledger, account, debit, credit, report and trial balance. A common mistake is confusing primary key with foreign key: the primary key uniquely identifies a record in its own table, while a foreign key links one table to another. In practical questions, always check debit-credit equality before saying a voucher is valid.

Practice Questions with Solutions

• Q: What is the role of a primary key in an accounting database? Give one example. A: Step 1: A primary key is used to identify each record uniquely in a table. Step 2: In an Accounts table, AccountCode can be used because each account should have a unique code. Step 3: This prevents confusion between accounts with similar names and helps other tables refer to the correct account. Final answer: A primary key uniquely identifies records; AccountCode in the Accounts table is a suitable example.
• Q: A voucher records Rent paid in cash ₹8,000. Show the debit and credit entries and state whether the voucher is valid. A: Step 1: Identify accounts affected. Rent Account is an expense and Cash Account is an asset. Step 2: Apply rules. Rent expense increases, so Rent Account is debited by ₹8,000. Cash decreases, so Cash Account is credited by ₹8,000. Step 3: Compare totals. Total debit = ₹8,000 and total credit = ₹8,000. Final answer: Rent A/c Dr ₹8,000 and Cash A/c Cr ₹8,000; the voucher is valid because debit equals credit.
• Q: Mention two advantages of using DBMS in an accounting system over a manual system. A: Step 1: Consider storage. DBMS stores related data in tables, reducing duplication and inconsistency. Step 2: Consider reporting. It can retrieve data quickly through queries to prepare ledgers, trial balance and other reports. Step 3: Add control. Validation can reduce errors such as missing voucher numbers or unequal debit-credit totals. Final answer: Two advantages are reduced data duplication and faster, more accurate report generation.
• Q: In a VoucherDetails table, fields are VoucherNo, AccountCode, DebitAmount and CreditAmount. Why are VoucherNo and AccountCode likely to be foreign keys? A: Step 1: VoucherNo usually refers to a record in the Voucher table where date, type and narration are stored. Step 2: AccountCode usually refers to a record in the Accounts table where account name and group are stored. Step 3: Since these fields link VoucherDetails to other tables, they act as foreign keys. Final answer: VoucherNo and AccountCode are likely foreign keys because they connect voucher detail records with voucher header and account master records.

Frequently Asked Questions