Skip to main content

What do you mean by data integrity in the relational model of database?

What is the data integrity of the relation model?

  • The data integrity in the relation model data items has consistency in their values.
  • The data integrity allows the purity of the data items in the criteria.
  • Integrity of data in the relational model data enter by many users and the data checking by the certain specified rules of the integrity of data.
  • Some queries perform the data entering as insertion, selection and updating on the data items in the database which causes the data integrity is maintained by these queries.
  • The data integrity checks according to their general rule of integrity of data at the entry level of data itself.
What do you mean by data integrity in the relational model of database?

For example of integrity of data in relational model

When you are enter the data item in the relational database such as “student class” over the student of whole school. All the students are take consistency of the data as student name by the performing a query or by the rules of integrity of data.

In the above image the data integrity are performed by the specific query which is the "select" query of the database programming in the relational database management system model. 

In the relational model the query has performed on the all over the records or tuples and the keyword which is used to make the data in the consistent form by the "class" from every record.

Finally the "select" query gives you the consists records below the all records of the database.

Here is the name of the consistent records are Rita Singh and Raju Singh which are in the class fourth in the school record of the relational database management system model.

Comments

Popular posts from this blog

Discuss the role played by the various components of the CPU

Q Discuss the roles played by the various components of CPU? The CPU is the brain of the computer system. All major calculations, manipulations and comparisons are made by the CPU. The CPU is also responsible for activating and controlling the operations performed by all other units of the computer system. The major components of the CPU are: a) Arithmetic Logic Unit (A.L.U.) b) Control Unit (CU) c) Primary Memory Arithmetic Logic Unit (A.L.U.): What is ALU Arithmetic logic Unit? ALU is a part of the CPU. It is a part to calculate the logical term in the CPU where the term refers to an operation of logical type. It also calculates the arithmetic terms in the CPU where the term refers to an operation of arithmetic type. It is used to direct access through the processor controller. The ALU connected to the input and output peripheral system through the bus with the different types of bus. Such as control bus, data bus etc. ALU is a part of the CPU that can calculate the input...

About the memory and its Classification of the computer Memory

What are the memories in the reference of computer system? What is Computer Memory?:- The memory is the essential for the computer to store the data, instruction and information. Without memory, computers are not be able to store data, instruction etc. The memory is an essential part of a computer system. It is require by the computer system to store information. Memory can be divided into the following two categories types: i) Primary or Main memory ii) Secondary Memory or Permanent memory In this figure I'll show the classification of the memory of computer system peripheral and architecture of organisations Primary Memory or Main memory:- i) Primary memory is the memory which is fastest memory of the computer. ii) It is a small but relatively fast storage unit that stores data and instruction which are used by the CPU (central processing unit). iii) This type or category of a memory is the main memory of the computer.It is a temporary memory and also we ...

What are the three main purpose of an operating system?

What are the three main purpose of an operating system? There are three main purpose of an operating system. 1. The first main purpose is User interface between hardware and users. 2. The second main purpose is to operate the internal parts of the computer properly and systematically using binary code system in the form of 0 and 1. 3. The third main purpose is to provide an environment for development of an application software and program to uses the hardware resources of the computer and connected to the computer parts which provides output to the user, the output from application software is very useful for users. Interface between user and hardware device  The operating system uses all types of interface such as command line interface, batch command interface and Graphical User Interface to interact with users to hardware peripheral devices through the monitor screen. Monitor has a big role making interface between hardware and users. Monitor visualization of all types ...