CBSE Class 12 Informatics Practices Table And Integrity Constraints Worksheet

CBSE Class 12 Informatics Practices Table and Integrity Constraints. CBSE issues sample papers every year for students for class 12 board exams. Students should solve the CBSE issued sample papers to understand the pattern of the question paper which will come in class 12 board exams this year. The sample papers have been provided with marking scheme. It’s always recommended to practice as many CBSE sample papers as possible before the board examinations. Sample papers should be always practiced in examination condition at home or school and the student should show the answers to teachers for checking or compare with the answers provided. Students can download the sample papers in pdf format free and score better marks in examinations. Refer to other links too for latest sample papers.

Lesson 16

Integrity Constraints are the rules that a database must follow at all times. Various Integrity constraints are as follows:-

1. Not Null: It ensures that we cannot leave a column as null i.e. a value has to be supplied for that column.

2. Unique: Ensures that each row for a column must have a unique value. A column(s) can have null value but the values cannot be duplicated.

3. Primary key: - Primary key is used to identify the record uniquely in the table. A combination of a NOT NULL and UNIQUE means that a column cannot have duplicated values and not even a null value.

4. Default: Specifies a default value for a column. If no value is specified while inserting records then default value will be inserted.

5. Check: Ensures that the value in a column meets a specific condition. It is used to limit the range of values that can be inputted in to a column 

6. Foreign Key: Ensure the referential integrity of the data in one table to match values in another

Please click the link below to download full pdf file for CBSE Class 12 Informatics Practices Table and Integrity Constraints.