navaneethan
August 27th, 2010, 06:25 PM
*Bank keeps record of customers which includes cutomer_id, customer_name and DOB.
* Customers who keep more than 10 lakhs across all their accounts have a "relationship manager" in the bank.
* Bank also keeps data about employees that includes employee_id, employee_name and employee_address.
* Each account will have an account_number, balance and recent date of access. The bank also offers the facility of joint account.
* The Bank also offers the Loan facility to the customers. Each loan has a loan_id and the amount of Loan. The facility of joint loans is also available.
I have drawn the Entity diagram for the above requirements here CLick (http://twitpic.com/2ior9o)
please experss can give the suggestion here I am hungry this
* Customers who keep more than 10 lakhs across all their accounts have a "relationship manager" in the bank.
* Bank also keeps data about employees that includes employee_id, employee_name and employee_address.
* Each account will have an account_number, balance and recent date of access. The bank also offers the facility of joint account.
* The Bank also offers the Loan facility to the customers. Each loan has a loan_id and the amount of Loan. The facility of joint loans is also available.
I have drawn the Entity diagram for the above requirements here CLick (http://twitpic.com/2ior9o)
please experss can give the suggestion here I am hungry this