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.
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
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.
- Revision Notes for class-12 Physics
- Revision Notes for class-12 Chemistry
- Revision Notes for class-12 Mathematics
- Revision Notes for class-12 Biology
- Revision Notes for class-12 Accountancy
- Revision Notes for class-12 Economics
- Revision Notes for class-12 Business Studies
- Revision Notes for class-12 Computer Science
- Revision Notes for class-12 Informatics Practices
- Revision Notes for class-12 English Core
- Revision Notes for class-12 History
- Revision Notes for class-12 Physical Education
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.
- Pythan Advanced Programming class 12 Notes Computer Science
- Databases Management class 12 Notes Computer Science
- Introduction to Boolean Algebra class 12 Notes Computer Science
10,000+ Daily Practice Questions
(only at ₹ 299/- in myCBSEguide App)Demo Video Install Now