Skip to main content
Chapter 38 of 38
Syllabus

Database Management System — Syllabus

NIOS · Class 12 · Accountancy

Database Management System topics: Database and DBMS Basics, Structure Design of Database, Account Classification and Coding Scheme, plus 1 more.

112 questions32 flashcards5 concepts

Interactive on Super Tutor

Studying Database Management System? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for syllabus and more.

Free trial, no card needed.

4 Topics · NIOS Class 12 Accountancy · 2026-27

Topics in Database Management System

1

1. Database and DBMS Basics

  • A database is a collection of data for generating useful and decision worthy information.
  • A database consists of an organized collection of interrelated data for one or more users in digital form.
  • DBMS overcomes data redundancy, inconsistency, data duplicity, difficulty in accessing data, data isolation, and data security problems.
2

2. Structure Design of Database

  • The process of structuring a database comprises Requirement Analysis, Conceptual Design, and Logical Design.
  • Requirement Analysis is the first and most important stage while designing a database.
  • Requirement Analysis considers the data to be stored, frequency of modification, user types, hardware/OS level, and whether other front-end applications use the back end.
3

3. Account Classification and Coding Scheme

  • Accounts are classified into five account types: Expenditure, Income, Assets, Liabilities and Capital.
  • The account coding scheme uses a 4-digit code.
  • The first digit shows the category, the second digit shows the sub-category, and the third digit shows the specific account.
4

4. Accounts Table and Account Type Table

  • The Accounts table has fields Code, Account Name, and Acc_Type.
  • Code is the primary key and is of Text type.
  • acc_name is Text.

Key Concepts

Central concept: Database Management System in Accountancy

DatabaseDBMS BenefitsDatabase Design StagesRequirement AnalysisConceptual DesignLogical DesignUnique ElectronicsAccount Classification

Work through every topic in Database Management System with notes and quizzes

Start This Chapter

Frequently Asked Questions

What are the important topics in Database Management System for NIOS Class 12 Accountancy?
Key topics in Database Management System include Database and DBMS Basics, Structure Design of Database, Account Classification and Coding Scheme, Accounts Table and Account Type Table. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How should I revise Database Management System for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 112 practice questions on Database Management System. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

For serious students

Get the full Database Management System chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.