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 understand by the data manipulation in the relational model?

What is the data manipulation in the relational database?

Data manipulation in the relational model

  • Manipulation is the process that the queries perform on the data items in the relational model to rearrange the data items in the tabular form.
  • Mainly it is performed by the queries when you apply on the database.
  • In the Manipulation you can update the data items to be correct the data value of the records.
  • You can delete the data item which is not very the right value of the record.
  • You can insert the data items in the records to add the additional attributes of the tuples.
  • Manipulation is good for the database management system to make a consistency of the data items in the records.

Why data manipulation is useful for relational model?

  • The manipulation is to change the data for right value.
  • It gives you consistency of the data items when you can separate the same data item in other relational model.
  • It is useful for clear extra data for finding the right data easily in the relational model.

By the manipulation you can create a range of the data availability in criteria which you have decided in the tuple of the table. It also called “update” query on the relational model under the manipulation of data such as “age restriction” on the data items.

The understanding of the manipulation of data in RDBMS

In the relational database management system the manipulation is the maintenance of the database system with applying queries. 

The query is the most important part of the maintenance of the database. The queries do the most essential role in the RDBMS for maintaining the data in their tuples or records. 

Suppose you updating the data in many tuples and also changes their attributes values by the using of queries applying by the query processor. 

The query processor sends the query order to the database engine and the engine perform on the database to change the data in the tuples. 

Image of the data manipulation can be possible in two ways are shown in the figure The data manipulation can possible in a two ways are by applying the queries commands on the database and by using few steps of GUI given in the server. The GUI steps are the basic data manipulation can do but by the using queries you can manipulate the data with core implementation on the database mostly in the Object oriented database and RDBMS {Relational Database Management System}. In the RDBMS with atomic value you can face the difficulty to manipulate the data in their attributes value.

Image of the data manipulation can be possible in two ways are shown in the figure

The data manipulation can possible in a two ways are by applying the queries commands on the database and by using few steps of GUI given in the server. The GUI steps are the basic data manipulation can do but by the using queries you can manipulate the data with core implementation on the database mostly in the Object oriented database and RDBMS {Relational Database Management System}. In the RDBMS with atomic value you can face the difficulty to manipulate the data in their attributes value.


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


Hello guys, I hope you can learn from this post easily from “what do you understand by the data manipulation in the relational model? ” and you get the right information from this post that I have posted related to information technology and computer science topics with questions and answers. Thanks for reading our content 🙂 👍
"I appreciate your attention to this topic! If you have any thoughts or questions, please feel free to share them in the comments below. Until next time, stay curious and keep learning!"
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

Types of Local Storage in Computer Systems

Describe the different types of local storage of computer systems? The local storage device is a type of memory for the user to keep a database file for a long time to access again and stored as a distributed offline database on the local storage. The local storage device can be pendrive, compact discs, dvd, floppy drive, HDD, SSD, memory card etc. The local storage needs to keep the valuable database file for the user to provide the lost database if suddenly deleted or formatted the whole drive of the computer system. Local storage in computer systems refers to devices or media that store data directly connected to the computer. There are several types, including Hard Disk Drives (HDDs), which use spinning disks and magnetic heads to store data; Solid-State Drives (SSDs), which store data in flash memory, offering faster access times and lower power consumption; and Hybrid drives, which combine elements of both. Other forms of local storage include USB flash drives, SD cards, and CDs/...
Post a Comment
Read more

Discuss the data replication on the distributed database system?

Discuss the data replication on the distributed database system? The data replica is a term that refers to the data replication means the copy of data into the servers distributed to access the copy of data. The data replication in a distributed database system is a term that provides the benefits for the user to easily access the data from the nearby server provided for the client user from the website. The data can be easily accessible from the server and provide the fast speed with reduces the latency of the data transfer to the client server such as:- if the user access the data from their smartphone device then the data will be fast to load because the nearby server provide the data replicated or copied of data to the user. Data replication in a distributed database system involves creating and maintaining multiple copies of data across different nodes or locations to enhance availability, reliability, and performance. It ensures that users can access data even if a node fails, re...
Post a Comment
Read more