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.
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.
Topics in Database Management System
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. 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. 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. 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
Work through every topic in Database Management System with notes and quizzes
Start This ChapterFrequently Asked Questions
What are the important topics in Database Management System for NIOS Class 12 Accountancy?
How should I revise Database Management System for the NIOS Class 12 board exam?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Database Management System
Practice Quiz
Test yourself with a quick quiz
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
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.