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
What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

What is a view? A view is a logical view on one or more tables.  A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Describe the definition of a transaction in SQL  Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and st

1.  Define each of the following IN YOUR OWN WORDS: (a)   File: (b)   Record: (c)   Field: (d)   Primary Key: (e)   Secondary Key: 2.  A travel agency wants t

What are the responsibility of File manager? File Manager : Manager allocation of space on disk storage and the data structures used to represent within stored on disk. It is a


The Maximum no of key fields that can be used in a header is?? 50