CBSE Class 12 Computer Science Database And SQL Concepts

Read and download free pdf of CBSE Class 12 Computer Science Database And SQL Concepts. Get printable school Assignments for Class 12 Computer Science. Class 12 students should practise questions and answers given here for Database And Sql Concepts Computer Science in Class 12 which will help them to strengthen their understanding of all important topics. Students should also download free pdf of Printable Worksheets for Class 12 Computer Science prepared as per the latest books and syllabus issued by NCERT, CBSE, KVS and do problems daily to score better marks in tests and examinations

Assignment for Class 12 Computer Science Database And Sql Concepts

Class 12 Computer Science students should refer to the following printable assignment in Pdf for Database And Sql Concepts in Class 12. This test paper with questions and answers for Class 12 Computer Science will be very useful for exams and help you to score good marks

Database And Sql Concepts Class 12 Computer Science Assignment

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 secondarystorage 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: Foreign Key is a key that is defined as a primary key in some other relation. This key is used to enforce referential integrity in RDBMS.

Candidate Key: Set of all attributes which can serve as a primary key in a relation.

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. Data types of SQL Just like any other programming language, the facility of defining data of various types is available in

SQL also. Following are the most common data types of SQL.

       1) NUMBER

       2) CHAR

       3) VARCHAR / VARCHAR2

       4) DATE

       5) LONG

       6) RAW/LONG RAW

 

Constraints:

Constraints are the conditions that can be enforced on the attributes of a relation. The constraints come in play when ever we try to insert, delete or update a record in a relation.They are used to ensure integrity of a relation, hence named as integrity constraints.

1. NOT NULL

2. UNIQUE

3. PRIMARY KEY

4. FOREIGN KEY

5. CHECK

6. DEFAULT

i. Not Null constraint : It ensures that the column cannot contain a NULL value.

ii. Unique constraint : A candidate key is a combination of one or more columns, the value of which uniquely identifies each row of a table.

iii. Primary Key : It ensures two things : (i) Unique identification of each row in the table.

 

(ii)No column that is part of the Primary Key constraint can contain a NULL value.

iv. Foreign Key : The foreign key designates a column or combination of columns as a foreign key and establishes its relationship with a primary key in different table.
Create table Fee

(RollNo number(2) Foreign key (Rollno) references Student (Rollno),

Name varchar2(20) Not null, Amount

number(4), Fee_Date date);

v. Check Constraint : Sometimes we may require that values in some of the columns of our table are to be within a certain range or they must satisfy
cceorntdaiintions.

Example:

Create table Employee

(EmpNo number(4) Primary Key,

Name varchar2(20) Not Null,

Salary number(6,2) check (salary > 0),

DeptNo number(3)
);
Data Manipulation in SQL

DML Commands are as under:

SELECT - Used for making queries

INSERT - Used for adding new row or record into table

UPDATE- used for modification in existing data in a table

DELETE – used for deletion of records.

INSERT Statement

To insert a new tuple into a table is to use the insert statement

insert into <table> [(<column i, . . . , column j>)] values (<value i, . . . , value j>);

INSERT INTO student VALUES(101,'Rohan','XI',400,'Jammu');

While inserting the record it should be checked that the values passed are of same data types as the one

which is specified for that particular column.

For inserting a row interactively (from keyboard) & operator can be used.

e.g INSERT INTO student VALUES(&Roll_no’,’&Name’,’&Class’,’&Marks’,’&City’);

In the above command the values for all the columns are read from keyboard and inserted into the table student.

 

Please refer to attached file for CBSE Class 12 Computer Science Database And SQL Concepts

More Study Material

CBSE Class 12 Computer Science Database And Sql Concepts Assignment

We hope you liked the above assignment for Database And Sql Concepts which has been designed as per the latest syllabus for Class 12 Computer Science released by CBSE. Students of Class 12 should download and practice the above Assignments for Class 12 Computer Science regularly. We have provided all types of questions like MCQs, short answer questions, objective questions and long answer questions in the Class 12 Computer Science practice sheet in Pdf. All questions have been designed for Computer Science by looking into the pattern of problems asked in previous year examinations. 

Assignment for Computer Science CBSE Class 12 Database And Sql Concepts

Our team of expert teachers have referred to NCERT book for Class 12 Computer Science to design the Computer Science Class 12 Assignments. If you practice at least one test paper daily, you will get higher marks in Class 12 exams this year. Daily practice of Computer Science course notes and related study material will help you to clear all your doubts and have stronger understanding of all concepts. You can download all Revision notes for Class 12 Computer Science also from www.studiestoday.com absolutely free of cost.

Database And Sql Concepts Assignment Computer Science CBSE Class 12

All questions and their answers for the assignment given above for Class 12 Computer Science have been developed as per the latest curriculum and books issued for the current academic year. The students of Class 12 can rest assured that the best teachers have designed the questions of Computer Science so that you are able to revise the entire syllabus if you do the assignments. Lot of MCQ questions for Class 12 Computer Science have also been given in the worksheets and assignments for regular use. All study material for Class 12 Computer Science students have been given on studiestoday.

Database And Sql Concepts Assignment CBSE Class 12 Computer Science

Regular assignment practice helps to get a more comprehensive understanding of Database And Sql Concepts concepts. Assignments play a crucial role in understanding Database And Sql Concepts in CBSE Class 12. Students can download all the assignments of the same chapter in Class 12 Computer Science in Pdf format. You can print them or read them online on your computer or mobile.

CBSE Computer Science Class 12 Database And Sql Concepts Assignment

CBSE Class 12 Computer Science latest books have been used for coming up with the latest questions and solutions for the above assignment. If you have revised all concepts relating to Database And Sql Concepts then you should attempt all questions given in the test sheets above. We have also provided lot of Worksheets for Class 12 Computer Science which you can use to further make your self stronger in Computer Science

Where can I download in PDF assignments for CBSE Class 12 Computer Science Database And Sql Concepts

You can download free Pdf assignments for CBSE Class 12 Computer Science Database And Sql Concepts from StudiesToday.com

The assignments for Database And Sql Concepts Class 12 Computer Science for have been made based on which syllabus

The Database And Sql Concepts Class 12 Computer Science Assignments have been designed based on latest CBSE syllabus for Class 12 Computer Science issued for the current academic year

Can I download and print these printable assignments for Computer Science Database And Sql Concepts Class 12

Yes, These printable assignments for Database And Sql Concepts Class 12 Computer Science are free to download and print

How many topics are covered in Database And Sql Concepts Computer Science assignments for Class 12

All topics given in Database And Sql Concepts Computer Science Class 12 Book for the current academic year have been covered in the given assignment

Is there any charge for this assignment for Database And Sql Concepts Computer Science Class 12

No, all Printable Assignments for Database And Sql Concepts Class 12 Computer Science have been given for free and can be downloaded in Pdf format

How can I download the printable test assignments for Database And Sql Concepts Computer Science Class 12

Just click on the View or Download button below, then another window with the Pdf will be visible, just click on the Pdf icon to download the free assignments for Database And Sql Concepts Class 12 Computer Science

Are these assignments available for all chapters in Class 12 Computer Science

Yes, apart from Computer Science you can download free assignments for all subjects in Class 12

Can I download solved assignments for Database And Sql Concepts CBSE Class 12 Computer Science

Our team of expert teachers at studiestoday.com have provided all answers for the practice questions which have been given in Class 12 Computer Science Database And Sql Concepts assignments