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.

Comments

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 of o

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

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

computers-achievers

Search This Blog