Skip to main content

Newer Post or latest post

Li-Fi vs Wi-Fi: A Battle of Light and Waves

Li-Fi vs Wi-Fi: A Battle of Light and Waves Li-fi is a light fidelity device that supports only the infrared and other lighting systems to transfer the data to the device which is used to receive from the sender device. Wifi is a wireless fidelity device that supports the radio waves to transfer the data to the wifi device which is used to receive the wifi signals at the limited ranges due to the device version capacity. Introduction to the computer system and computer applications related topics are listed following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves Let’s discuss the computer system related topic and questions above listed and their answers are following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves There are some points on the computer system and data communication related to the topic of “Li-Fi vs Wi-Fi: A Battle of Light and Waves” following below here: Lifi based data communication system:- Li-Fi is a light based signal data transmission ...
Post a Comment

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.


------------------------------------------------------------------------------------------------------------



I hope you from this topic “ What do you mean by data integrity in the relational model of database? ” and you can enjoy this informative post that i have published and provide you to the information technology or computer science related solution or questions/answers provided in the topic to study and happy learning 🙂
"Thank you for taking the time to read this post! I hope you found the information helpful and informative. Don't forget to stay tuned for more exciting updates and insightful content. Your support means the world to me!"
Labels:

Comments

Post a Comment

Popular posts from this blog

what are the function of the joystick and light pen?

Q 1. State the functions of a joystick and that of a light pen? Introduction to the joystick device, virtual or soft joystick tool, game controller, virtual or soft game controller and light pen topics are covered below here: Joystick What is the meaning of the joystick in computer? What is the joystick as a peripheral device in the computer system? What is main use of joystick in computer system peripheral devices? What is the purpose of the joystick in computer? What are the types of joysticks in the peripheral system for game purpose? What do you mean by analog joystick in peripheral system? What are the advantages of analog joystick device? What are the disadvantages or drawbacks of analog joystick device? What are the uses of joysticks? What are top 5 uses of joystick device in the computer system peripheral? Where is the use of joystick? How to connect the joystick for game in computer system? Can you connect the joystick to the laptop? Why do n...
Post a Comment
Read more

Top Benefits of an Information Management System

Describe the benefits of an information management system? The information is a relationship between data and sets of data to provide the meaning of a particular objective and reasons etc. that make a sense to read or understand the information for a specific purpose. Information management provides the system of making more accurate the meaning of information and reduces the redundancy from the information using the information management system. The information provides a meaningful statement to the user to make a decision from the information and then the user takes the next step after receiving the information from the data communication system. An information management system offers numerous benefits, including improved data organization, enhanced decision-making, and increased productivity. By centralizing and structuring data, these systems enable quick access to accurate information, reducing errors and inconsistencies. Automated processes and workflows streamline tasks, freei...
Post a Comment
Read more

How is the data stored in the database file on the application software?

How is the data stored in the database file on the application software? The database files can be created on the storage device to store the new information in the file through the application software using the definition command applied on the blank database files. The database manipulation command to store the new data and information into the database files which is blank created on the storage device on the computer system. The database files are created through the create database command applied on the application software which is programmed through the SQL command on the relational database model. The database can be managed through the data manipulation command applied on the application database files using the DML of SQL means the DML is used to manipulate and change the information also in the database files. In an application software, data is stored in a database file using a structured format that allows efficient retrieval and management. The database file typically c...
Post a Comment
Read more