銀行場景的關(guān)系代數(shù)我有一種無處可去的情況。我不知道如何解決關(guān)系代數(shù)問題。Deposit (Branch, Acc-No, Cust-Name, Balance)
Loan (Branch, Loan-No, Cust-Name, Balance)
Branch (Branch, Assets, Branch-County)
Customer (Cust-Name, Cust-County, Branch)生成一個(gè)關(guān)系,顯示貸款大于GB 2500.00的所有客戶和所有存款賬戶余額小于GB 100.00的客戶的分支機(jī)構(gòu)、客戶名稱、余額和帳戶號。所有的顧客都應(yīng)該在隆福分店。這是我到目前為止想出來的。是對的嗎?π Branch, Acc-No, Cust-Name, Balance (
σ(Loan.Balance > 2000 ∧ branch='Romford')(Loan)
∪ σ(Deposit.Balance < 150 ∧ branch='Romford')(Customer ∩ Deposit)
)正確的回答是: π Branch, Cust-Name, Balance, Acc-No,
(σ Balance < 100^branch=”Romford” (Deposit))
∪
π Branch, Cust-Name, Balance, Loan-No,
(σ Balance > 2500 ^branch=”Romford”(Loan))
銀行場景的關(guān)系代數(shù)
慕容708150
2019-07-02 14:34:14