-
Need guidance with aggregate operations in relational algebra
I'm attempting to solve a problem in relational algebra, but since my professor did not really cover the part of aggregate functions really, I would appreciate if you can guide me in the correct path based on what I've done so far. This is the problem:
branch (branch-name, branch-city, assets, branchid)
client (client-name, client-address, client-city, ssn)
account (account-number, branchid, balance)
depositor (ssn, account-number)
I believe I have the problem correctly written for I had to translate it from Spanish. If it's not the first one, then it should be the second, so I tried to do both just in case.
The number of customers with accounts in the branch with the highest asset.
ρ(A, Dep ⋈Acc ⋈Bran)
Fcount(ssn)(Acc.account-numGMax(assets)(A))
The number of customers with accounts in the branch with the highest quantity of assets.
ρ(A, Dep ⋈Acc ⋈Bran)
Fcount(ssn)(Acc.account-numGMax(count(assets))(A))
Let me know if any other information is required. Thanks.[/SIZE][/SIZE][/SIZE]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|