Advertisements
Advertisements
प्रश्न
What is the difference between the Select and Project commands?
फरक स्पष्ट करा
उत्तर
| 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
संबंधित प्रश्न
What is the difference between .importing and exporting of a database?
Write the steps to filter a table.
Which language is used to request information from a Database?
Explain on Evolution of DBMS.
How is a top to bottom relationship among the items in a database established?
Constraints are used to ______.
State or snapshot of a database at any instance is known as ______.
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.
