Databases Management class 12 Notes Computer Science

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE class 12 Computer Science Databases Management class 12 Notes Computer Science in PDF are available for free download in myCBSEguide mobile app. The best app for CBSE students now provides Databases Management class 12 Notes Computer Science latest chapter wise notes for quick preparation of CBSE board exams and school based annual examinations. Class 12 Computer Science notes on chapter 3 Databases Management Computer Science are also available for download in CBSE Guide website.

CBSE Guide Databases Management class 12 Notes Computer Science

CBSE guide notes are the comprehensive notes which covers the latest syllabus of CBSE and NCERT. It includes all the topics given in NCERT class 12 Computer Science text book. Users can download CBSE guide quick revision notes from myCBSEguide mobile app and my CBSE guide website.

12 Computer Science notes Chapter 3 Databases Management

Download CBSE class 12th revision notes for chapter 3 Databases Management in PDF format for free. Download revision notes for Databases Management class 12 Notes Computer Science and score high in exams. These are the Databases Management class 12 Notes prepared by team of expert teachers. The revision notes help you revise the whole chapter 3 in minutes. Revision notes in exam days is one of the best tips recommended by teachers during exam days.

Download Revision Notes as PDF

CBSE Class 12 Computer Science 3
Databases Management class 12 Notes Computer Science
Revision Notes (Database Concepts and SQL)

Relations: In relational data model, the data is organised into tables(in the form of rows and columns) called relations.

Domain: A domain is the sets of values from which the actual values appearing in a given column are drawn.

Tuple: A row in a relation.

Attribute: A column in a relation.

Primary Key: A column or set of columns that uniquely identifies a row within a table is called primary key.

Candidate Key: Candidate keys are set of fields (columns with unique values) in the relation that are eligible to act as a primary key.

Alternate Key: A candidate key that is not the primary key is called alternate key.

DDL: Data Definition Language (DDL) or Data Description Language (DDL).

DML: Data Manipulation Language (DML).

String datatypes: CHAR, VARCHAR, VARCHAR2

Numeric datatype: NUMBER, NUMERIC, INT, FLOAT, DECIMAL

Date: DATE

Selection: Selection in relational algebra returns those tuples (records) in a relation that fulfil a condition (Produce table containing subset of rows).

Projection: Projection in relational algebra returns those columns in a relation that given in the attribute list (Produce table containing subset of columns).

Union: The union operator is used to combine two or more tables. In the union operation, duplicate records will be automatically removed from the resultant table.

Cartesian product: SQL joins are used to relate information in different tables. Cartesian product returns a number of rows equal to number of rows in the first table multiply by number of rows in the second table. At the same time, number of columns equal to number of columns in the first table added by number of columns in the second table.

SQL (Structured Query Language)

CREATE TABLE: Used to create the structure of a table.
CREATE TABLE table_name (column1 datatype, column2 datatype, column3  datatype,….);

ALTER TABLE: Used to implement structure modification.

To add a new column after creating table:
ALTER TABLE table_name ADD column_name datatype;

To modify an existing column.
ALTER TABLE table_name MODIFY COLUMN column_name datatype;

DROP TABLE: To remove a table  and remove all of its data
DROP TABLE table_name ;

INSERT INTO: is used to insert new records in a table.

INSERT INTO table_name (column1,column2,column3, ..) VALUES(value1, value2, value3, ..);

SELECT: The SELECT statement is used to select and display data from a database.
SELECT column1, column2, … FROM table_name;
SELECT * FROM table_name;
SELECT column1, column2, … FROM table_name WHERE condition;

DISTINCT: Distinct keyword eliminates duplicate rows from the result of a select statement.
SELECT DISTINCT column1, column2, … FROM table_name;

ORDER BY : Used to sort the result-set in ascending or descending order.
SELECT column1, column2, … FROM table_name ORDER BY  column1 … ASC|DESC;

GROUP BY : Used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns
SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s)

HAVING : Places condition on groups.

SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition

MAX (): To select the maximum value of a particular column.

SELECT MAX(column_name) FROM table_name WHERE condition;

MIN (): To select the minimum value of a particular column.

SELECT MIN(column_name) FROM table_name WHERE condition;

SUM (): To find the total value of a particular column.

SELECT SUM(column_name) FROM table_name WHERE condition;

AVG (): To find the average value of a particular column.

SELECT AVG(column_name) FROM table_name WHERE condition;

COUNT (): Returns the number of records in the table.

SELECT COUNT(column_name) FROM table_name WHERE condition;

UPDATE : Used to modify the existing records in a table.

UPDATE table_name SET column1 = value1, column2 = value2, …WHERE condition;

DELETE : Used to delete existing records in a table.

DELETE FROM table_name WHERE condition;

Databases Management class 12 Notes Computer Science

  • CBSE Revision notes (PDF Download) Free
  • CBSE Revision notes for Class 12 Computer Science PDF
  • CBSE Revision notes Class 12 Computer Science – CBSE
  • CBSE Revisions notes and Key Points Class 12 Computer Science
  • Summary of the NCERT books all chapters in Computer Science class 12
  • Short notes for CBSE class 12th Computer Science
  • Key notes and chapter summary of Computer Science class 12
  • Quick revision notes for CBSE board exams

CBSE Class-12 Revision Notes and Key Points

Databases Management class 12 Notes Computer Science. CBSE quick revision note for class-12 Computer Science, Chemistry, Math’s, Biology and other subject are very helpful to revise the whole syllabus during exam days. The revision notes covers all important formulas and concepts given in the chapter. Even if you wish to have an overview of a chapter, quick revision notes are here to do if for you. These notes will certainly save your time during stressful exam days.

To download Databases Management class 12 Notes Computer Science, sample paper for class 12 Physics, Chemistry, Biology, History, Computer Science, Economics, Computer Science, Computer Science, Home Science, Accountancy, Computer Science and Home Science; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.




Test Generator

NEET-UG 2021

10,000+ Daily Practice Questions

(only at ₹ 299/- in myCBSEguide App)

Demo Video Install Now

1 thought on “Databases Management class 12 Notes Computer Science”

  1. CBSE students should stay ready and prepare well because in the change of exam pattern in cbse.
    according to the latest update i found on the official website that the admit card for class 12th regular and private have been released.

Leave a Comment