Division operation, Database Management System

To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subset of R1. If we perform R1 ÷ R2 than the resultant relation will have those values of A from R1 that are related to all values of B present in R2.

Example

A

B

A1

B1

A1

B2

A2

B1

A3

B1

A4

B2

A5

B1

A3

B2

Let R1

If R2                    R3= R1 ÷ R2                      If R2                       R3= R1 ÷ R2

180_DIVISION operation.png

If R2                  R3= R1 ÷ R2                                               If R2             R3= R1 ÷ R2

1567_DIVISION operation1.png

Figure:  The Division Operation

Note:

               Degree of relation: Degree (R ÷ S)=Degree of R - Degree of S.

Posted Date: 3/6/2013 5:57:47 AM | Location : United States







Related Discussions:- Division operation, Assignment Help, Ask Question on Division operation, Get Answer, Expert's Help, Division operation Discussions

Write discussion on Division operation
Your posts are moderated
Related Questions
Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

What is normalization? It is a method of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to attain the properties (1).Minim

Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known