Class 12 DBMS and Structured Query Language Revision Notes

Read and download free pdf of Class 12 DBMS and Structured Query Language Revision Notes. Students and teachers of Class 12 Computer Science can get free advanced study material, revision notes, sure shot questions and answers for Class 12 Computer Science prepared as per the latest syllabus and examination guidelines in your school. Standard 12 students should download this study material which will give them more knowledge for all chapters in Computer Science and all important topics which are scoring and can get you more marks. Students should also download free pdf of Chapter wise Notes for Class 12 Computer Science prepared by school teachers as per the latest NCERT, CBSE, KVS books and syllabus issued this year and also download free worksheets and question papers available here to get higher scores in school exams and tests, also click here for more Study Material for Class 12 Computer Science

 Basic Database Concepts

Data : Raw facts and figures which are useful to an organization. We cannot take decisions on the basis of data.
Information: Well processed data is called information. We can take decisions on the basis of information
Field: Set of characters that represents specific data element.
Record: Collection of fields is called a record. A record can have fields of different data types.
File: Collection of similar types of records is called a file.
Table: Collection of rows and columns that contains useful data/information is called a table. A table generally refers to the passive entity which is kept in secondary storage device.
Relation: Relation (collection of rows and columns) generally refers to an active entity on which we can perform various operations.
Database: Collection of logically related data along with its description is termed as database.
Tuple: A row in a relation is called a tuple.
Attribute: A column in a relation is called an attribute. It is also termed as field or data item.
Degree: Number of attributes in a relation is called degree of a relation.
Cardinality: Number of tuples in a relation is called cardinality of a relation.
Primary Key: Primary key is a key that can uniquely identifies the records/tuples in a relation. This key can never be duplicated and NULL.
Foreign Key: Non key attribute of a table acting as primary key in some other table is known as Foreign Key in its current table. This key is used to enforce referential integrity in RDBMS.
Candidate Key: Attributes of a table which can serve as a primary key are called candidate key.
Alternate Key: All the candidate keys other than the primary keys of a relation are alternate keys for a relation.
DBA: Data Base Administrator is a person (manager) that is responsible for defining the data base schema, setting security features in database, ensuring proper functioning of the data bases etc.
Select Operation: The select operation selects tuples from a relation which satisfy a given condition.
It is denoted by lowercase Greek Letter σ (sigma).
Project Operation: The project operation selects columns from a relation which satisfy a given condition.
It is denoted by lowercase Greek Letter π (pi). It can be thought of as picking a sub set of all available columns.
Union Operation: The union (denoted as ∪) of a collection of relations is the set of all distinct tuples in the collection. It is a binary operation that needs two relations.
Set Difference Operation: This is denoted by – (minus) and is a binary operation. It results in a set of tuples that are in one relation but not in another
 
 Structured Query Language

SQL is a non procedural language that is used to create, manipulate and process the databases(relations).
 
1. Data Definition Language (DDL)
DDL contains commands that are used to create the tables, databases, indexes, views, sequences and synonyms etc.
e.g: Create table, create view, create index, alter table etc.
 

Tags: 

 


Click to View or Download pdf file
Click for more Computer Science Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Online courses for classes XI and XII offered by NCERT

Ministry of Education (MoE), Government of India has launched a platform for offering Massive Open Online Courses (MOOCs) that is popularly known as SWAYAM (Study Webs of Active learning for Young Aspiring Minds) on 9 th July, 2017. NCERT now offers online courses for...

Class 10th and 12th Term 2 Revaluation Process 2022

Evaluation of the Answer Books is done under a well-settled Policy. To ensure that the evaluation is error free, CBSE is taking several steps. After strictly following these steps, the result is prepared. Though, CBSE is having a well-settled system of assessment,...

CBSE Reading Challenge

The acquisition of 21st century competencies of communication, critical and creative thinking and the ability to locate, understand and reflect on various kinds of information has become more crucial for our learners. It is well accepted that Reading Literacy is not...

CBSE Class 10 Revised Syllabus

Last year CBSE had to reduce the syllabus because of the pandemic situation but it was not very effective because there were no examinations. This year to avoid any confusion and conflict, CBSE has decided to reduce the syllabus into term 1 and term 2. 50 percent of...

All India Children Educational Audio Video Festival

The Central Institute of Educational Technology (CIET), a constituent unit of National Council of Educational Research and Training (NCERT), is inviting entries for the 26th All India Children’s Educational Audio Video Festival (AICEAVF). This festival showcases the...

CBSE OMR Sheet Guidelines for Term 1

You are aware that the CBSE will be using OMR for the first time for assessment of both the Classes-X and XII in Term-I examinations. Hence, there is a need that all the students appearing in the Term-l examinations and the schools sponsoring these students should have...