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
Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Use of partial data by applications : In common, applications work with views rather than whole relations. Thus, it may be more appropriate to work with subsets of relations rather

Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

What is Normalization? Database normalization is a data design and organization method applied to data structures based on rules that help building relational databases. In rel

What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de