Define the division operation of relational algebra, Database Management System

Assignment Help:

Define the Division Operation of Relational Algebra

Let R be a relation comprising attributes (A1,...Ap,Ap+1,...An) and S comprising attributes (Ap+1,...An) 

DEF: Division

The division of R by S, represented R ÷ S, provides a new relation Q, the quotient of the division, like Q has attributes (A1...Ap) and every tuple of Q must take place in R in combination along with every  tuple in S. 

The division can be acquired from the difference, the Cartesian product and the projection like this:

 R ÷ S = T - Y, where T = πA1,...Ap (R ) and Y =  πA1,...Ap ( (T X S) - R)


Related Discussions:- Define the division operation of relational algebra

Design and building a distributed information system, prototype of a distri...

prototype of a distributed information system for a national car part retail outlet chain.

Examine about the behavioural diagrams, Examine about the Behavioural Diagr...

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

What do you understand by raid, What do you understand by RAID? Explain RA...

What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

On laod, how to write a in a text and load it on mysql

how to write a in a text and load it on mysql

Management information system, management information system based on funct...

management information system based on functional organisation

What is substitutability, What is substitutability? Any method of a cla...

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

Determine the language that needs a user to specify the data, Determine the...

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

Identify the candidate keys, Consider the following six relation schemes an...

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for

Data replication, Data Replication "If a relation R has its copies kept...

Data Replication "If a relation R has its copies kept at two or more sites, then it is considered replicated". But why do we replicate a relation? There are several advan

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