Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 1 (Q.No. 23)
23.
The PROJECT command will create new table that has
Discussion:
11 comments Page 1 of 2.
Nitin said:
1 decade ago
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)
For example, to get a list of all employees surnames and employee numbers:
PROJECT surname, empno(employee)
Rishitha said:
2 years ago
The projection operator π is one of the unary operators in relational algebra (RA) and is used to project columns from a relation. It can select specific columns from a given relation and hide all the other columns.
T.A. Usha said:
1 decade ago
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.
Table need not be a master table alone. So answer (E) is correct.
Shivakumara T said:
1 decade ago
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.
Giridhar said:
4 years ago
It is known as vertical partitioning since it selects only those columns which matches particular query.
Rahul said:
11 months ago
The PROJECT command creates a new table with a specific subset of columns from an existing table.
(1)
Hello said:
1 decade ago
Projection means combining of two tables na? and here its not specified that in DBMS.
Sakshi Kalia said:
1 decade ago
PROJECT is not any command. Doesnt exist in DBMS till now.. ;P
Sharon Manmothe said:
1 decade ago
Project is a subset of fields displayed for specific reason.
Honey said:
6 years ago
Project eliminates columns whereas Select eliminates rows.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers