Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 694
|
For the relation loan(loan_number, branch_name, amount), the query{t|t ∈ loan ∧ t[amount] > 1200} gives:
|
The loan_number, branch_name and amount for loans over $1200
|
|
|
The loan_number for each loan of an amount greater than $1200
|
|
|
The branch_name for each loan of an amount greater than $1200
|
|
|
The amount for each loan of an amount greater than $1200
|
Question 694 Explanation:
branch (branch-name, branch-city, assets)
customer (customer-name, customer-street, customer-city)
account (account-number, branch-name, balance)
loan (loan-number, branch-name, amount)
depositor (customer-name, account-number)
borrower (customer-name, loan-number)
→ The loan-number, branch-name, and amount for loans of over $1200
{t | t ∈ loan ∧ t[amount] > 1200}
customer (customer-name, customer-street, customer-city)
account (account-number, branch-name, balance)
loan (loan-number, branch-name, amount)
depositor (customer-name, account-number)
borrower (customer-name, loan-number)
→ The loan-number, branch-name, and amount for loans of over $1200
{t | t ∈ loan ∧ t[amount] > 1200}
Correct Answer: A
Question 694 Explanation:
branch (branch-name, branch-city, assets)
customer (customer-name, customer-street, customer-city)
account (account-number, branch-name, balance)
loan (loan-number, branch-name, amount)
depositor (customer-name, account-number)
borrower (customer-name, loan-number)
→ The loan-number, branch-name, and amount for loans of over $1200
{t | t ∈ loan ∧ t[amount] > 1200}
customer (customer-name, customer-street, customer-city)
account (account-number, branch-name, balance)
loan (loan-number, branch-name, amount)
depositor (customer-name, account-number)
borrower (customer-name, loan-number)
→ The loan-number, branch-name, and amount for loans of over $1200
{t | t ∈ loan ∧ t[amount] > 1200}