Explain projection operation distribute over union operation, Database Management System

Assignment Help:

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.   

Ans: ΠL(E1 ∪ E2) = (ΠL(E1)) ∪ (ΠL(E2))  

This says that result acquired by projecting on an attribute set A, after taking union of two relations is similar as union of two relations each of which is a projection of original relations on A.


Related Discussions:- Explain projection operation distribute over union operation

Checkpoint, what is check point in database management system

what is check point in database management system

2phase locking, we need example of 2phase locking

we need example of 2phase locking

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Types of attributes, Attributes attached to an entity can be of various typ...

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

What type of view of total database content, What type of view of total dat...

What type of view of total database content? Data base content Conceptual view of total database contain.

Oracle, List and explain the memory constructs of the Oracle 12c databases?...

List and explain the memory constructs of the Oracle 12c databases?

Determine the objectives of object oriented design, Determine the Objective...

Determine the Objectives of object oriented design provide an overview of object oriented design; partitioning system to subsystems; describe how a software desig

Explain differance between primary and secondary storage, Explain differanc...

Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

What is data integrity, What is data integrity? Ans: It is the data con...

What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd