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
How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp

Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

Why are cursors necessary in embedded SQL? A cursor is an object used to store the output of a query for row-by-row processing through the application programs. SQL statements

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

The primary key is selected from the

management information system based on functional organisation

Which database object does not physically exist? A view database object does not physically exist.

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve