Project operation, Database Management System

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 ∏

1913_relation.png

(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







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
Related Questions
The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su

State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori