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
संबंधित प्रश्न
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
What is the use of legends in a chart?
__________ is a collection of related data.
Users can work on DBMS using ______.
______ is known as skeleton of database.
What do you call the database catalogue where DBMS stores database schema along with various constraints?
Which is not a limitation 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'.
What is meant by date-transfer rate?
