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?
What is the difference between .importing and exporting of a database?
What is meant by freezing panes?
A tuple is also known as ______
Which language is used to request information from a Database?
The ______ diagram gives a logical structure of the database graphically?
Which of the following is not a real-life application of database?
Give the term for the following:
DBMS creates a file that contains a description of the data stored in the database.
State any two requirements that should be considered before making an investing decision to choose between 'Server database' or 'Desktop database'.
List any two types of storage devices in DBMS.
