Advertisements
Advertisements
Question
What is the difference between the Select and Project commands?
Distinguish Between
Advertisements
Solution
| Select | Project | |
| The SELECT operation(o) is used for selecting a subset with tuples according to a given selection condition. | The projection method(n) eliminates all attributes of the input relation but those mentioned in the projection list. | |
| The SELECT operation (o) selects filters out all tuples that do not satisfy the condition. | The projection method defines a relation that contains a vertical subset of Relation. | |
| Symbol: σ | Symbol: π | |
| General Form: σ (R) c Example: σ = “Big Data” (STUDENT) course |
Example: π (STUDENT) course |
|
shaalaa.com
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
What is meant by cell address?
State any one method of removing data from a cell in a spreadsheet.
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
Which language is used to request information from a Database?
The ______ diagram gives a logical structure of the database graphically?
What is meant by Database Partitioning?
What is not a DBMS?
State the following rules of DBMS.
Referential Integrity
Mention the symbol which specifies the fixed columns or rows in a formula.
List any two types of storage devices in DBMS.
