Skip to main content
Chapter 23 of 29
Formula Sheet

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.

101 questions49 flashcards7 formulas & key relations5 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 formula sheet and more.

Free trial, no card needed.

7 Entries · 2 Sections

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 All

Frequently Asked Questions

What are the important topics in Database Management System for NIOS Class 12 Computer Science?
Key topics in Database Management System include Core Concepts and Terminology, Keys, Normalization, and Data Models, MySQL and SQL Basics, Table Creation and Common SQL Operations. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How many formulas are in Database Management System?
This sheet lists 7 formulas from Database Management System, grouped by topic. Learn what each symbol stands for so you can apply the formula, not just recall it.
How should I revise Database Management System for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 101 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 Computer Science. Free to start, no card needed.