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
Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.

Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy.  b. Domain constraints, functional dependency

define normalisation and functional dependency

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas

Which is another name for weak entity? Child is another name of weak entity.

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad