Question

(b) In a Bank's database, there are two tables Customer and Transaction" as shown
below
Customer
Acc No Cus_Name Cust_City
2101001 Sunita Ambala
2201002 Sandhya
2301003 Vivek New Delhi
1401004 Meena New Delhi
Cus_Phone Open_Bal
971055761410000
8223545233 15000
9972136576 13000
9321305453 10000
Transaction
Trans Id
Tr002
Tr003
Tr004
"Tr005
Acc No
2301003
2201002
2101001
2301003
2301003
Transaction Type Amount
Credit
15000
Credit
20000
Debit
3500
Credit
Credit
24000
Consider these tables while attempting the questions given below:
(1) Identify the candidate keys of Customer table
OR
(i) Briefly explain the concept of Candidate keys
(ii) Which column can be considered as foreign key column in Transaction table?
OR
(i) Identify Primary key column of Transaction table​

Answer 1

Answer:

(b) In a Bank's database, there are two tables Customer and Transaction" as shown

below

Customer

Acc No Cus_Name Cust_City

2101001 Sunita Ambala

2201002 Sandhya

2301003 Vivek New Delhi

1401004 Meena New Delhi

Cus_Phone Open_Bal

971055761410000

8223545233 15000

9972136576 13000

9321305453 10000

Transaction

Trans Id

Tr002

Tr003

Tr004

"Tr005

Acc No

2301003

2201002

2101001

2301003

2301003

Transaction Type Amount

Credit

15000

Credit

20000

Debit

3500

Credit

Credit

24000

Consider these tables while attempting the questions given below:

(1) Identify the candidate keys of Customer table

OR

(i) Briefly explain the concept of Candidate keys

(ii) Which column can be considered as foreign key column in Transaction table?

OR

(i) Identify Primary key column of Transaction table