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
Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Describe the definition of a transaction in SQL  Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and st

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Determine the Derived attribute to avoid re-computation Each class box consists of an ordered list of attributes and operations, each represented as a next string. We can find

Describe the primary key functions? Primary Key : The primary key is an attribute or a set of attributes in which uniquely identify a specific example of an entity. Every entit