Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
The PROJECT operation
The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏
(Relation) Example:
Consider the relation PERSON. If you want to display only the names of persons then the project operation will be used as follows:
Π Name (PERSON)
The resultant relation will be as follows:
NAME
Sanjay Prasad
Sharad Gupta
Vibhu Datt
Note: -
1) Π ( Π (R))= Π (R)
As long as have attributes in .
what is Nested relational model? Explain with examples.
What is schema
Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati
Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE
What is an Operand? The data on which the operation is to be performed is known as an Operand
Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql
What is a database? At any given time, they're storing a tremendous amount of information - inventory, in the case of Amazon, messages and interrelationships in the case of Tw
What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y
why we fregment at all?
What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd