recategorized
2,465 views
3 votes
3 votes

Division operation is ideally suited to handle queries of the type : 

  1. Customers who have no account in any of the branches in Delhi. 
  2. Customers who have an account at all branches in Delhi. 
  3. Customers who have an account in atleast one branch in Delhi. 
  4. Customers who have only joint account in any one branch in Delhi 
recategorized

1 Answer

1 votes
1 votes

Answer:-Option(B)Customers who have an account at all branch in Delhi.

What division does  :-

Division identify the attribute values from relation that are found to be paired with all of the values from the other relation.

Here (B) is suitable option for this.

Reference 1:-http://www.cs.arizona.edu/~mccann/research/divpresentation.pdf

Reference 2:-http://coronet.iicm.tugraz.at/Dbase1/scripts/rdbh06.htm

Answer:

Related questions

4 votes
4 votes
1 answer
2
makhdoom ghaya asked Jul 20, 2016
4,359 views
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$...
4 votes
4 votes
3 answers
4
makhdoom ghaya asked Jul 20, 2016
4,572 views
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagramGeneralization Aggregation Specia...