In the ACCOUNT relation shown below Acc.Number Name Balance�

1.	In the ACCOUNT relation shown below Acc.Number Name Balance Type1000Simon1,50,000SB1001Abey2,00,000SB1002jambal1,00,000SB1003Ram2.50,000SB(a) Identify the primary keys and candidate keys. (b) Select all account holders with balance greater than Rs. 2,00,000.
Answer» a) Primary key-ACC. Number Candidate keys – Name and Balance b) σ_{2Balance>200000} (ACCOUNT) OR Select * from Account where Balance>200000

In the ACCOUNT relation shown below Acc.Number Name Balance Type1000Simon1,50,000SB1001Abey2,00,000SB1002jambal1,00,000SB1003Ram2.50,000SB(a) Identify the primary keys and candidate keys. (b) Select all account holders with balance greater than Rs. 2,00,000.

Answer»

a) Primary key-ACC. Number

Candidate keys – Name and Balance

b) σ_{2Balance>200000} (ACCOUNT)

Select * from Account where Balance>200000