answersLogoWhite

0


Best Answer
The Selection Operation is used to select a subset of the tuples (records) from a relation (file) that satisfy a selection condition.If we think of a relation as a table, the select operation select some of the Rows from the table while discarding other Rows.


The Projection select certain column from the table and discarding the other columns.

The result of the Projection operation can hence be visualized as a vertical partition of the relation into two relations, one has needed columns (attributes) & contain the result of the operations & the other contains in the discarded column.




Binamani Boro

Guwahati

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

Selection and projection are terms used in relational algebra. Selection is the term used for "where" relational algebra . Projection is the term used for "select" in relational algebra .

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Where are the function of selection and projection operation?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is difference between selection and projection operation?

Projection is from which columns the result should come... Selection means selecting perticular row.


Why selection query is first done than projection query?

Selection has more power to reduce size (Number of rows) while projection can not reduce number of tuples


Function of squid arms?

for self defence and for projection through the water


The operation performed on the input of a function?

function rule


What is an additive function?

An additive function is a unary function which preserves the addition operation.


What is the operation of a selection sort?

You sort a selected range of cells.


What is the null join?

The join which does not fetch any result that is it returns null value after projection operation is called null join


What is function of NOP instructions?

no operation is not performed


How can cement slurry modefy to enhance its function in oil well cementing operation?

How can cement slurry modefy to enhance its function in oil well cementing operation?


What are the difference between function and operation?

Function is the purpose of something. Operate is how something works.


What is a tail like projection that protubes from the cell body and function locomotion?

You most likely are talking about, "Flagellum".


What is the function of projection?

They increase the surface area of small intestine and thus, increase the rate of absorption of food...