E-R Diagram

A Bank wants to computerize all of its transactions. It offers the following account types:
Savings Bank (SB), Recurring Deposit (RD), Fixed Deposit (FD)
The Bank also wishes to keep track of loans given to the customers. Identify the entities
and its attributes with all possible relationships. Write the ER diagram and state clearly
the assumptions that you make. The following assumptions may be considered:
(a) A customer can have only one type of account.
(b) Joint accounts are not allowed.Loans can be taken only when the customer has at
least one of the account types.

karmjit joshi @karmjitjoshi
2 Oct 2017 05:42 pm
shivani @shivani1234
2 Oct 2017 07:18 pm

cust_id -> account_type // since, it is given a customer can have only one account
cust_id , account_id -> loan_id // since , it is given that loan will be given to customer only when he has an account

karmjit joshi @karmjitjoshi
2 Oct 2017 08:34 pm

thanks shivani1234. please also tell me the er- diagram of this

karmjit joshi @karmjitjoshi
7 Oct 2017 07:29 pm

Anyone answer?