Database Management System — Formula Sheet
NIOS · Class 12 · Computer Science
7 formulas from Database Management System (NIOS Class 12 Computer Science) on one page, grouped by topic. Covers Core Concepts and Terminology, Keys.
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 formula sheet and more.
Free trial, no card needed.
Formulas and Key Relations
MySQL and SQL
CREATE DATABASE <databasename>;
CREATE TABLE <tablename> (<columnname1><data type1> NOT NULL, <columnname2><data type2> default NULL, ... <columnname><data type> default <some value>
INSERT INTO <tablename> VALUES (<value1>,<value2>,...,<value>);
Select field1, field2, ..., fieldN from table1, table2 where condition1 AND/OR condition2 AND/OR condition...
ALTER TABLE table_name ADD (newcolumnname datatype (size), newcolumnname datatype (size),...);
SQL Data Types and Rules
INT or INTEGER range: -2147483648 to 2147483647
DECIMAL(6,4) specifies that a column can store values in the range -99.9999 to 99.9999
Full sheet with units and worked examples
View AllFrequently Asked Questions
What are the important topics in Database Management System for NIOS Class 12 Computer Science?
How many formulas are in Database Management System?
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
Syllabus
What topics to cover
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 Computer Science. Free to start, no card needed.