C.1 Query-by-Example 3 branch branch_name branch_city assets customer customer_name customer_street customer_city loan loan_number branch_name amount borrower customer_name loan_number account account_number branch_name balance depositor customer_name account_number Figure C.1 QBE skeleton tables for the bank example. loan loan_number branch-name a7710u11f Perryridge QBE(unlike SQL)performs duplicate elimination automatically.To suppress duplicate elimination,we insert the command ALL.after the P.command: 1oa11 loan_number branch_name amount P.ALL. Perryridge To display the entire loan relation,we can create a single row consisting of P. in every field.Alternatively,we can use a shorthand notation by placing a single P.in the column headed by the relation name:C.1 Query-by-Example 3 branch branch_name branch_city assets customer customer_name customer_street customer_city loan loan_number branch_name amount borrower customer_name loan_number account account_number branch_name balance depositor customer_name account_number Figure C.1 QBE skeleton tables for the bank example. loan loan_number branch_name amount P. Perryridge QBE (unlike SQL) performs duplicate elimination automatically. To suppress duplicate elimination, we insert the command ALL. after the P. command: loan loan_number branch_name amount P.ALL. Perryridge To display the entire loan relation, we can create a single row consisting of P. in every field. Alternatively, we can use a shorthand notation by placing a single P. in the column headed by the relation name: