The PROJECT operation

The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

(Relation) Example:

Consider the relation PERSON. If you want to display only the names of persons then the project operation will be used as follows:

Π Name (PERSON)

The resultant relation will be as follows:

NAME

Sanjay Prasad

Sharad Gupta

Vibhu Datt

Note: -

1) Π ( Π (R))= Π (R)

As long as have attributes in .

Posted Date: 3/6/2013 5:52:30 AM | Location : United States

Ask an Expert

Related Discussions:- Project operation, Assignment Help, Ask Question on Project operation, Get Answer, Expert's Help, Project operation Discussions

Write discussion on Project operation
Your posts are moderated

Write your message here..

Related Questions

Balance transfer, Scenario 1: Power goes out after the first instruction. ... Scenario 1: Power goes out after the first instruction. What happens?

Doppler Effectabase Management , #question. Draw a picture of a moving sour... #question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the

Structure of distributed database, Structure Of Distributed Database: A di... Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Why like predicate used for, Why Like predicate used for? LIKE predicat... Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

ANSI SPARC architecture, explain ANSI SPARC architecture explain ANSI SPARC architecture

Define 1 nf normal form, 1 NF Normal Form The domain of attribute must... 1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat

Selective replication-data replication, Selective replication: This is a c... Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require

Designing the fields in the data base, Designing the fields in the data bas... Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en

I want to get database of a website, Project Description: I would like t... Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

design the logic using looping structure, 1. Design the logic, using a loo... 1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme