Advertisements
Advertisements
प्रश्न
What is the difference between the Select and Project commands?
अंतर स्पष्ट करें
Advertisements
उत्तर
| 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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
APPEARS IN
संबंधित प्रश्न
Write the steps to filter a table.
A tuple is also known as ______
Explain the characteristics of DBMS.
How is a top to bottom relationship among the items in a database established?
List the components of storage manager.
The design of the database is known as what?
Constraints are used to ______.
State or snapshot of a database at any instance is known as ______.
The underlying component or set of programs used by DBMS to create the database and handle various queries for data retrieval and manipulation is known as ______.
Give the term for the following:
DBMS creates a file that contains a description of the data stored in the database.
