Discussion :: Database Systems - Section 1 (Q.No.23)
|Sudha said: (Apr 24, 2011)|
|What is the use PROJECT command?|
|Sakshi Kalia said: (Nov 16, 2011)|
|PROJECT is not any command. Doesnt exist in DBMS till now.. ;P|
|Hello said: (May 30, 2012)|
|Projection means combining of two tables na? and here its not specified that in DBMS.|
|T.A. Usha said: (Nov 21, 2012)|
|Project selects the columns from the table or a relation. Columns are nothing but fields.
Table need not be a master table alone. So answer (E) is correct.
|Shivakumara T said: (Jun 26, 2013)|
|Project does not exists in dbms, but it exists in relational algebra as a projection, it means that it selects all fields and all rows from the table.|
|Sharon Manmothe said: (Jun 28, 2013)|
|Project is a subset of fields displayed for specific reason.|
|Nitin said: (Aug 1, 2013)|
|The PROJECT operation is used to select a subset of the attributes of a relation by specifying the names of the required attributes.
For example, to get a list of all employees surnames and employee numbers:
PROJECT surname, empno(employee)
|Honey said: (Jul 30, 2019)|
|Project eliminates columns whereas Select eliminates rows.|
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.