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!
UNION
If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both.
In case, R3 will have tuples such that R3 = {t | R1 ∋ t ∨ R2 ∋ t}.
Example
R1
X
Y
A1
B1
A7
B7
A2
B2
A4
B4
R2
A
B
A3
B3
R3 = R1 ∪ R2 is
Q
Note: 1) Union is a commutative operation, i.e, R ∪ S = S ∪ R.
2) Union is an associative operation, i.e.
R ∪ (S ∪ T) = (R ∪ S) ∪ T.
Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi
Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.
what is Nested relational model? Explain with examples.
What are the two methods for dealing deadlock problem? The two procedures for dealing deadlock problem is deadlock detection and deadlock recovery.
Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#
What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.
In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s
Explain the cartesian product in Database Management System
What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known
Before defines the second type of integrity constraint, viz., Entity Integrity, we should be well-known with the concept of NULL. Mostly, NULL is intended as a basis for dealing
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd